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

Announcements
Learn how to migrate to Qlik Cloud Analytics™: On-Demand Briefing!
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