DATABridge is not removing deleted entries from the database.
Technical Note USA11475Created 15-Feb-2005Applies To
DATABridge Client for Oracle
DATABridge Clients
Symptoms
DATABridge is not removing deleted entries from the database.
Cause
There is only one scenario where DATABridge does not update the records and instead does an insert. This is when allow key changes is allowed in the DMSII database, if this is true follow the below instructions to resolve the issue.
Fix
1. Uncomment the check_key_changes option in the config file and set it to yes.
2. Set the status_bits for the table in question to 4 to force a redefine.
3. Set the ds_mode for this to a 0 for recloning.
After the above three steps proceed as normal.