VERIFIED SOLUTION i

Explorer - Visual Dialogue error Data: Field '' not found

Product Feature: Upgrade

 

Issue

After upgrading to Portrait Dialogue 6.2  the following Error message appears:
Explorer - Visual Dialogue error Data: Field 'xx_xxxxxxxx_xxxxxx' not found 

Example:  Explorer - Visual Dialogue error Data: Field 'do_schedule_details' not found 
Explorer - Visual Dialogue error Data: Field 'do_schedule_details' not found

 

Cause

When upgrading Dialogue to a new version, it is always required to run the appropriate Database Upgrade script or scripts.
The appropriate script is determined by the version you were on before doing the upgrade, and the version you are upgrading to.
Some scripts will upgrade the database incrementally from one version to the next, while others upgrade from any previous version.
There are SQL Server versions and Oracle versions.
These scripts are found in the distribution media, in the \SQL\UpgradeScripts\ folder.

Similar problems may arise if there is a failure to run the RefreshSystemData tool which is located in the distribution media, in the  \SQL\SystemData\ folder.

 

Resolution

UPDATED: September 25, 2018
Determine the script or scripts you need to run by viewing either the user manual or patch/update readme file, and run them.
Always make sure to run the RefreshSystemData tool.