Hi Aadhavan,
Go to the registered objects->Select the table->Maintain Table->For columns which are auto generated set/check the
computed? checkbox. This should be automatically handled by CA but they are not doing it. Once done save it and do the publish. Hope this solves the problem.
------------------------------
Thanks,
Rajkumar
------------------------------
Original Message:
Sent: 07-20-2020 06:33 AM
From: Aadhavan Diaz
Subject: Handling Identity Insert in Synthetic Data Generation
Hi Team,
We are doing Synthetic Data generation for Database tables. When publishing data to tables that have Identity Inserts (SQL Server) for the primary key columns, the Publish fails.
Is there any way to handle this.
Thanks,
Aadhavan