Skip to Content
0
Former Member
Sep 05, 2016 at 06:18 AM

Trace duplicate transaction

85 Views

Dear Expert,

I have two primary connections (RASQL1 and RASQL2005) to a single target (SVC_HERBOPOSSAP), if an error occurs like this how do I know or trace of a transaction where the primary connection that is causing duplicate key on the target (SVC_HERBOPOSSAP)?

T. 2016/09/02 16:21:14. (182): 'insert into dbo.Trx_4 (KodeTrx, NoDokumen, Tanggal, KodeBarang, Barcode, KodeGudang, .....

E. 2016/09/02 16:21:15. ERROR #1028 DSI EXEC(110(1) SVC_HERBOPOSSAP.Hartono) - neric/dsi/dsiqmint.c(5112)

Message from server: Message: 30291, State 0, Severity 19 -- '[[Message Iteration=1|Data Source Name=DSN_HERBOPOSSAP|SQL Function=INSERT|SQLState=23000|Native Error=2627|Message=[Microsoft][SQL Server Native Client 10.0][SQL Server]Violation of PRIMARY KEY constraint 'PK_Trx.

H. 2016/09/02 16:21:15. THREAD FATAL ERROR #5049 DSI EXEC(110(1) SVC_HERBOPOSSAP.Hartono) - neric/dsi/dsiqmint.c(5125)

The DSI thread for database 'SVC_HERBOPOSSAP.Hartono' is being shutdown. DSI received data server error #30291 which is mapped to STOP_REPLICATION. See logged data server errors for more information. The data server error was caused by output command #1 mapped from input command #2 of the failed transaction.

H. 2016/09/02 16:21:15. THREAD FATAL ERROR #5273 DSI EXEC(110(1) SVC_HERBOPOSSAP.Hartono) - neric/dsi/dsiqmint.c(5153)

To write the failed transaction into log, please execute 'sysadmin log_first_tran, SVC_HERBOPOSSAP, Hartono'. Please analyze the transaction and provide an appropriate fix based on your analysis, then resume the connection.

I. 2016/09/02 16:21:15. The DSI thread for database 'SVC_HERBOPOSSAP.Hartono' is shutdown.