I have an orchestration that, at some point, has to insert some data into an MS SQL table (table name = dbo.TEMP_JUDET). I'm getting the error: "An exception occurred while processing a SingleTableNotification job. Data error at row number 0 of table dbo.TEMP_JUDET. The Error is Error while closing the transcation..CastIron SystemsSQLServer JDBC DriverObject has been closed."
We followed this guide of solving this error "http://www-01.ibm.com/support/docview.wss?uid=swg21580220" but the issue still persists.
Does anyone know what real problem is?
Pinned topic MS SQL Insert Activity - Error while closing the transcation..
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2012-09-26T18:52:40Z at 2012-09-26T18:52:40Z by sharpme
sharpme 270003WR3G1 Post
Re: MS SQL Insert Activity - Error while closing the transcation..2012-09-26T18:52:40ZThis is the accepted answer. This is the accepted answer.This is a shot in the dark, but I've seen similar errors resolved by setting the "Chimney Offload State" on the Win2k8 server's NIC to automatic/disabled. Take a look at the following link for research.