-
Title
HDB Database consistency check runs into error: Invalid column name 'XObjectKey' -
Description
Prior to upgrading a History Database from earlier versions before v8.0.5 and 8.1.2 (but v8.x.x), a consistency check on the HDB returns errors for tables HistoryChain or ProcessInfo about missing column XObjectKey like the below:
"
[810023] Error during execution of statement: select 'HistoryChain' as TableName, 'BasisObjectKey' as ColumnName, ac.BasisObjectKey as InvalidValue
from HistoryChain ac left outer join DialogDeferredOperation p on ac.BasisObjectKey = p.XObjectKey
where ac.BasisObjectKey like 'DialogDeferredOperation%'
and p.XObjectKey is null
at VI.DB.DataAccess.ReadOnlyDbSession.d__36.MoveNext()
[810143] Database error 207: Invalid column name 'XObjectKey'.
Invalid column name 'XObjectKey'."
-
Cause
Development has provided additional information using ProcessInfo as an example:The objects in ProcessInfo table in HDB holds the historic process information imported from OneIM Main database into HDB. The objects hold ObjectKeys which point to Objects in JobHistory in the Main DB but not in the HDB. The ObjectKey field is marked as a dynamic FK which is a construct in OneIM Main Database to refer any target table by its XObjectKey.The JobHistory in HDB does not have an XObjectKey, this is a special scenario where of a virtual reference which is not caught by the consistency check which now tries to verify that ProcessInfo.ObjectKey points to an existing object. The consistency check for these tables was generated dynamically based on DialogTable, DialogColumn and the present data in the available tables. However this is built in a wrong way for HDB.In this case the error can be ignored because the recorded target data might also have been archived and removed from OneIM database as well. The ObjectKey reference in HDB (in this instance) is only for informational purposes. Note that some of the keys of history tables might point to nowhere. -
Resolution
WORKAROUND
Ignore the errors with "Invalid column name 'XObjectKey'" in HDB Database consistency check.
STATUS
Development has acknowledged a change request under Enhancement ID #32333. A hotfix is available for v8.1.0 from Support. Please contact Support with your version number for more information. -
Change Request
32333