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

• In SRS, DSI thread is down for ERSSD or RSSD:
  

  admin who_is_down
  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 for ERSSD:
  - The DSI thread for database 'ERSSD_name.ERSSD_name' is started.
  - SQM starting: 101:0 ERSSD_name.ERSSD_name
  - 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].
  - 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'.
  - 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.
  - The DSI thread for database 'ERSSD_name.ERSSD_name' is shutdown.

• For ASE RSSD, the message is slightly different:
  - ERROR #1028 DSI(465 servername.dbname) - eneric/dsi/dsioqid.c(2049)
   Message from server: Message: -265, State 0, Severity 11 -- 'SQL Anywhere Error -265: Procedure 'rs_update_lastcommit' not found'.
  
  
• Connect to ERSSD or RSSD, check the affected procedure. Either there's no entry for this procedure, or its owner will show like below:

connect
go
select * from sysprocedure where proc_name = 'rs_get_lastcommit'
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)

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

rs_get_lastcommit, rs_update_lastcommit, procedure not found, SQL Anywhere Error -265, Message 504 , KBA , BC-SYB-REP , Sybase Replication Server (standalone) , Problem