tDataPrepRun returning error DictionarySnapshot.getDQCategoryByName(String)" because "dictionarySnapshot" is null

[igoralcantara]

Good day Qlik Community,

I am working with a job whose schema was provided by Qlik Learning. All other pieces work fine but this one.

Basically I have a Data Preparation job in Talend Cloud (Demographics) which uses only one semantic type: US State Code. The job runs perfectly in the cloud. However, when I call it in Studio, it fails.

I have all the modules installed on Studio and I do have the latest version of Studio installed. I have a Windows OS.

The error I get is this one:

Exception in component tDataprepRun_1 (Process_Data)

java.lang.NullPointerException: Cannot invoke "org.talend.dataquality.semantic.snapshot.DictionarySnapshot.getDQCategoryByName(String)" because "dictionarySnapshot" is null

I also attached a few images.

Any tip on how to fix this? 

[marksouzacosta]

Hi @Denis_Segard,

There is one date column, the Date of birth. I checked all values using different techniques, and values look valid (format yyyy-MM-dd) minimum date 1906-05-31 and max 2022-05-28, no blanks and no -1228158000000 value.

Anyway, I changed the Data Preparation to remove the Date of birth column and the Job worked - with the use dictionary checked.

My guess now is that the Date issue was some other non-related issue with the Data Preparation while the workaround of publishing a dictionary semantic type made the magic.

Regards,

Mark Costa

[Denis_Segard]

Hello Mark,
I "dug a little bit deeper" and the error occurs when there is a date before 1970-01-01 (EPOCH limit) .
I have reported the problem to the R&D. 

Kind regards
Denis

[hugo_andrade]

What about Null values @marksouzacosta ? Did you have them on the data?

[marksouzacosta]

No. No null values.
By the way, Talend released a new patch this week. I have updated and I will retest it to see if this problem was addressed.

[hugo_andrade]

Nice. Please let us know how it goes!

[chris_khalife]

Hi Mark,

Were you able to get your job working? I can confirm that my sample test job with tDataPrep now runs successfully and no longer throws the original error "dictionarySnapshot" is null.

Best Regards,

Qlik Talend Support

[marksouzacosta]

I have tested in different scenarios and so far, everything looks great!