SAP Knowledge Base Article - Preview

3327022 - Table rs_lastcommit is missing on target ASE - SAP SRS

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_%"
    go

    name 
    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.