Test Data Manager

  • Private Community
 View Only
Back to discussions
Expand all | Collapse all

Tech Tip:  When constructing a WHERE clause in FDM, do NOT use Carriage Returns for readability. 

  • 1.  Tech Tip:  When constructing a WHERE clause in FDM, do NOT use Carriage Returns for readability. 

    Broadcom Employee
    Posted Jan 05, 2016 09:59 AM

    While constructing a WHERE clause in FDM, you must remove all CR/LF before saving the file for execution.  If you leave them in, you will receive an error like this:

     

    Error Parsing Data

    Un-terminated quoted field at end of CSV line

    Exception in thread "main" java.lang.NullPointerException

               
    at com.grid_tools.products.datamasker.CSVParser1.doParse(CSVParser1.java:89)

    at com.grid_tools.products.datamasker.CSVParser1.csvParse(CSVParser1.java:64)

               
    at com.grid_tools.products.datamasker.Datamasker.main(Datamasker.java:4264)\

     

    To correct the above error, simply remove the carriage return line feeds from the WHERE clause to place all of the contents on one line such as the following:

     

    city_code in ('909444','959222','944999','123456','777777','888888','001122','242424') and zip_code in ('924','786','590','056','406','212','010','161','998')

     

    instead of

     

    city_code in ('909444',

    '959222',

    '944999',

    '123456',

    '777777',

    '888888',

    '001122',

    '242424') and zip_code in ('924','786','590','056','406','212','010','161','998')