JDBC Sender Adapter error locking issue

[Former Member]

Hi ,

Getting error:

Database-level error reported by JDBC driver while executing statement 'UPDATE OrdersTo_SAP SET Read_By_PI_Fl ='P' WHERE Read_By_PI_Fl is null'. The JDBC driver returned the following error message: 'com.microsoft.sqlserver.jdbc.SQLServerException: Transaction (Process ID 117) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction.'. For details, contact your database server vendor

I have increased the time out period also changed the isolation level to serializable  but no result. Channel is getting the error very frequently.

Can any one please look into the error.

Thanks,

Swapnashree

[former_member184720]

Hi Swapnashree - Are there multiple sources which will update this table? or just PI?

How many server nodes you have?

However when i search in Microsoft forums, i found the below. Please share it with your DBA to investigate further..

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/194f18b0-03b2-4e8f-8c67-5c92373c3efd/transac...

http://technet.microsoft.com/en-us/library/aa213030(v=sql.80).aspx

Transaction (Process ID 51) was deadlocked on lock resources with another process and has been chose...

[roger_alluivall]

Hi Swapnashree,

Is the table OrdersTo_SAP being accessed at the same time by other processes?

Regards!