Delphix Products

 View Only

  • 1.  Masking Microsoft SQL Server special keyword table name with identity

    Posted 09-21-2022 12:51:00 PM

    Hi All,

    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 7.1.0.0-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 database
    2022/06/20 01:11:42 - DelphixTableInsert.0 -
    2022/06/20 01:11:42 - DelphixTableInsert.0 - Couldn't execute SQL: SET IDENTITY_INSERT dbo.case ON
    2022/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 7.1.0.0-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 



    ------------------------------
    Ruchit Doshi
    ------------------------------


  • 2.  RE: Masking Microsoft SQL Server special keyword table name with identity
    Best Answer

    Posted 09-22-2022 01:05:00 AM
    Hello Ruchit,
    the RULESET is not aware that you have dropped the constraint.
    If you drop constraint and refresh ruleset > then run the job it should work.
    The ruleset knows by doing refresh ruleset that there is no more constraint on table and will just insert.
    Afterwards you can recreate the constraint in postscript.
    Hope this helps.
    With best regards ... Tino

    ------------------------------
    Tino Pironti
    Masking SME
    Technical Manager
    Delphix
    ------------------------------

    Original Message


  • 3.  RE: Masking Microsoft SQL Server special keyword table name with identity

    Posted 09-22-2022 11:50:00 PM

    Hi Tino,

    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 

    Thanks,



    ------------------------------
    Ruchit Doshi
    ------------------------------

    Original Message


  • 4.  RE: Masking Microsoft SQL Server special keyword table name with identity

    Posted 09-23-2022 03:10:00 AM
    Hello Ruchit,
    you cannot manipulate the SQL generation, feel free to raise a Delphix support ticket and provide all details to raise it as a potential bug.
    A work around might be to rename using hook/script the column name "case" in source and target > refresh ruleset > run job > rename back.
    With best regards 
    Tino

    ------------------------------
    Tino Pironti
    Masking SME
    Technical Manager
    Delphix
    ------------------------------

    Original Message


  • 5.  RE: Masking Microsoft SQL Server special keyword table name with identity

    Posted 09-24-2022 04:08:00 AM

    Hi Toni,

    Thank you very much for your response

    Hi @Jeannine Crownover​​, 

    Can you please help us raise a Delphix support ticket 

    Thanks,



    ------------------------------
    Ruchit Doshi
    ------------------------------

    Original Message


  • 6.  RE: Masking Microsoft SQL Server special keyword table name with identity

    Posted 09-26-2022 02:35:00 AM
    Hello Ruchit, 

    If you are using delphix 6.0.15 then it will not allow you to create the identity column.
    make LK= Nothing, write custom SQL if there is any filter condition > Run masking job it will consider the primary column automatically.
    If its work then kindly let me know i will tell you for postscript also then.

    ------------------------------
    Pankaj Asegaonkar
    MASKING SPECIALIST
    Infosys
    ------------------------------

    Original Message


Related Content