Test Data Manager

Expand all | Collapse all

In flight masking error

Jump to Best Answer
  • 1.  In flight masking error

    Posted 12-18-2017 03:31 AM
      |   view attached

    Hello Team,

              I am trying to test in-flight masking but all the time i am getting error when trying to generate dump file from scramble script. Please find attached the steps followed till generating script from FDM. and suggest what is the problem. I had a look into code and observed the error is because of a view which generating with wrong syntax.

    Is this a bug or any step i am missing, Please help. Thank you. 

    Attachment(s)



  • 2.  Re: In flight masking error
    Best Answer

    Posted 12-18-2017 10:32 AM

    Please raise a support ticket at https://support.ca.com with the details and someone will review and assist.

     

    Thanks,

    Anil



  • 3.  Re: In flight masking error

    Posted 12-21-2017 04:41 AM

    In below screen, you are using Functions Database as 'travel', ideally it should be 'scramble', which is where you have the masking functions defined.

     

     

    Thanks,

    Hari 



  • 4.  Re: In flight masking error

    Posted 01-02-2018 11:36 AM

    Hi Hari Krishna,

         Thank you so much for the feedback. Yes, you are correct the database function need to be change to 'scramble', But after changing I am getting the same error

          I checked the code and could see the problem is there in select script during view creation. exact error is coming from below sql.

    select scramble.dbo.AMEX([[CARD_NUMBER]], '') [CARD_NUMBER] from [travel].[dbo].[CREDIT_CARDS] L0

    Msg 156, Level 15, State 1, Line 1

    Incorrect syntax near the keyword 'from'.

    Could you please help why the function is not working in above query.

    Part of the view is like

    CREATE VIEW [dbo].[CREDIT_CARDS_v]  as select
    [CARD_ID] [CARD_ID],
    scramble.dbo.AMEX([[CARD_NUMBER]], '') [CARD_NUMBER],
    [TYPE] [TYPE],
    [EXPIRATION_DATE] [EXPIRATION_DATE],
    [PEO_ID] [PEO_ID]
    from [travel].[dbo].[CREDIT_CARDS] L0  where 1 = 1

     

    Thank you in Advance.



  • 5.  Re: In flight masking error

    Posted 01-02-2018 12:33 PM

    The double square bracket around the function is what is giving the error. If you replace it to the below it should work. If the tool is generating the query in that way then you need to raise a support ticket to fix it along with the complete details like a screenshot of the function you are using.

     

    Original

    scramble.dbo.AMEX([[CARD_NUMBER]], '') [CARD_NUMBER],

     

    Changed

    scramble.dbo.AMEX([CARD_NUMBER], '') [CARD_NUMBER],



  • 6.  Re: In flight masking error

    Posted 01-02-2018 10:48 PM

    Thank you Anil Kumar, That works. I will raise a support ticket as script generate the SQL.