topic Re: Error using component tAdvancedFileOutputXML in Talend Studio

Error using component tAdvancedFileOutputXML

Anonymous — Fri, 07 Sep 2012 15:32:35 GMT

I am getting the following error in my job that has a tFileInputDelimited connected to a tAdvancedFileOutputXML
Exception in component tAdvancedFileOutputXML_1
java.lang.StringIndexOutOfBoundsException: String index out of range: -1
at java.lang.String.substring(Unknown Source)
at java.lang.String.substring(Unknown Source)
at test_job.copy_of_bsn_test_0_1.Copy_of_bsn_test.tFileInputDelimited_5Process(Copy_of_bsn_test.java:1484)
at test_job.copy_of_bsn_test_0_1.Copy_of_bsn_test.runJobInTOS(Copy_of_bsn_test.java:2481)
at test_job.copy_of_bsn_test_0_1.Copy_of_bsn_test.main(Copy_of_bsn_test.java:2227)
connecting to socket on port 4276
I am wondering if the the issue is with any of the Advanced Settings for the component.
Would appreciate any feedback.

Re: Error using component tAdvancedFileOutputXML

Anonymous — Fri, 07 Sep 2012 18:52:23 GMT

Hi,
Have you tried linking your tFileInputDelimited to a tLogRow to see if the problem isn't on the input? Does this happen on the first row?

Re: Error using component tAdvancedFileOutputXML

_AnonymousUser — Wed, 27 Jan 2016 10:46:34 GMT

Hi ,
I am trying to load data from .xls to oracle table but I got this error at run time.
Exception in component tFileInputExcel_1
java.lang.StringIndexOutOfBoundsException: String index out of range: 68.
How to resolve this error?

Re: Error using component tAdvancedFileOutputXML

Anonymous — Thu, 28 Jan 2016 08:34:40 GMT

Hi rashmi25,
Are you using excel 2003 file(.xls)? How many sheets and columns in your excel file? On which build version you got this issue?
Best regards
Sabrina