We are trying to perform On the fly masking during which we have enabled tasks of "Disable Constraints" and have added pre scripts to delete data in all the tables in target.
During this we are getting the following error –
Error log says the following –
2022/06/20 01:11:42 - DelphixTableInsert.0 - ERROR (version 184.108.40.206-12, build 1 from 2017-05-16 17.18.02 by buildguy) : An error occurred intialising this step:2022/06/20 01:11:42 - DelphixTableInsert.0 - Error occurred while trying to connect to the database2022/06/20 01:11:42 - DelphixTableInsert.0 -2022/06/20 01:11:42 - DelphixTableInsert.0 - Couldn't execute SQL: SET IDENTITY_INSERT dbo.case ON2022/06/20 01:11:42 - DelphixTableInsert.0 - 2022/06/20 01:11:42 - DelphixTableInsert.0 - Incorrect syntax near the keyword 'case'. 2022/06/20 01:11:42 - DelphixTableInsert.0 - ERROR (version 220.127.116.11-12, build 1 from 2017-05-16 17.18.02 by buildguy) : Error initializing step [DelphixTableInsert]
We tried using pre scripts as well, but that did not work
Do we have any other work around for this ?
Thank you in advance
Thank you very much for your response
We tried disabling constraints but yet stumbled upon the same error
Now the table does not have a constraint but an identity column, in case we try to drop & re-create the column we are worried that the ordering might not match in source & target.
Is there a way that Delphix runs the
"SET IDENTITY_INSERT dbo.case ON" like
"SET IDENTITY_INSERT dbo.[case] ON" or
"SET IDENTITY_INSERT dbo.'case' ON"
We feel since "case" is a special keyword it should be enclosed in quotes to handle this
Hi @Jeannine Crownover,
Can you please help us raise a Delphix support ticket