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.
SAP Knowledge Base Article - Preview