SAP Knowledge Base Article - Preview

2477889 - Replication for IDENTITY column may report error 7756 - SAP SRS

Symptom

You may get the below error when a table which has IDENTITY column is replicated.

ERROR #1028 DSI EXEC(105(1) RDS.MSA) - dsiqmint.c(4806)
Message from server: Message: 7756, State 1, Severity 16 -- 'Cannot use 'SET IDENTITY_INSERT' for table 'dbo.test1' because the table does not have the identity property.'.

The error appears in the below conditions:

  • Replication system is Multi-Site Availability (MSA)
  • Primary table has IDENTITY column, but secondary table has not
  • Table replication definition is not defined for the table

Read more...

Environment

SAP Replication Server (SRS) 15.7

Product

SAP Adaptive Server Enterprise 15.7

Keywords

IDENTITY column, 7756, 'SET IDENTITY_INSERT', MSA, database replication , KBA , BC-SYB-REP , Sybase Replication Server (standalone) , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.