Kbase P9397: Error 7336 When Using TRANSACTION-MODE AUTOMATIC
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
27/01/2003 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.1x
SYMPTOM(s):
Using Visual Basic .NET
Run-time exception thrown : System.Runtime.InteropServices.COMException -
4GL ERROR condition: A .p with TRANSACTION-MODE AUTOMATIC may not be run
inside a transaction or while another AUTOMATIC .p is running in the same
process. (7336) (7211)
A .p with TRANSACTION-MODE AUTOMATIC may not be run inside a transaction or while another AUTOMATIC .p is running in the same process. (7336)
CHANGE:
Started using a persistent procedure containing the TRANSACTION-MODE AUTOMATIC statement
CAUSE:
The persistent procedure was instantiated properly and further calls to the AppServer worked fine. However, when the call to the persistent procedure to commit the transaction was invoked error 7336 was generated because the handle that was returned from the first CreatePO_* call was not saved and a second call to CreatePO_* was invoked when trying to commit the transaction.
FIX:
This happens when the Visual Basic application does not save off the object reference that is returned when the CreatePO_* method is invoked. The resolution to this problem is to store off the handle that is returned and use that handle to invoke the commit or rollback methods for the transaction.