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

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

There are always orphaned entries in table DialogProcessSubstitute.

The following statement very often provides a result:

select * from DialogProcessSubstitute
where 
    not exists (
    select 1 from DialogProcess
    where DialogProcessSubstitute.GenProcIDNew = GenProcID
    ) or not exists (
    select 1 from DialogProcess
    where DialogProcessSubstitute.GenProcIDOrigin = GenProcID
    )

So if there is an entry in DialogProcessSubstitute that points to an entry in table DialogProcess that does not exist, this can lead to errors during the History Database (HDB) transfer.  This inconsistency will be fixed during the next run of the "QBM-K-CommonProcessShrink" - the task will be run via the schedule "Reduce logs" once a day.  But if this has not run, it will block the HDB transfer.

This is a product defect (36645).

WORKAROUND

Execute "QBM-K-CommonProcessShrink" 

STATUS

This will be fixed in a future release of the product. If you require this immediately corrected, please contact Support for a hotfix referencing the defect ID 36645.

36645