Database error 547: 'The INSERT statement conflicted with the FOREIGN KEY constraint "HDB_1396"' (4370066)

Database error 547: 'The INSERT statement conflicted with the FOREIGN KEY constraint "HDB_1396"'

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.

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.

WORKAROUND

None

STATUS

Please request Support to provide Hotfix #36438. This fix has been included in 9.0 LTS cumulative update 2 and above.

36438