I removed the primary key from the two tables I’ve been having issues with (buildassembly and transaction), and tried to run the populate operation again. The error is essentially the same:
Cannot insert duplicate key row in object ‘dbo.buildassembly’ with unique index ‘buildassemblyIdIndex’. The duplicate key value is (2A64E9-1457553398).: componentitemline in table buildassembly:-2147217873
We just bought this software, and haven’t ever been able to run a full populate operation. This issue is blocking our bulk item number updates, and the deployment of our new manufacturing control software. We need an immediate solution.