Creating multiple invoice lines per invoice fails - LOTUS (Harrassowitz Chicago)

Description

Current workaround Manual entry

Steps to Reproduce:

  1. Scenario

    • Go to Juniper Bugfest

    • Go to Settings/Data Import and review the Job/Action/Field mapping profiles for Create Large Harrassowitz serial invoice IMD+L and the attached invoice file 20201114072017.EDI and Word version 20201114072017.edi.docx and confirm that the field mappings are correct

    • Go to Data Import and upload the file 20201114072017.EDI

    • Assign the Harrassowitz job profile cited above, and import the file

Expected Results: should create 9 invoices with a total of 1326 line items

Actual Results: did not complete

Additional Information: EDIFACT files (file extension .edi) and corresponding human-readable Word versions (file extension .docx)

Import fails with the following error

2021-11-22T08:10:41,386 ERROR [vert.x-worker-thread-16 ] RestClient Exception calling GET /orders/order-lines?offset=0&query=purchaseOrder.workflowStatus%3D%3DOpen+AND+poLineNumber%3D%3D%28%2210280730%22+OR+%2210024207%22+OR+%2214665037%22+OR+%2232409%22+OR+%2270566%22+OR+%2210060844%22+OR+%2270564%22+OR+%2210116345%22+OR+%2210041667%22+OR+%2275331%22+OR+%2210465315%22+OR+%2210102050%22+OR+%2210783957%22+OR+%2210166208%22+OR+%2210881797%22+OR+%2238212%22+OR+%2269120%22+OR+%22292977%22+OR+%2215970127%22+OR+%2210186918%22+OR+%2210299889%22+OR+%2210058515%22+OR+%2210062476%22+OR+%2210084009%22+OR+%2210046719%22+OR+%2210047700%22+OR+%2210053931%22+OR+%2217221444%22+OR+%2210144584%22+OR+%2210281010%22+OR+%2210281710%22+OR+%2210136125%22+OR+%2210783702%22+OR+%2212085595%22+OR+%2217733420%22+OR+%22362202%22+OR+%2210147500%22+OR+%2210034924%22+OR+%2217712233%22+OR+%2210275794%22+OR+%2210307990%22+OR+%2210029266%22+OR+%2219695731%22+OR+%2215897060%22+OR+%2218522701%22+OR+%2210087310%22+OR+%2210285325%22+OR+%2219437018%22+OR+%2212443037%22+OR+%2210024323%22+OR+%2210606683%22+OR+%2212448230%22+OR+%2218578172%22+OR+%2210280170%22+OR+%22113404%22+OR+%2210783726%22+OR+%2210083182%22+OR+%2269116%22+OR+%22107294%22+OR+%2210818996%22+OR+%2219555969%22+OR+%2214612963%22+OR+%2210309834%22+OR+%2217591090%22+OR+%2213312911%22+OR+%2210065507%22+OR+%2210079660%22+OR+%2210080636%22+OR+%2210066354%22+OR+%2210043500%22+OR+%2210064199%22+OR+%2210083583%22+OR+%2210353148%22+OR+%2210060005%22+OR+%2210065465%22+OR+%2210514533%22+OR+%2210040420%22+OR+%2210044334%22+OR+%2210059301%22+OR+%2210175246%22+OR+%2210056816%22+OR+%2268665%22+OR+%2210039466%22+OR+%2268528%22+OR+%2210191355%22+OR+%2210066986%22+OR+%22394564%22+OR+%2210034341%22+OR+%2268520%22+OR+%2210287061%22+OR+%2210163578%22+OR+%2217275428%22+OR+%2219063994%22+OR+%2210306511%22+OR+%2210043305%22+OR+%2210277079%22+OR+%2268515%22+OR+%2268511%22+OR+%2210049230%22+OR+%2210120002%22+OR+%2200053168%22+OR+%2210059362%22+OR+%2210263561%22+OR+%2210123143%22+OR+%2210094714%22+OR+%22353049%22+OR+%2210283973%22+OR+%2210021814%22+OR+%2210045132%22+OR+%2210281903%22+OR+%2210281228%22+OR+%2210426085%22+OR+%2210062762%22+OR+%2210251339%22+OR+%2210039715%22+OR+%22242419%22+OR+%2210107678%22+OR+%2210591941%22+OR+%2212453511%22+OR+%2210314740%22+OR+%2267135%22+OR+%2210284898%22+OR+%2210071398%22+OR+%221006266x%22+OR+%2210168590%22+OR+%2210174850%22+OR+%2273735%22+OR+%2210278291%22+OR+%2210147512%22+OR+%2267133%22+OR+%22114495%22+OR+%2210063432%22+OR+%2210040821%22+OR+%2210119670%22+OR+%2269127%22+OR+%2212738487%22+OR+%2220075947%22+OR+%2210063328%22+OR+%2217407667%22+OR+%2210055125%22+OR+%2210437253%22+OR+%2210049137%22+OR+%2210047098%22+OR+%2210061927%22+OR+%2210057389%22+OR+%2215621870%22+OR+%2266949%22+OR+%2217591119%22+OR+%2210282798%22+OR+%2210025522%22+OR+%2210043263%22+OR+%2210043081%22+OR+%2210074193%22+OR+%2210088696%22+OR+%2210041412%22+OR+%2273898%22+OR+%2217592276%22+OR+%2210074764%22+OR+%2217291100%22+OR+%2212515723%22+OR+%2210130780%22+OR+%2252268%22+OR+%2210091970%22+OR+%2222121675%22+OR+%2210147445%22+OR+%2210422407%22+OR+%2210251182%22+OR+%2217463336%22+OR+%2210062191%22+OR+%2210045612%22+OR+%2210789868%22+OR+%2218673983%22+OR+%2210095263%22+OR+%2210065490%22+OR+%2218513232%22+OR+%2210232710%22+OR+%2217397972%22+OR+%2210043093%22+OR+%2210059982%22+OR+%2210776096%22+OR+%2210015279%22+OR+%2210293607%22+OR+%2214490742%22+OR+%2210063055%22+OR+%2210403796%22+OR+%2219496333%22+OR+%2266923%22+OR+%2210108543%22+OR+%2219210668%22+OR+%22400884%22+OR+%2210314430%22+OR+%2210266276%22+OR+%2210313760%22+OR+%2210294144%22+OR+%2210285003%22+OR+%2210294077%22+OR+%2210314428%22+OR+%2210694249%22+OR+%2210316413%22+OR+%2210284916%22%29&limit=2147483647 - org.folio.rest.core.models.RequestContext@7b716f33 2021-11-22T08:10:41.387Z java.util.concurrent.CompletionException: org.folio.invoices.rest.exceptions.HttpException: { 2021-11-22T08:10:41.387Z "errors" : [ { 2021-11-22T08:10:41.387Z "message" : "Request-URI Too Long", 2021-11-22T08:10:41.387Z "code" : "genericError", 2021-11-22T08:10:41.387Z "parameters" : [ ] 2021-11-22T08:10:41.387Z } ], 2021-11-22T08:10:41.387Z "total_records" : 1 2021-11-22T08:10:41.387Z }

It is related to the number of invoice lines per invoice that are being created. If there are too many the query above becomes too large and the request fails

CSP Request Details

None

CSP Rejection Details

None

Potential Workaround

None

Attachments

2
  • 24 Nov 2021, 03:45 PM
  • 24 Nov 2021, 03:45 PM

Checklist

hide

TestRail: Results

Activity

Show:

Siarhei HrabkoNovember 29, 2021 at 9:12 AM

Done

Details

Assignee

Reporter

Priority

Story Points

Sprint

Development Team

Thunderjet

Fix versions

Release

Lotus R1 2022

Affected Institution

Cornell
TAMU
University of Chicago

TestRail: Cases

Open TestRail: Cases

TestRail: Runs

Open TestRail: Runs

Created November 24, 2021 at 3:45 PM
Updated April 26, 2022 at 10:31 AM
Resolved November 29, 2021 at 9:13 AM
TestRail: Cases
TestRail: Runs