Kbase P68725: Intermittent error 6485 with Oracle dataserver application
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
23/02/2004 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.x
FACT(s) (Environment):
OpenEdge 10.x
FACT(s) (Environment):
Oracle DataServer
SYMPTOM(s):
Intermittent error 6485 with Oracle dataserver application
Only no undo temp tables maybe emptied during an active transaction (6485).
Error does not always happen, and it did happen on more than one program
The program this is happening on is a report
The temp-table does not have a 'NO-UNDO'.
Using "transaction" function at the point where the error occurs, it returns "no" later on when there were no errors
Application migrated from Progress but code adjusted for Oracle data source
CAUSE:
For oracle, executing dbms_information_info.set_module which sets module and action in v$session starts a transaction.
FIX:
Use transaction function to validate whether a transaction is active at the time temp table is empties, do not empty temp table when transaction is active.