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 for Me (Login required).

Search for additional results

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