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

Cannot import EDIFACT invoices - Iris env

    XMLWordPrintable

    Details

    • Template:
    • Story Points:
      2
    • Development Team:
      Folijet
    • Affected Institution:
      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. Carole Godfrey 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

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

                  Dates

                  Created:
                  Updated:
                  Resolved:

                    TestRail: Runs

                      TestRail: Cases