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.
SAP Knowledge Base Article - Preview