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.