StringIndexOutOfBoundsException: String index out of range

Here's my job:

My MSSQLInput component does a SELECT * from table "EmpList"
This is the error I receive on the MSSQLInput component:
Exception in component tMSSqlInput_1
java.lang.StringIndexOutOfBoundsException: String index out of range: -1
at java.lang.String.substring(Unknown Source)
at org.talend.designer.components.util.mssql.MSSqlGenerateTimestampUtil.parseDatetimeOffset(MSSqlGenerateTimestampUtil.java:116)
at org.talend.designer.components.util.mssql.MSSqlGenerateTimestampUtil.getDate(MSSqlGenerateTimestampUtil.java:94)

What could the source of this error be?
1 REPLY
One Star

Re: StringIndexOutOfBoundsException: String index out of range

the order of columns at MSSQLInput schema is different with the order of columns at table in database?
MSSQLInput
column 1
column 2
column 3
Table
column 1
column 3
column 2