The following validation rules are available for use when unpacking CM Tool packs.

Foreign Keys

Validates foreign keys. If, within the tested database, there is a reference to a table that does not exist, correct to ensure data integrity and proper database behavior.

Solution

Ensure entity link fields are present for all linked entities. In addition, check that foreign key references are valid.

Missing/Incorrect Database Objects

Validates all database objects have valid Database Objects record references. Including views and stored procedures. 

Solution

1. Open the entity(s) listed and go to DB Object tab.
2. Verify that the linked database object is valid, if not create or link a valid database object. 

Entity Required Fields

Validates that all required fields are marked as required. In earlier versions of Aptify there are fields that were not required, but are now required.  These values must be updated to ensure that these records are transferred during data unpacking.

Solution

1. Open the Entity records(s) from above list.
2. Open the field in question and go to the Validation Tab.
3. Check the Is Required option.

Validate Entity Link to Application for Dashboard

Validates reference entities exist on the destination server for dashboard data. You must install below entities on the destination server prior to unpacking this dashboard data.

Solution

1. Compare the listed entities on the destination server with the pack from the source server.
2. If the entities do not exist on the destination server, create those entities on the destination server before unpacking the dashboard data. 

Validates Views Dependency

Validates all views have appropriate dependencies in the pack or on the destination server. The following views may fail to unpack due to missing fields, base views, and/or database objects.

Solution

1. Open the view(s) listed.
2. Verify the base view associated with the view.
3. Verify the fields and database objects added that are part of the view.
4. These base views, fields and database objects should be included in the pack or should be exist at destination database.

Validate Entity Link to Form Template

Validates reference entities exist on the destination server for form template data. You must install below entities on the destination server prior to unpacking this form template data.

Solution

1. Compare the listed entities on the destination server with the pack from the source server.
2. If the entities do not exist on the destination server, create those entities on the destination server before unpacking the form template data. 

Validate DBObject Dependency

Validates all database objects have appropriate dependencies in the pack or on the destination server. The database object may fail to unpack because of database object dependencies listed in the table below due to missing fields and/or database objects.

Solution

1. Open the database object(s) listed.
2. Verify the fields and database objects added that are part of the object.
3. These fields and database objects should be included in the pack or already exist on the destination server.

Validate Multiple Base View Dependency

Validates all entity have appropriate base view dependencies in the pack or on the destination server. The following entities may fail to unpack because of base view dependencies listed in the table below due to missing fields and/or database objects.

Solution

1. Open the entity record(s) listed.
2. Select the Base Views tab. Verify the fields and database objects that are part of the base view.
3. These fields and database objects should be included in the pack or already exist on the destination server.