Test Data Manager

  • Private Community
 View Only

  • 1.  FDM Null Pointer exception on JSON column masking

    Posted Apr 13, 2020 03:40 PM
    Upgraded to tdm 4.9.   Trying to mask Json columns stored in Sql Server Columns.  2 issues.

    1.  Trying to mask comments with similar format as below but receiving null pointer exception when trying to mask Comment using function Format Encrypt

    [{"ModifiedByFullName":"xxxxxx xxxxx","ModifiedBy":"xxxxxx xxxxx","ModifiedDate":"2012-10-24T15:18:46","Comment":"yyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyy","CanEdit":"false"}]

    2020-04-13 11:29:56.709 java.lang.NullPointerException2020-04-13 11:29:56.709 java.lang.NullPointerException at com.grid_tools.products.datamasker.genfunctions.processJSON(genfunctions.java:3305) at com.grid_tools.products.datamasker.Datamasker.resolveFunction(Datamasker.java:15014) at com.grid_tools.products.datamasker.SQLUpdate.batchPreparedMasking(SQLUpdate.java:4170) at com.grid_tools.products.datamasker.SQLUpdate.run(SQLUpdate.java:5444) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748)

    2.  When masking another JSON column with names using HASHLOV hash key of a unique id.  FDM is substituting same values for each row no matter what the unique id is.  We have a seed table of 250k names.   Same seed table is working fine on non Json columns.

    ------------------------------
    Don Pastorius
    ------------------------------


  • 2.  RE: FDM Null Pointer exception on JSON column masking

    Broadcom Employee
    Posted Apr 14, 2020 06:58 AM
    What FDM version are you using?

    Can you please provide more details about the second one?
    My understanding is that you are masking (for example) the comment field in the json column  using hashlov. The seedlist value is based on a another column in the table which contain unique values


    Regards ,Dahman



    Original Message


  • 3.  RE: FDM Null Pointer exception on JSON column masking

    Posted Apr 14, 2020 08:20 AM
      |   view attached
    Attached is the details as the second issue is now failing.

    Attachment(s)

    docx
    JSON TDM Issue 20200414.docx   25 KB 1 version
    Original Message


  • 4.  RE: FDM Null Pointer exception on JSON column masking
    Best Answer

    Broadcom Employee
    Posted Apr 14, 2020 09:22 AM

    Hi Don,
    Please open a support ticket to get the latest FDM patch (FastDataMasker-4.9.15.0.zip) and see if that addresses this issue.
    Cheers!

    Les Dover


    Original Message