Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
dvorakstephen11
Contributor III
Contributor III

StringIndexOutOfBoundsException: String index out of range

Here's my job:
0683p000009MBYR.png
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?
Labels (3)
1 Reply
Anonymous
Not applicable

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