Detect duplicate transaction

[Former Member]

Dear Expert,

What procedure should I run so that the application can continue running in the event of duplication of transactions?

below error message:

E. 2016/07/19 13:29:38. ERROR #1028 DSI EXEC(103(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_Mas.

H. 2016/07/19 13:29:38. THREAD FATAL ERROR #5049 DSI EXEC(103(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 #86626 of the failed transaction.

H. 2016/07/19 13:29:38. THREAD FATAL ERROR #5273 DSI EXEC(103(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/07/19 13:29:38. The DSI thread for database 'SVC_HERBOPOSSAP.Hartono' is shutdown.

command that I have tried:

1> resume connection to SVC_HERBOPOSSAP.Hartono skip transaction

2> go

Connection to 'SVC_HERBOPOSSAP.Hartono' is resumed.

1>

1> rs_delexception 103

2> go

[Former Member]

Dear Mark,

Thanks fo ryour help.