SAP Knowledge Base Article - Preview

2618475 - DSI thread is down due to errors 1028, 5046 for eRSSD

Symptom

  • In SRS, DSI thread is down for ERSSD:

    1> admin who_is_down
    2> go
    Spid Name State Info
    ------------ --------- --------- -------------------------------------
    DSI EXEC Down 101(1) ERSSD_name.ERSSD_name
    DSI Down 101 ERSSD_name.ERSSD_name

  • In SRS errorlog, below errors are printed:

I. 2018/03/23 01:02:33. The DSI thread for database 'ERSSD_name.ERSSD_name' is started. 
I. 2018/03/23 01:02:33. SQM starting: 101:0 ERSSD_name.ERSSD_name
I. 2018/03/23 01:02:33. Loaded Connector [ase.ctlib] for connection to [ERSSD_name.ERSSD_name]. Version: [Sybase ExpressConnect CTLibConnector/16.0/EBF 26769 SP03 rs1600pl00/RCI 4.3/Linux AMD64/Linux 2.6.32.59-0.19-default x86_64/2248/OPT64/Thu Jun 8 09:16:50 2017].
E. 2018/03/23 01:02:34. ERROR #1028 DSI(101 ERSSD_name.ERSSD_name) - eneric/dsi/dsioqid.c(2048)
Message from server: Message: 504, State 0, Severity 11 -- 'SQL Anywhere Error -265: Procedure 'rs_get_lastcommit' not found'.
E. 2018/03/23 01:02:34. ERROR #5046 DSI(101 ERSSD_name.ERSSD_name) - eneric/dsi/dsioqid.c(2062)
When executing the rs_get_lastcommit function in database 'ERSSD_name.ERSSD_name', received data server errors. See logged data server errors for more information.
I. 2018/03/23 01:02:34. The DSI thread for database 'ERSSD_name.ERSSD_name' is shutdown.

  • Connect to ERSSD, check the affected procedure. Either there's no entry for this procedure, or its owner will show like below:

1> connect
2> go
1> select * from sysprocedure where proc_name = 'rs_get_lastcommit'
2> go
proc_id creator object_id proc_name
proc_defn
remarks
replicate srvid
source
avg_num_rows avg_cost
stats
dialect is_deterministic is_external external_language
external_name
sql_security
---------- ---------- -------------------- ------------------------------------------------
------------------------------------ ---------------- ----------- -----------------
-----------------------------------------------------------------------------------
499 101 4668 rs_get_lastcommit
create procedure "ERSSD_name_prim"."rs_get_lastcommit"(
@conn_id integer= 0 ) as
select "origin","origin_qid","secondary_qid"
from "rs_lastcommit" where "conn_id" = @conn_id
NULL
N NULL
create procedure rs_get_lastcommit
@conn_id int = 0
as
select origin, origin_qid, secondary_qid
from rs_lastcommit where conn_id = @conn_id
NULL NULL
NULL
Transact-SQL NULL N NULL
NULL
D
(1 row affected)


Read more...

Environment

  • SAP Replication Server 15.7 all versions
  • SAP Replication Server 16.0 all versions

Product

SAP Replication Server 15.7 ; SAP Replication Server 16.0

Keywords

rs_get_lastcommit, rs_update_lastcommit, procedure not found, SQL Anywhere Error -265, Message 504 , 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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.