Consultor Eletrônico



Kbase P11714: Error 49 from a trigger calling a internal procedure from target procedure
Autor   Progress Software Corporation - Progress
Acesso   Público
Publicação   25/09/2008
Status: Verified

SYMPTOM(s):

Error 49 from a trigger calling a internal procedure from target procedure

Same record is updated, refetched, updated again, etc, etc, etc

FACT(s) (Environment):

Progress 9.1C
Sun Solaris SPARC
OpenEdge Category: Language (4GL/ABL)

CAUSE:

The constant refetching and updating of the same record within a single transaction caused many copies of 'shadow' buffers to be created. The database write trigger became confused when attempting to map the current and previous buffer to the current buffer and previous buffer parameters.

FIX:

Modify the application source code to use a single shared buffer and remove the unneeded find statements