Error using component tAdvancedFileOutputXML

[Anonymous]

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.

[Anonymous]

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?

[_AnonymousUser]

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?

[Anonymous]

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