Kbase P128623: Errors sending messages to Sonic Adapter from DB trigger
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
30/01/2008 |
|
Status: Unverified
FACT(s) (Environment):
All Supported Operating Systems
OpenEdge 10.1x
SYMPTOM(s):
Errors sending messages to Sonic Adapter from DB trigger
Attempt to disconnect a <table> record, which is running a trigger. (2869)
Input blocking statement is invalid while updating a record from the Browser. (4383)
CAUSE:
The design of the adapter ABL code uses a WAIT-FOR PROGRAM-COMPLETE when deleting the session to avoid memory leaks during object cleanup. This causes problems when called by a database trigger when the buffer for the table being updated is currently being browsed by a browser query.
The ABL error is necessary but the design flaw is a known issue.
FIX:
The workaround for this issue is to use a separate buffer for updates when browsing a table that is known to call Sonic from its trigger code.