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)
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
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
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.
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
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.
