The following validation rules are available for use when packing and unpacking Aptify data.
Anchor _Toc383705977 _Toc383705977 Foreign Keys: Validates the integrity of the database. If, within the tested database, there is reference to a table that does not exist, this must be corrected to ensure data integrity and the proper behavior of Aptify.anchor_Toc383705978 _Toc383705978 - Missing/Incorrect Database Object Reference: A validation step to find all database objects referenced in the entities that are not referenced within a Database Objects Record. This would include views and stored procedures.
Anchor _Toc383705979 _Toc383705979 - Invalid untrusted users: Trusted user records that have moved from server to server during an entity unpacking action may have originated in a different domain. These users would have been saved to the target server as untrusted. Validation present in Aptify 5.0/SQL 2005 prevents saving untrusted users when a '\' character is present. The following user records were found on the source server which matches this condition. These user records should be removed or the user name altered to remove the '\' character.
Anchor _Toc383705980 _Toc383705980 - Unlinked Stored Procedure to Generated Entity: Generated Entity records linked to Database objects that are referenced when records are linked, updated, or deleted. These database objects are linked by name. If they are not linked, links must be created.anchor
_Toc383705981 _Toc383705981 Entity Fields [calculated] Database Objects: To ensure that the database objects used within calculated fields are transferred with the entity, they should be linked to the entity through the entity's DB Objects tab.Anchor _Toc383705982 _Toc383705982- Specific Entity Field Validator: The Entity Field Definition is found in the Entity Fields Entity and the Base Table for the Entity. This rule verifies that the two sets match.
Anchor _Toc383705983 _Toc383705983 Missing/Incorrect Entity Linked Object Repository Object Reference: A validation step to find all Entity linked object repository references that do not exist due to a bad reference or from the removal of the object. A List of Objects which are referenced but do not exist can be found with the following query:
...
No Format nopanel true SELECT EntityID,RepositoryObject
...
FROM [ENTITY_DATABASE]..EntityrepObjRequirement
...
WHERE RepositoryObject <> '' AND RepositoryObject NOT IN(
...
SELECT p.Name + '.' + ob.Name
...
FROM [ENTITY_DATABASE]..ObjectRepositoryObject ob INNER JOIN
...
[ENTITY_DATABASE]..ObjectPackage p ON p.ID = ob.ObjectPackageID)
...
Anchor _Toc383705984 _Toc383705984
- Database Objects with GRANT SQL in the SQL Text: SQL Text and the Grant SQL is to be contained in segregated fields, but due to legacy processes, there are instances where these are both included in the SQL text field. This should be corrected by moving the Grant SQL to the Grant SQL tab.
Anchor _Toc383705985 _Toc383705985 - Missing Base Views: Any base Views not contained within APTIFY as an Database Object Record will not be transferred. Consider creating a DB Object Record for any view found within this validation, and link it to an appropriate Entity. Otherwise, you will need to manually create the view on the destination.
Anchor _Toc383705986 _Toc383705986 - Invalid NULL Default Value for Entity Fields: Entity Fields with a numeric SQL Data Type cannot have a default value of NULL. You will need to change this value or the entity will not unpack on the destination.
Anchor _Toc383705987 _Toc383705987 Application entity fields with blank param name: Param name is required field. Entity fields with blank param name must be identified before packing.Anchor _Toc383705988 _Toc383705988- Indexes not Generated by Aptify: There are some Indexes those are not created by Aptify for Non-Framework Entity and those are directly created on the database level.
_Toc383705989Anchor _Toc383705989 - Missing Object Repository Items: A validation step to find all Object Repository objects that do not exist in the database. All icon related objects can be ignored, but all other missing items must be relinked or the reference must be removed.
Anchor _Toc383705990 _Toc383705990 Unlinked Stored Procedures to Entity or Database Object: The Stored Procedure validation is looking for any Non-Generated database objects that are not linked to an entity or database object. Any item in this list will not be moved in the upgrade. It is recommended that these are linked or they must be moved manually.Anchor _Toc383705991 _Toc383705991- Base Table Not Generated on Database: Verify the Entity list present in Entity Entities but the base table is not created on the Aptify Databasedatabase.anchor
_Toc383705992 _Toc383705992 - Validate Entity's Link Entities Record: The listed entities have failed validation due to missing Linked Entities records. Please make sure ensure the following listed Linked Entities should are present in the destination server before unpacking the entities.