Topic
  • 1 reply
  • Latest Post - ‏2012-09-26T18:52:40Z by sharpme
SystemAdmin
SystemAdmin
238 Posts

Pinned topic MS SQL Insert Activity - Error while closing the transcation..

‏2012-08-10T13:18:02Z |
Hi,

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?

Thanks.
Updated on 2012-09-26T18:52:40Z at 2012-09-26T18:52:40Z by sharpme
  • sharpme
    sharpme
    1 Post

    Re: MS SQL Insert Activity - Error while closing the transcation..

    ‏2012-09-26T18:52:40Z  
    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.

    http://stackoverflow.com/questions/6258184/jdbc-connections-from-linux-to-ms-sql-server-2008-time-out-after-40-seconds