SAP Knowledge Base Article - Preview

2231086 - Error 9137 reported in RS log when adding new sp to be replicated - SAP RS

Symptom

  • The Replication Server is configured in Warm Standby mode to replicate data from Prim_Server.Prim_DB to Sec_Server.Sec_DB.
  • The replication system is using replication of user stored procedure.
  • When a user stored procedure is marked as replicate in the source database Prim_Server.Prim_DB with the following command:

  sp_setrepproc <Procedure_Name> , 'function'

  • The DSI connection to the standby database Sec_Server.Sec_DB, which is the destination of the warm standby replication, will print the following error message in the errorlog of the Replication Server:

ERROR #1028 DSI EXEC(126(1) Sec_Server.Sec_DB) - /dsiutil.c(574) Message from server: Message: 9137, State 2, Severity 16 -- 'LTMtrunc. point not yet established with DBCC SETTRUNC(). Until the LTM trunc. point is established, changes to the object 'Procedure_Name' may not be replicated.'.


Read more...

Environment

  • SAP Replication Server (RS) 15.x
  • SAP Replication Server (RS) 16.0

Product

SAP Replication Server 15.7 ; Sybase Replication Server 15.5 ; Sybase Replication Server 15.6

Keywords

"stored procedure", LTM, "second truncation point", SETTRUNC , 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.