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: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
