topic Re: Problem with retrive date formats in Talend Studio

Problem with retrive date formats

Anonymous — Sat, 16 Nov 2024 04:34:02 GMT

Hello Experts,

I am facing a problem during a load of a table from SQL Server, it works fine until the line 253 after that I got the problem below. Can anyone help with it?

Thank you in advanced

Exception in component tDBInput_1 (testecol)
java.lang.IllegalArgumentException: DAY_OF_MONTH
at java.util.GregorianCalendar.computeTime(Unknown Source)
at java.util.Calendar.updateTime(Unknown Source)
at java.util.Calendar.getTimeInMillis(Unknown Source)
at com.mysql.cj.result.SqlTimestampValueFactory.createFromTimestamp(SqlTimestampValueFactory.java:96)
at com.mysql.cj.result.SqlTimestampValueFactory.createFromDate(SqlTimestampValueFactory.java:70)
at com.mysql.cj.result.SqlTimestampValueFactory.createFromDate(SqlTimestampValueFactory.java:44)
at com.mysql.cj.result.BaseDecoratingValueFactory.createFromDate(BaseDecoratingValueFactory.java:53)
at com.mysql.cj.result.BaseDecoratingValueFactory.createFromDate(BaseDecoratingValueFactory.java:53)
at com.mysql.cj.protocol.a.MysqlTextValueDecoder.decodeDate(MysqlTextValueDecoder.java:72)
at com.mysql.cj.protocol.result.AbstractResultsetRow.decodeAndCreateReturnValue(AbstractResultsetRow.java:90)
at com.mysql.cj.protocol.result.AbstractResultsetRow.getValueFromBytes(AbstractResultsetRow.java:250)
at com.mysql.cj.protocol.a.result.TextBufferRow.getValue(TextBufferRow.java:132)
at com.mysql.cj.jdbc.result.ResultSetImpl.getNonStringValueFromRow(ResultSetImpl.java:655)
at com.mysql.cj.jdbc.result.ResultSetImpl.getDateOrTimestampValueFromRow(ResultSetImpl.java:678)
at com.mysql.cj.jdbc.result.ResultSetImpl.getTimestamp(ResultSetImpl.java:1018)
at local_project.testecol_0_1.testecol.tDBInput_1Process(testecol.java:3382)
at local_project.testecol_0_1.testecol.runJobInTOS(testecol.java:4349)
at local_project.testecol_0_1.testecol.main(testecol.java:4198)

Re: Problem with retrive date formats

jeoste — Thu, 26 Sep 2019 08:38:51 GMT

Hello !

Can you provide screenshots from your job / components ?
As the stack says there is a problem with "DAY_OF_MONTH", might be the wrong format, or something like that. Add some screenshot to help us understand.
Check this link if it helps : java.lang.IllegalArgumentException

Re: Problem with retrive date formats

Anonymous — Thu, 26 Sep 2019 13:07:15 GMT

Hello Jeoste,

Thank you for your reply. It is just a t_DbInput to t_logrow.

I figure out the problem, but I don't know yet how to solve, I have date 1899 - 12 - 31 and my Windows calendar going just to 1900-01-01, it is (I believe) what the line: at java.util.GregorianCalendar.computeTime(Unknown Source) means.

Raphael

Re: Problem with retrive date formats

Anonymous — Thu, 26 Sep 2019 18:12:14 GMT

Hi,

Could you please share how your column schema has been configured? I hope the date format is in right format with 4 digit year code (yyyy).

If you are retrieving the data as String, are you facing the error? You can change the data to date later based on your need.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved

Re: Problem with retrive date formats

Anonymous — Mon, 30 Sep 2019 22:19:17 GMT

hello Friends,

I figured out the problem, the calendar from the CRM data source started from 1899 and the server where is TOS start 1900 (Gregorian Calendar). I created a query to change the date to 1900 and solved the problem.

Thank you very much.