[GitHub] [hop] hansva opened a new issue, #2296: [Bug]: Microsoft Excel Input errors

["hansva (via GitHub)" <gi...@apache.org>]

hansva opened a new issue, #2296:
URL: https://github.com/apache/hop/issues/2296

   ### Apache Hop version?
   
   2.2
   
   ### Java version?
   
   11
   
   ### Operating system
   
   Windows
   
   ### What happened?
   
   Import: https://issues.apache.org/jira/browse/HOP-4526
   
   When I run a pipeline with a Microsoft Excel Input file, I get a number of errors and it hangs up on the pipeline
   
   When I preview each input, everything displays as expected, but when the pipeline us run, I get the issues.
   This pipeline has a number of Microsoft Excel input steps as this excel file is loaded into a database for setting configs.
   If I run more than 3 in a single pipeline...the pipeline will fail after running the same pipeline a few times. This is a weird problem.
   I have a hunch that it may have to do with the number of tabs defined?
   If it doesn't fail the first time, try running it a few times in a row.
   Also the attached file has data redacted from it, but I retained all of the sheets that exist.
   ...also see attached for logged errors.
   
   
   
   Comments:
   Note: this behavior changed starting late in 2.1 development as it worked until just a few weeks before the release.  I was using the August 26 snapshot and it worked fine, so something was introduced after that point.
   
   
   I have isolated the problem - it is with this option "Excel XLSX, XLS". When I changed them all to "Excel XLSX (Streaming)"...all works as expected (without failure).
   
   
   [Archive.zip](https://github.com/apache/hop/files/10698205/Archive.zip)
   
   
   ### Issue Priority
   
   Priority: 2
   
   ### Issue Component
   
   Component: Transforms


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: issues-unsubscribe@hop.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org