topic Parse error with context variable and date value in Talend Studio

Parse error with context variable and date value

borke02 — Thu, 29 Dec 2022 12:26:18 GMT

Hi,

I'm migrating and testing our Talend jobs to Talend Data Integration v8.0.1. After importing a test job I get the following error:

Null value will be used for context parameter timestamp: Can't parse date string: Unparseable date: "" and long: For input string: ""

After some research and digging into Talend source code I found this message in the file

... studio\plugins\org.talend.designer.codegen_8.0.1.20211103_1602\jet_stub\footer.javajet in line 769.

I found similar code in footer.javajet in the version Talend Open Studio 7.3.1 and 8.0.1M12 (downloaded from sourceforge).

I made another test job with context parameters and different values. The values has to be set with the correct pattern (yyyy-MM-dd HH:mm:ss) or in miliseconds. An empty string or the string "null" results in an error. Is this a correct behaviour? Or should an empty string or the string "null" also be accepted as valid values?

Regards,

Frank

Re: Parse error with context variable and date value

Anonymous — Fri, 30 Dec 2022 03:16:46 GMT

Hello

Defining a context variable with Date type, it requires a default value, and the date pattern should be "yyyy-MM-dd HH:mm:ss".

Regards

Shong

Re: Parse error with context variable and date value

zjing — Thu, 05 Jan 2023 09:58:04 GMT

hello,

context variable, the definition of pattern is obligate. but the value is not obligate if the option nullable is marked

Re: Parse error with context variable and date value

borke02 — Fri, 06 Jan 2023 09:09:39 GMT

Hello,

thanks shong. I now use the date pattern "yyyy-MM-dd HH:mm:ss" for date values.

zjing, where can I mark a context variable as nullable? I can only define name, type, comment and value for context variable. Also I can activate prompt. In my example I only printed out the values of the context variables with the tJava component. And with a wrong or an empty value I get an error.