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.