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