https://community.qlik.com/t5/Talend-Studio/StringIndexOutOfBoundsException-String-index-out-of-range/m-p/2226283#M18239 Here's my job: <BR /> <span class="lia-inline-image-display-wrapper" image-alt="0683p000009MBYR.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/138949iF9303F9C3C0B6BC3/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MBYR.png" alt="0683p000009MBYR.png" /></span> <BR />My MSSQLInput component does a SELECT * from table "EmpList" <BR />This is the error I receive on the MSSQLInput component: <BR /> <FONT color="#ff3366">Exception in component tMSSqlInput_1</FONT> <BR /> <FONT color="#ff3366">java.lang.StringIndexOutOfBoundsException: String index out of range: -1</FONT> <BR /> <FONT color="#ff3366"> at java.lang.String.substring(Unknown Source)</FONT> <BR /> <FONT color="#ff3366"> at org.talend.designer.components.util.mssql.MSSqlGenerateTimestampUtil.parseDatetimeOffset(MSSqlGenerateTimestampUtil.java:116)</FONT> <BR /> <FONT color="#ff3366"> at org.talend.designer.components.util.mssql.MSSqlGenerateTimestampUtil.getDate(MSSqlGenerateTimestampUtil.java:94)</FONT> <BR /> <BR />What could the source of this error be? Tue, 29 Sep 2015 21:49:54 GMT dvorakstephen11 2015-09-29T21:49:54Z https://community.qlik.com/t5/Talend-Studio/StringIndexOutOfBoundsException-String-index-out-of-range/m-p/2226283#M18239 Here's my job: <BR /> <span class="lia-inline-image-display-wrapper" image-alt="0683p000009MBYR.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/138949iF9303F9C3C0B6BC3/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MBYR.png" alt="0683p000009MBYR.png" /></span> <BR />My MSSQLInput component does a SELECT * from table "EmpList" <BR />This is the error I receive on the MSSQLInput component: <BR /> <FONT color="#ff3366">Exception in component tMSSqlInput_1</FONT> <BR /> <FONT color="#ff3366">java.lang.StringIndexOutOfBoundsException: String index out of range: -1</FONT> <BR /> <FONT color="#ff3366"> at java.lang.String.substring(Unknown Source)</FONT> <BR /> <FONT color="#ff3366"> at org.talend.designer.components.util.mssql.MSSqlGenerateTimestampUtil.parseDatetimeOffset(MSSqlGenerateTimestampUtil.java:116)</FONT> <BR /> <FONT color="#ff3366"> at org.talend.designer.components.util.mssql.MSSqlGenerateTimestampUtil.getDate(MSSqlGenerateTimestampUtil.java:94)</FONT> <BR /> <BR />What could the source of this error be? Tue, 29 Sep 2015 21:49:54 GMT https://community.qlik.com/t5/Talend-Studio/StringIndexOutOfBoundsException-String-index-out-of-range/m-p/2226283#M18239 dvorakstephen11 2015-09-29T21:49:54Z https://community.qlik.com/t5/Talend-Studio/StringIndexOutOfBoundsException-String-index-out-of-range/m-p/2226284#M18240 the order of columns at MSSQLInput schema is different with the order of columns at table in database?<BR /><U>MSSQLInput</U><BR />column 1<BR />column 2<BR />column 3<BR /><U>Table</U><BR />column 1<BR />column 3<BR />column 2 Wed, 30 Sep 2015 05:33:46 GMT https://community.qlik.com/t5/Talend-Studio/StringIndexOutOfBoundsException-String-index-out-of-range/m-p/2226284#M18240 Anonymous 2015-09-30T05:33:46Z