One Star

Error using component tAdvancedFileOutputXML

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.

3 REPLIES
One Star

Re: Error using component tAdvancedFileOutputXML

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?

One Star

Re:Error using component tAdvancedFileOutputXML

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?

Moderator

Re:Error using component tAdvancedFileOutputXML

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

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.