[HOP-4526] Microsoft Excel Input errors

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.1.0, 2.2.0
• Fix Version/s: Migrated to GHI
• Component/s: Hop GUI, Hop Web, Plugins
• Assignee: Unassigned
• Reporter: Dave Campen
• Created: 29/Oct/22 16:35
• Updated: 09/Feb/23 14:31
• Resolved: 09/Feb/23 14:31

Description

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.