Friday, November 14, 2008

SQLState: S0001, Message: The server failed to resume the transaction. Desc:3600000000

Problem Description:
=======================================================================
When web based java application is connecting to SQL server 2005 backend through JDBC, they are getting error message
SQLState: S0001, Message: The server failed to resume the transaction. Desc:3600000000., Vendor Error Code: 3971

Cause:
=======================================================================
Here are the scenarios that you might get this error message (“failed to resume the transaction”):
• A nested stored procedure is called
• Stored procedure returns output parameters
• A deadlock occurs. After waiting, the stored procedure is executed again and receives "failed to resume transaction"

Workaround/Resolution:
=======================================================================
Here is some of the work around being prescribed since we have started seeing the issue:
1) Use PreparedStatement in lieu of Statement. This ensures that outstanding TDS packets are parsed when close() is called.
2) Call Statement.getMoreResults() and Statement.getUpdateCount() until those functions indicate there are no more results to be processed. This ensures that all outstanding TDS packets are parsed.

1 comment:

Anonymous said...

Wonderful article .An important point is a resume and cover letters are the marketing tools that helps the candidate to land in a perfect position. So it’s better to hire a professional service. One such specialized service is http://www.canadian-resume-service.com/

Thanks,
Kim - Professional resume writing