Kbase P17257: PROGRESS session terminates using DataServer with foreign database constraints and/or triggers.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/15/2008 |
|
Status: Verified
FACT(s) (Environment):
Progress 9.1x
MS SQL
Oracle
SYMPTOM(s):
PROGRESS session terminates using DataServer with foreign database constraints and/or triggers.
Trying to perform operation not permitted with the foreign database constraint rules and/or triggers fails and Progress session terminates.
The foreign database trigger errors out with exceptions and rolls back transaction
SYSTEM ERROR: bfdel: rmdel failed. (10)
Duplicate unique key in database table. (1443)
Dr.Watson failes on bfdel function
Stack trace from prowin32 reads:
rnCkDelete
rnbfdelMain
rnbfdel
rnexec_entry
23000:[Microsoft][ODBC SQL Server Driver][SQL Server]DELETE Statement
conflicted with COLUMN REFERENCE constraint 'FK_order_customer'. The
conflict occurred in database 'mssports', table 'order_',column 'custnum'.
01000: [Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been
terminated.
CAUSE:
Bug# 20030113-001 for MS SQL
Bug# 20030113-001 for Oracle
CAUSE:
The DataServer does NOT expect to recieve such an error from foreign database trigger. The dataserver treats it as a fatal error and produces a core file
FIX:
Create the Progress database triggers enforcing the existing rules for the constraints and foreign database triggers.