Uploaded image for project: 'Apache Hop (Retired)'
  1. Apache Hop (Retired)
  2. HOP-4526

Microsoft Excel Input errors

    XMLWordPrintableJSON

Details

    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.

      Attachments

        1. errors.rtf
          47 kB
          Dave Campen
        2. HopExcelIssues.hpl
          30 kB
          Dave Campen
        3. DataWarehouse config.xlsx
          75 kB
          Dave Campen

        Activity

          People

            Unassigned Unassigned
            dcampen Dave Campen
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: