Uploaded image for project: 'mod-data-import'
  1. mod-data-import
  2. MODDATAIMP-546

Cannot import EDIFACT invoices - Iris env

    XMLWordPrintable

Details

    • 2
    • Folijet Support
    • MI State University/Library of Michigan

    Description

      Overview: Michigan State is unable to import EDIFACT invoices from Harrassowitz. The import stalls and never completes, When stopped by a user, the failed job shows no errors in the log. We tried several edits to the field mapping profile to see if we could correct the issue, but were unable.

      Steps to Reproduce:

      1. Log into Michigan State's sandbox env as Ann-Marie (contact Ann-Marie for username and password)
      2. Import the attached invoice 20210816130502.edi using the MSU Harrassowitz serials invoice - Test AMB job profile
        • Note: there's a human-readable version of the invoice also attached: 20210816130502.docx

      Expected Results: Invoice imports and creates invoice 246816 with 8 invoice lines

      Actual Results: Import never completes

      Additional Information:

      • Tried modifying the field mapping profile MSU Harrassowitz serials invoice - Test AMB in several ways
        • Confirmed that the user was in the Michigan State University Acquisitions unit
        • Removed the Acquisition unit mapping
        • Removed the subscription start/end dates
        • Replaced the Currency mapping with "USD" default
      • Tried reproducing on folio-snapshot-load, but invoices are not loading there either
      • They are able to import invoices using the Test Harrassowitz Monograph invoice job profile
      • List of recent failed imports attached. cgodfrey can pull logs if needed (mod-invoice, mod-sourman, mod-source)

      Interested parties:

      TestRail: Results

        Attachments

          1. 20210816130502.docx
            13 kB
          2. 20210816130502.edi
            3 kB
          3. How to fix failing EDI invoice.mp4
            16.78 MB
          4. mod-invoice.csv
            125 kB
          5. mod-invoice-storage.csv
            93 kB
          6. mod-srm-edifact.csv
            998 kB
          7. mod-srs-edifact.csv
            43 kB
          8. MSU Failed Invoices.PNG
            MSU Failed Invoices.PNG
            143 kB

          Issue Links

            Activity

              People

                abreaux Ann-Marie Breaux
                abreaux Ann-Marie Breaux
                Votes:
                0 Vote for this issue
                Watchers:
                6 Start watching this issue

                Dates

                  Created:
                  Updated:
                  Resolved:

                  TestRail: Runs

                    TestRail: Cases