About the Common Validation Rules for CM Tool

The following validation rules are available for use when packing and unpacking Aptify data.

• 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.
• 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.
• 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.
• 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.
• 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.
• 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.

• 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:
  
  

  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) 

• 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.
• 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.
• 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.
• Application entity fields with blank param name: Param name is required field. Entity fields with blank param name must be identified before packing.
• 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.
• 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.
• 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.
• Base Table Not Generated on Database: Verify the Entity list present in Entity Entities but the base table is not created on the Aptify database.
• Validate Entity's Link Entities Record: The listed entities have failed validation due to missing Linked Entities records. Please ensure the listed Linked Entities are present in the destination server before unpacking the entities.