IBM Support

SQL Error Code: 3971 SQL State: S0001 sqlserver.jdbc.SQLServerException: The server failed to resume the transaction

Troubleshooting


Problem

SQL Error Code: 3971 SQL State: S0001 sqlserver.jdbc.SQLServerException: The server failed to resume the transaction

Symptom

Gentran Integration Suite version 4.3.  MS SQL 2005 Database. The procedure below was used to remove old data from the GIS *_GUID tables.

Executed the following SQL statements:

select top 1 * into ACT_SESSION_GUID_TEMP from ACT_SESSION_GUID order by NEXT_SESS_ARC_ID desc 
select top 1 * into MBX_MESSAGE_GUID_TEMP from MBX_MESSAGE_GUID order by NEXT_MESSAGE_ID desc 
select top 1 * into DATA_FLOW_GUID_TEMP from DATA_FLOW_GUID order by NEXT_FLOW_ID desc 

drop table ACT_SESSION_GUID 
drop table MBX_MESSAGE_GUID 
drop table DATA_FLOW_GUID 

Rname all Temp Tables to original table names.

The SELECT INTO command should automatically recreate the tables with the same data types for the columns of new "TEMP" tables.

Error Message

in wf.log

[2010-12-20 13:06:18.278] ERROR 000000000000 GLOBAL_SCOPE com.sterlingcommerce.woodstock.workflow.queue.WorkFlowQueueListener.onMessage() caught Exception for workflow 36683162
SQL Error Code: 3971
SQL State: S0001
com.microsoft.sqlserver.jdbc.SQLServerException: The server failed to resume the transaction. Desc:5d000008ec.
 at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(Unknown Source)
 at com.microsoft.sqlserver.jdbc.IOBuffer.processPackets(Unknown Source)

system log:

[2010-12-20 12:39:18.814] ERROR 000310100650 UTIL.FRAME_JDBC.ERR_NO_MSG_EXCEP12 NO_MSG_EXCEP
SQL Error Code: 3971
SQL State: S0001
com.microsoft.sqlserver.jdbc.SQLServerException: The server failed to resume the transaction. Desc:6e000000ef.
 at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(Unknown Source)

noapp log:

[2010-12-20 13:04:52.762] ALL 000000000000 GLOBAL_SCOPE SQLexception in XAResourceWrapper.rollback()
[2010-12-20 13:04:52.762] ALL 000000000000 GLOBAL_SCOPE com.microsoft.sqlserver.jdbc.SQLServerException: The server failed to resume the transaction. Desc:5d000008ec.
[2010-12-20 13:04:52.762] ALL 000000000000 GLOBAL_SCOPE

 

 

 

 

[{"Product":{"code":"SS3JSW","label":"IBM Sterling B2B Integrator"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Extensions","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All","Edition":"","Line of Business":{"code":"LOB77","label":"Automation Platform"}},{"Product":{"code":"SS3JSW","label":"IBM Sterling B2B Integrator"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Adapters","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB77","label":"Automation Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Historical Number

NFX10488

Document Information

More support for:
IBM Sterling B2B Integrator

Software version:
All

Document number:
455295

Modified date:
04 March 2019

UID

swg21552427

Manage My Notification Subscriptions