Symptom
- You are building up a new MSA replication setup following:
https://help.sap.com/docs/SAP_REPLICATION_SERVER/f3d1168f05df4952bf62c36482134561/fe0dc490bd1c10148f408119910f94dd.html?locale=en-US - After successfully adding database into replicaiton server, and marking primary DB as replicate, the DSI stays down in repserve with below error:
-----------------------------------------
I. 2023/04/24 11:07:51. The DSI thread for database 'RDS.RDB' is started.
I. 2023/04/24 11:07:52. REPLICATE Replication Server: Created subscription <RDB_SUB> for database replication definition <RDB_DEF> with replicate at <RDS.RDB> without materialization.
E. 2023/04/24 11:07:52. ERROR #1028 DSI EXEC(105(1) RDS.RDB) - neric/dsi/dsiqmint.c(5165)
Message from server: Message: 208, State 1, Severity 16 -- 'rs_lastcommit not found. Specify owner.objectname or use sp_help to check whether the object exists (sp_help may produce lots of output).
H. 2023/04/24 11:07:52. THREAD FATAL ERROR #5089 DSI EXEC(105(1) RDS.RDB) - neric/dsi/dsiqmint.c(5190)
The DSI thread for database 'RDS.RDB' is being shutdown. DSI received data server error #208 which is mapped to STOP_REPLICATION. See logged data server errors for more information. The error was caused by line #9 of stored procedure 'rs_update_lastcommit' on the data server mapped from input command #3 (or a command before it) of the failed transaction.
H. 2023/04/24 11:07:52. THREAD FATAL ERROR #5273 DSI EXEC(105(1) RDS.RDB) - neric/dsi/dsiqmint.c(5206)
To write the failed transaction into log, please execute 'sysadmin log_first_tran, RDS, RDB'. Please analyze the transaction and provide an appropriate fix based on your analysis, then resume the connection.
I. 2023/04/24 11:07:53. The DSI thread for database 'RDS.RDB' is shutdown.
----------------------------------------- - Checking into target ASE server on the rs_* objects, the rs_lastcommit table is missing out.
select name from sysobjects where name like "%rs_%"
goname
rs_check_repl_stat
rs_dbversion
rs_get_lastcommit
rs_get_thread_seq
rs_initialize_threads
rs_marker
rs_mat_status
rs_send_repserver_cmd
rs_syncup_lastcommit
rs_threads
rs_threads_conn_i_604526156
rs_ticket
rs_ticket__rdb_t_780526783
rs_ticket_history
rs_ticket_report
rs_ticket_v1
rs_update_lastcommit
rs_update_threads
(18 rows affected)
Read more...
Environment
- SAP Replication Server (SRS) all versions
- SAP Adaptive Server Enterprise (ASE) all versions
Product
SAP Adaptive Server Enterprise 16.0 ; SAP Replication Server 16.0
Keywords
rs_install_replicate, rs_init, msg 208, DSI down , KBA , BC-SYB-REP , Sybase Replication Server (standalone) , Problem
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.