SAP Knowledge Base Article - Preview

2856795 - SPAM Error: SQL-error "2812-Could not find stored procedure 'sys.sp_SybSetLogfo2EETP345 rLOBCol' during Activation or MOVE NAMETABS

Symptom

While performing a SP or SPAM update using SPAM tool, import fails during activation or MOVE NAMETABS with below error:

3 ETP379X16:07:34: activating Nametab "OCS_BACKUP":
3 ETP355Xstatements:
3 ETP000 ALTER TABLE [OCS_BACKUP]
3 ETP000 ADD CONSTRAINT [OCS_BACKUP~0]
3 ETP000 PRIMARY KEY CLUSTERED
3 ETP000 ( [TABLE_NAME] )
3 ETP000
2WETP000 16:07:34: Retcode 512: error in DDL statement for "OCS_BACKUP " - repea
2WETP000 t
2EETP345 16:07:46: Retcode 512: SQL-error "2812-Could not find stored procedure 'sys.sp_SybSetLogforLOBCol'."
2EETP345  in DDL statement for "OCS_BACKUP "
2 ETP000 --------------- DB-ROLLBACK() ---------------
2EETP334 16:07:46: error in DDL, nametab for "OCS_BACKUP" not activated

Note: It can be for other objects as well (apart from object OCS_BACKUP)


Read more...

Environment

  • SAP Replication Server Option (RSO) for Microsoft SQL Server 15.7.1
  • SAP Replication Server (SRS) all versions

Keywords

RSO, Replication Agent, Rep Agent, RAM, SRS, RS, mssql, ramssql, sys.sp_SybSetLogforLOBCol, sys.sp_SybSetLogforReplTable, SPAM, SPAM update, error in DDL statement, MOVE OF NAMETABS, Nametab, Shadow-Nametabs , KBA , BC-UPG-OCS , Online Corr. Support (Tools:Supp.-Pack., Addon Install/Upgr) , BC-DB-MSS , SQL Server in SAP NetWeaver Products , 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.