Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
In the input schema, define the date pattern as "yyyy-MM-dd'T'HH:mm:ss" also, it should work now.
Regards
Shong
Hi
In the input schema, define the date pattern as "yyyy-MM-dd'T'HH:mm:ss" also, it should work now.
Regards
Shong
Request for Quick help
Facing an similar issue as below.
Starting job Test_Job_1 at 14:37 11/03/2020.
[statistics] connecting to socket on port 3746
[statistics] connected
Exception in component tXMLMap_3_TXMLMAP_OUT (Test_Job_1)
java.lang.RuntimeException: Unparseable date: "2020-02-14T09:52:42Z"
at routines.system.ParserUtils.parseTo_Date(ParserUtils.java:339)
at bat_integration.test_job_1_0_1.Test_Job_1$1TreeNode_API_tXMLMap_3_TXMLMAP_OUT.get_Date(Test_Job_1.java:2505)
at bat_integration.test_job_1_0_1.Test_Job_1.tRESTClient_2Process(Test_Job_1.java:3311)
at bat_integration.test_job_1_0_1.Test_Job_1.tFileInputDelimited_1Process(Test_Job_1.java:1514)
at bat_integration.test_job_1_0_1.Test_Job_1.runJobInTOS(Test_Job_1.java:4330)
at bat_integration.test_job_1_0_1.Test_Job_1.main(Test_Job_1.java:4084)
[FATAL]: bat_integration.test_job_1_0_1.Test_Job_1 - tXMLMap_3_TXMLMAP_OUT Unparseable date: "2020-02-14T09:52:42Z"
java.lang.RuntimeException: Unparseable date: "2020-02-14T09:52:42Z"
at routines.system.ParserUtils.parseTo_Date(ParserUtils.java:339)
at bat_integration.test_job_1_0_1.Test_Job_1$1TreeNode_API_tXMLMap_3_TXMLMAP_OUT.get_Date(Test_Job_1.java:2505)
at bat_integration.test_job_1_0_1.Test_Job_1.tRESTClient_2Process(Test_Job_1.java:3311)
at bat_integration.test_job_1_0_1.Test_Job_1.tFileInputDelimited_1Process(Test_Job_1.java:1514)
at bat_integration.test_job_1_0_1.Test_Job_1.runJobInTOS(Test_Job_1.java:4330)
at bat_integration.test_job_1_0_1.Test_Job_1.main(Test_Job_1.java:4084)
[statistics] disconnected
Job Test_Job_1 ended at 14:37 11/03/2020. [exit code=1]
Note to people who are using a more recent version of Talend. It is not called "input schema". The 2nd tab on the input of the tXMLMap component is labeled "TreeSchemaEditor". You can change the pattern of the date there. After a couple hours of frustration, I came across this post and got my issue to work!