This topic provides information on troubleshooting issues that you may encounter running the Aptify 5.5.3 or Aptify Web 5.5.3 setup.

Troubleshooting issues with installing Aptify 5.5.3 is addressed in the following sub-topics:

• Installation Fails During Update of Orders Entity
• Circular References with Form Templates or Dashboard
• Scenarios Where Setup May Fail Due to Entity Updates and Required Fields
• Grant SQL Cannot Generate a Field that Does Not Exist in the Base View and Field Level Security
• Aptify Web Site May Fail to Load Certain DLLs

If you experience an error not described below, please contact Aptify Technical Support for assistance.

Installation Fails During Update of Orders Entity

If your organization has modified the Orders entity, it is possible that the Aptify 5.5.3 installation may fail when the setup program is updating the Orders entity while attempting to update virtual field definitions for the ShipToEmail and BillToEmail fields to support company only orders. Perform the following steps if the installation fails as described in this scenario.

1. Open the record for the Orders entity in the Entities service.

2. Set the definition for the ShipToEmail virtual field:

   ShipToEmail –Set virtual Field Type = Calculated
   
   Set below Calculation: 
   Case p2.LastName
   when '[Not Specified]' then c1.MainEmail
   else
   p2.Email1
   End

3. Set the definition for the ShipToEmail virtual field:
   
   BillToEmail –Set virtual Field Type = Calculated
   
   Set below Calculation:
   Case p3.LastName
   when '[Not Specified]' then c.MainEmail 
   else
   p3.Email1
   End
   
   

4. Set the definition for the BillToName virtual field:
   
   Update below Calculation:
   (RTRIM(p2.FirstName) + ' ' + LTRIM(p2.LastName))
    

5. Save and close the Orders entity record.
   
   

The Aptify 5.5.3 database setup may fail if a form template or dashboard circular reference error is found. In Aptify 5.5, Aptify added the Unique Identifier for form templates to prevent circular reference errors, so you should not see this error on systems that originated from 5.5. However, you may see this issue if you database was at one point an earlier version (5.0 SP3 and earlier).

The setup process catches these during installation (the setup will provide information about the affected form templates and dashboards in the Installation log). These references will need to be corrected before installation can continue.

Below is an example of a form template circular reference that was found during multiple client database installation tests. There are two sub-templates (IDs 8167 and 8173) that hold a circular reference back to itself via its children.  The part lists are the same as the part list for another sub-template (ID: 8170 for 8167 and 8174 for 8173).  In short, the part lists for form templates 8167 and 8173 are incorrect.  The part lists should be deleted and replaced with the following:

• For 8167, the parts list should look like this after the correction:
   

• For 8173, the Parts List should look like this after the correction:

You can then re-run the setup, you do not need to restore the database to prior to previous installation attempt.

Scenarios Where Setup May Fail Due to Entity Updates and Required Fields

If an entity has a required field that does not have a default value, the installation may fail. If this occurs, follow these steps to resolve the problem:

1. Identify which required field does not have a default value based on the error information provided by the setup program.
2. Restore the database back to its original state prior to the installation attempt which failed.
3. Open the appropriate entity and specify a default value for the field you identified in step 1.
4. Save and close the entity.
5. Rerun the Aptify 5.5.3 setup program.

If an entity has a field that is not part of the base view, the installation may fail. For example, Aptify 5.5.2 added a new field to Companies called Logo. This can be a problem for certain databases whose entity meets these conditions:

• There are fields in the entity definition that do not exist in the base view’s SELECT statement.
• The SQL Text for the entity’s base view is non-generated.
• The Grant SQL Text for the entity’s base view is generated.
• The entity has Field Level Security enabled.

If an organization has an that entity meets all of the conditions listed above and the 5.5.3 setup program is adding or new field to that entity, then the 5.5.3 setup program will fail. The workaround is as follows for the example above:

1. Turn off the Grant SQL Text Generation for the entity's base view (backend update) .
2. Update the entity (for example, add the new field manually).
3. Manually add the new field to the entity's SQL Text and to the all the Grant statements from the appropriate Database Objects records.
4. Turn on Grant SQL Text Generation (backend update).
5. Re-run the setup, if possible, on a restored backup from prior to installation.

When launching the Aptify web site, certain 32-bit DLLs in the AptifyServicesAPI Bin folder may prevent the site from loading – most notably is ConfigManifestForm.dll, which may exist on systems that have been through a major version upgrade. The workaround is to remove these DLLs and any dependencies from the AptifyServiceAPI folders and then load the site again. Contact Aptify Technical Support if you have questions or concerns about removing objects from the AptifyServiceAPI folder.