Kbase P68707: Can not commit transactions in both Progress and Oracle database
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
7/1/2008 |
|
Status: Verified
SYMPTOM(s):
Can not commit transactions in both Progress and Oracle database
Error committing transactions in both Progress and Oracle database
Unable to commit the transaction in one database. (1417)
Error 1417 received when committing transactions in both Progress and Oracle database
Error intermittent
Client session crashes after the error
FACT(s) (Environment):
HP-UX 11.0 64-bit
Progress 9.1D 64-bit
OpenEdge 10.0A
Oracle DataServer
CAUSE:
Bug# OE00099979
CAUSE:
One of Oracle DataServer function's return value is not initialized, but the return value is checked in two phase commit code. Depending what residue value is in the memory at the time of execution, the two phase commit code could return the fatal error 1417 and exit out the session. This is especially true on 64 bit platforms when the checking is more strict. This is why the error is intermittent and only shows up on 64 bit platforms.
FIX:
Upgrade to 9.1D09, 10.0A01, 10.0B or later