Hi,

Our database is Oracle 9.2.0.4.0

I checked all my adapter services called in the service RaiseError_Custom to make sure they using same local connection. For those use different local connections, I use publish/subscribe method.

This error does not appear regularly. Some time it shows and some time not. For exampl today, the RaiseError_Custome was called from 1AM to 6AM for every half hour, the error only showed at 1:00, 3:30 and 5:30.

I am wondering the number ‘1207057218768’ in xid of following log message. If it is a timestamp, it does not match the logging time. It is 4/1/2008 9:40:18 AM after converted but the error logging time is 04-02 01:00:06 EDT

04-02 01:00:06 EDT DFLogging:RaiseError_Custom [SCC.0121.0034E] commit failed: more than 1 local trans enlisted. xid = [FormatId=45744, GlobalId=apsdev.deltafaucet.com/1207057218768, BranchQual=2] rxid = {2} Stack trace data … a593bc50007111dd849685517bc5e8d0 a593bc50007111dd849685517bc5e8d0 a9245d20007111dd84ad85517bc5e8d0

04-02 01:00:06 EDT DFLogging:RaiseError_Custom [SCC.0121.0034E] commit failed: more than 1 local trans enlisted. xid = [FormatId=45744, GlobalId=apsdev.deltafaucet.com/1207057218771, BranchQual=1] rxid = {2} Stack trace data … a593bc50007111dd849685517bc5e8d0 a593bc50007111dd849685517bc5e8d0 a9274350007111dd84d885517bc5e8d0

04-02 01:00:06 EDT DFLogging:RaiseError_Custom [SCC.0121.0034E] commit failed: more than 1 local trans enlisted. xid = [FormatId=45744, GlobalId=apsdev.deltafaucet.com/1207057218769, BranchQual=2] rxid = {2} Stack trace data … a593bc50007111dd849685517bc5e8d0 a593bc50007111dd849685517bc5e8d0 a9248430007111dd84b285517bc5e8d0

“commit failed: more than 1 local trans enlisted.” I think you might be using more than one adapter service with different transaction types and not using explicit commit/rollback after success/failure.

HTH,
Hope.

In the flow service, it calls adapter services which use same local connection by implicity transaction. For those use different local connetion, the service publish a document to invoke transaction to avoid in different transaction context.

I find the error code is different for the transction context error. It is [ART.117.4011] instead of [SCC.0121.0034E]

If you are using more than 1 adapter service with transaction type “Local_Transaction”, then you need to use explicit commit/rollback. Incase of “No_Transaction”, it will be auto-committed.

HTH,
Hope.