Here is the scenario,
We have three nodes in cluster and we have file polling ,every day 1000 files pickup from the polling directory,for every successful completion it will create a transaction id(TXNID) in the database table(txn_logs). we have shared folder for polling .we are receving the below error in the logs. files are processing successfully but we are not able to see the logs for the files.
Violation of PRIMARY KEY constraint ‘TXN_LOG’(table name). Cannot insert duplicate key in object ‘TXN_LOG’. The duplicate key value is (2914674-15).
2015-06-24 05:57:56 EDT [ART.0114.1007E] Adapter Runtime: Error Logged. See Error log for details. Error: [ADA.1.316] Cannot execute the SQL statement “INSERT INTO dbo
.TXN_LOG(TXNID, TXNDATE, FLOWDIRECTION, SENDER, RECEIVEDFILE, RECEIPTMETHOD, STATUSCODE) VALUES (?, ?, ?, ?, ?, ?, ?)”. "
(23000/2627) Violation of PRIMARY KEY constraint ‘TXN_LOG’. Cannot insert duplicate key in object ‘TXN_LOG’. The duplicate key value is (2914976-15).