Return
-
Title
Database error 547: 'The INSERT statement conflicted with the FOREIGN KEY constraint "HDB_1396"' -
Description
The process which transfers Identity Manager data from the main database to the history database, "QBM_TransportToHistoryDatabase", stopped working with the following error:
[810143] Database error 547: The INSERT statement conflicted with the FOREIGN KEY constraint "HDB_1396". The conflict occurred in database "xxxxxx", table "dbo.RawProcess", column 'GenProcID'.
The statement has been terminated. -
Cause
In the case of History Database (HDB) import, by calling the QBM_PProcessGroupCreate, related DialogProcesses are combined in groups and provided with a GenProcIDGroup. Then all DialogProcesses that have a GenProcIDGroup are exported to the HDB.
In certain situations, two processes connected via DialogProcessSustitute get a GenProcIDGroup and the other doesn't:
The DialogProcess of the "GenProcIDOrigin" gets a GenProcIDGroup - this is exported.
The DialogProcess of "GenProcIDNew" does not get a GenProcIDGroup - it is therefore not exported. -
Resolution
WORKAROUND
None
STATUS
Please request Support to provide Hotfix #36438. -
Change Request
36438