Kbase P99524: Client session terminates when violating the "delete" constraint
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
4/7/2006 |
|
Status: Unverified
FACT(s) (Environment):
ODBC DataServer
OpenEdge 10.0B
OS/400 V5R2
SYMPTOM(s):
Client session terminates when violating the "delete" constraint
Data Direct DB2 Wire Protocol driver v.4.20.0.104
A program ends just after confirming the UDB/400 error message that informs about constraint violation
No Progress DataServer message is generated
CAUSE:
Bug# 20050131-002
CAUSE:
The DataServer does not expect to receive such an error from foreign database and raises the STOP condition
FIX:
Upgrade to 10.0B04
If the upgrade is unfeasible for any reason, the only workaround is to create a Progress database "on delete" trigger that will handle the error condition in a desired fashion, for example:
TRIGGER PROCEDURE FOR DELETE OF TABLE.
find first TABLE OF TABLE no-lock no-error.
IF avail(TABLE) then
do:
message "Delete not allowed" view-as alert-box.
return error.
end.