"order" parameter does not return entries in order for /metadata-provider/jobLogEntries/{jobId} API

Description

Calling the /metadata-provider/jobLogEntries/{jobId} API with the order=asc query parameter pair appears to be a no-op for data import jobs that create orders. See the job https://bugfest-quesnelia.int.aws.folio.org/data-import/job-summary/534b8b74-04fa-4a12-a21b-27769d1f763a for an example in the Quesnelia Bugfest environment.

This summary screen makes the API call /metadata-provider/jobLogEntries/534b8b74-04fa-4a12-a21b-27769d1f763a?limit=100&order=asc, but the job log entries are not returned in order. The UI displays the entries out of order, and as an additional side effect, navigation between pages of the result set is broken.

To reproduce, load this sample file into Quesnelia Bugfest using the “Acq - Create firm order - print” job profile:

CSP Request Details

None

CSP Rejection Details

None

Potential Workaround

None

Attachments

2

Checklist

hide

Activity

Show:

Sarah Kasten March 12, 2025 at 8:59 PM

With this bug fix pushed to Trillium now, does that mean our request to upgrade this to a P2 has been denied? With the release schedule, we’ll be likely looking at another year of time consuming manual file splitting here. A response would be helpful.

Jennifer Eustis February 13, 2025 at 9:01 PM
Edited

Just the other week, we saw a log entry where the entries weren’t in order. It started at number 3. Also, all 6 entries didn’t display in the log. I captured the whole log below. This was for a create profile where we create instances, holdings, and items and then run a modify to remove those marc fields used to create the holdings and items. This is at Five Colleges. The log entry numbers already aren’t in order. When you try to sort, they don’t sort in order.

Anya February 12, 2025 at 6:39 PM

Support Sig: please review the comment below from and consider how it affects their library and their rationale for classifying this as a P2 instead of a P3.

Sarah Kasten February 12, 2025 at 6:02 PM

This is impacting UChicago in the following way, which we believe aligns with a P2 priority and this is currently prioritized as P3. This bug means that we cannot load orders with more than 50 records due to the UI display problems, and we have implemented a workaround of splitting larger files into multiple smaller files for loading. This can have a significant impact. For instance, one day we received ~550 orders from one vendor. In the past we would have loaded the orders as a single file, but with our workaround, staff must split files into separate loads of 50 records. With the example of the 550 record file, it took the staff member most of a day to process and load the orders because it was done as 11 separate files.

Christie Thomas January 15, 2025 at 7:18 PM

Further testing indicates that this behavior is only observed for order imports that set the Purchase Order Status to “Open”. Tests with a profile that set the Purchase Order Status to “Pending” display all of the records in the correct order. Paging also works.

Details

Assignee

Reporter

Labels

Priority

Development Team

Folijet

Release

Trillium (R2 2025)

RCA Group

TBD

Affected releases

Quesnelia (R1 2024)

Affected Institution

University of Chicago

TestRail: Cases

Open TestRail: Cases

TestRail: Runs

Open TestRail: Runs

Created January 15, 2025 at 2:33 PM
Updated 3 days ago
TestRail: Cases
TestRail: Runs