In flight masking error

[NEW_ACCOUNT]

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)

In-flight_masking_error.docx   226 KB 1 version

[Anil Kumar Appukuttan]

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

 

Thanks,

Anil

[HariKrishna Vemula]

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 

[NEW_ACCOUNT]

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.

[Anil Kumar Appukuttan]

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],

[NEW_ACCOUNT]

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