Share
ReportI've setup transactional replication for a database in server A to replicate in server B (one way replication). A few basic tests were performed, like modifying an item or customer card. Now after a few more complex tests, like adding a journal entry or adding a payables voucher, i'm getting these errors for several tables: "Cannot insert explicit value for identity column in table 'GL70501' when IDENTITY_INSERT is set to OFF". This article https://mbs2.microsoft.com/Knowledgebase/KBDisplay.aspx?scid=kb;en-us;926490 says that you have to disable the option to add a unique identifier to the table, which makes sense because the tables already have the DEX_ROW_ID, but this option is only available for MS SQL Server 2008 R2 and earlier. I'm running SQL 2012 and GP 2015. Any thoughts?
*This post is locked for comments
I have the same question (0)
All responses (
Answers (
2