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 Messagein 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
Log InLog in to view more of this document
Historical Number
NFX10488
Was this topic helpful?
Document Information
Modified date:
04 March 2019
UID
swg21552427