Symptom
The following error was received:
I. 20xx/07/17 11:57:01. The DSI thread for database 'PDS.PDB' is started.
E. 20xx/07/17 11:57:02. ERROR #1028 DSI EXEC(2906(1) PDS.PDB) -eric/dsi/dsiqmint.c(5188)
Message from server: Message: 233, State 1, Severity 16 -- 'The column pdb in table rs_ticket_history does not allow null values.'.
H. 20xx/07/17 11:57:02. THREAD FATAL ERROR #5049 DSI EXEC(2906(1) PDS.PDB) - neric/dsi/dsiqmint.c(5201)
The DSI thread for database 'PDS.PDB' is being shutdown. DSI received data server error #233 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 #1 of the failed transaction.
H. 20xx/07/17 11:57:02. THREAD FATAL ERROR #5273 DSI EXEC(2906(1) PDS.PDB) - neric/dsi/dsiqmint.c(5229)
To write the failed transaction into log, please execute 'sysadmin log_first_tran, PDS, PDB'. Please analyze the transaction and provide an appropriate fix based on your analysis, then resume the connection.
I. 20xx/07/17 11:57:02. The DSI thread for database 'PDS.PDB' is shutdown.
[dr:rb:rep:DRS18RS_C:repl1w122m7] tlg
I. 20xx/07/17 12:02:50. The DSI thread for database 'PDS.PDB' is shutdown.
I. 20xx/07/17 12:03:20. Trace enabled 'dsi', 'dsi_workload'.
I. 20xx/07/17 12:13:23. The DSI thread for database 'PDS.PDB' is started.
I. 20xx/07/17 12:13:23. begin transaction
I. 20xx/07/17 12:13:24. if ''='repdbsync' begin exec sp_repdbsync 'mydb' end insert into rs_ticket_history (h1,h2,h3,h4,pdb,prs,rrs,rdb,pdb_t,exec_t,dist_t,rsi_t,dsi_t,exec_b,rsi_b,dsi_tnx,dsi_cmd,ticket,conn_id) values('', '-', '-', 'mydb' , NULL , 'PRDH18RS_B', '-', 'PDB', '07/17/XX 02:09:29.486', '07/17/XX 02:09:29.491', '07/17/XX 02:09:29.589', '07/17/XX 02:09:29.8', ' ', 24265, 4033408979, 0, 0, 'V=2;H1=;H4=mydb;PDB(PDB)=07/17/XX 02:09:29.486;RA(PDB)=07/17/XX 02:09:29:486;EXEC(983)=07/17/XX 02:09:29.491;B(983)=24265;DIST(20)=07/17/XX 02:09:29.589;RSI(1194)=07/17/XX 02:09:29.852;RSI_B=4033408979;PRS=PRDH18RS_B', 0)
I. 20xx/07/17 12:13:25. execute rs_update_lastcommit @origin = 4285, @origin_qid = 0x000a000e765685bb02af8dfa000a02af8dfa00070000b042002390710000000000000001, @secondary_qid = 0x000000000000000000000000000000000000000000000000000000000000000000000000, @origin_time = '20xx0717 02:09:29:123', @conn_id = 0
I. 20xx/07/17 12:13:25. if @@error <> 0 rollback transaction
I. 20xx/07/17 12:13:25. commit transaction
T. 20xx/07/17 12:13:26. (166): The first 1 transaction(s) for database 'PDS.PDB' have been logged into the exceptions log.
I. 20xx/07/17 12:13:26. The DSI thread for database 'PDS.PDB' is shutdown.
Read more...
Environment
SAP Replication Server (SRS)
Product
Keywords
ASE REP, rs ticket history, rs install systables ase, sp repdbsync , KBA , BC-SYB-REP , Sybase Replication Server (standalone) , How To
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.