VERIFIED SOLUTION i

Resolving Portrait Dialogue Error: "SQL Definition named 'nnnnn' not found in the SQL Repository"

Issue

After a Portrait Dialogue upgrade, or the application of a Hotfix, an error appears "Resolving SQL Definition named '(NameOfRecord)' not found in the SQL Repository"

The error message is:
 
Dialogue Server: Operation failed
Dialog: Dialog name (DialogID)
Operation: Operation name(OperationID)
Branch#:
Exception type: EMHSqlNotFound
Error message: SQL Definition named 'NameOfRecord' not found in the SQL Repository
 
 

Cause

One of the version upgrades in the defined upgrade path was missed.

A part of every Upgrade is to Refresh System Data.
This refresh adds the data and SQL portions of any new functions and features.

Please note that the refreshing of System Data is also required as a part of some HotFixes.

Resolution

UPDATED: March 28, 2018
Run the Refresh System Data as described in the Upgrade Documentation, or the Hotfix Readme file.