SAP Knowledge Base Article - Preview

3359783 - The column pdb in table rs_ticket_history does not allow null values - SRS

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

SAP Replication Server all versions

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.