Test Data Manager

Expand all | Collapse all

FDM Null Pointer exception on JSON column masking

Jump to Best Answer
  • 1.  FDM Null Pointer exception on JSON column masking

    Posted 04-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

    Posted 04-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





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

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

    Attachment(s)



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

    Posted 04-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