Uploaded image for project: 'mod-inventory'
  1. mod-inventory
  2. MODINV-457

"Join" of Items and holdings records breaks at around 124 Items retrieved in one request

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • P3
    • Resolution: Done
    • None
    • None
    • Tested with MTSU, suspect it affects all Iris tenants

    • Prokopovych
    • Skidmore College

    Description

       

      Overview:
      Steps to Reproduce:

      1. Snapshot only has 41 Items, the bug occurs around 124 Items. I don't know if we have a publicly available FOLIO environment with enough Items to demonstrate the bug.
      2. Note that the response below is from a service that is somewhat behind snapshot, version wise. 
      3. Nowhere in the UI do we retrieve that many Items at once to my knowledge, so it would not turn up as a UI bug and it can instead be shown through direct API requests to /inventory/items
      4. So: log in to FOLIO with, say over 200 Items.
      5. Make a request to /inventory/items?limit=150

      Expected Results:

      JSON result set with 150 Item records

      Actual Results:

      Holdings request (id%3D%3D%287ed460c8-300a-434e-8ffe-429ce2a68636+or+c9905383-87bf-4b66-84d2-c9a18cf74eed+or+25eb69da-91af-4fcc-b448-53ff024d32e3+or+3fdb105b-1d64-45d6-be08-0f85e656b930+or+ef0302d6-2f69-4835-84c2-26e4c6eceba6+or+cbfdf64f-04f1-4a76-970a-a65d7a824dad+or+910c65ff-e721-4c5d-9b69-0b88fff46591+or+e436866a-1f69-42da-bff8-696725d6d9cb+or+32027fea-983d-44cd-8fde-df4565845deb+or+a3766023-1308-433c-abe6-86d0645608ca+or+64e15971-c176-41d3-98e2-ce394bff36d5+or+b25f65f7-695f-43f9-b8b2-2075e6ec2a13+or+42d21300-f706-43d0-8433-19ac12ececb0+or+a846f250-409a-4f22-9d47-fd8b3d36efb0+or+4865e771-5440-44da-8abc-ac8680a074a4+or+cb45193a-c5ac-4c54-a0f4-66f769d01628+or+4d570776-de3f-4848-bbd3-3fc500a45305+or+daa69375-41da-4b2a-88a8-5f55642db323+or+112c1ca9-98c8-4cad-855d-852522332cb6+or+d9b8a6ce-166b-4bf9-a7a6-c0231d08cdbd+or+e6148807-6efc-401f-8dc3-50d403f621c6+or+019e493e-1b48-4716-aa47-80fb337cf99b+or+484af1f5-f398-45cb-87a7-2b87154d53ae+or+b9a5f596-3937-4e60-8012-2f36edd91cf0+or+00973969-22b2-4849-ba13-b6faf274283c+or+ddcfcfed-5c6d-4163-9280-a59bbdac29ba+or+4d4cb68c-83ed-4605-8e35-6e101c3e1431+or+bb12bd94-7885-41eb-bd14-a62238b62f4d+or+f31735b0-fed5-4a75-bd10-a0c0a2b9b9f3+or+aa45937f-4fca-4240-9222-d27fa41038af+or+93e42b81-d8db-4ad1-b872-3f33409fc597+or+6ae2fe39-59e0-49ae-82a3-45d6a6245fcf+or+f57c7be2-c22a-43ec-bf07-3f363ad529af+or+6c7249f3-63c8-4d14-968f-a15ab3873c82+or+8b6dec21-92b9-433b-a58a-0af8c9ff7a92+or+a9af5bef-019b-461e-838c-678e1ecd5af5+or+57668d9c-f5f8-4aa9-9cfa-25db251e6485+or+75113426-b299-423e-aee4-e2b711dd431f+or+aaf9c189-f6b5-49bd-9d1e-6f7e5ee9bcab+or+054b2a84-6e4a-4b9c-bb13-8b45f4377461+or+42bcd208-b7eb-4679-90c7-7959cbe6de36+or+cc006a86-2f6a-460d-86c3-efd05d269d8a+or+b950f4a3-5bac-46f6-a72a-0f9521c6550c+or+07c833c2-e356-4cf9-a7bd-3238cca52982+or+1586f712-7356-4ca5-a261-b986fbd7410a+or+d8923536-0463-4295-86a2-ca4c7c0a3d2f+or+d5c479e7-368c-48a8-863f-29d74a537911+or+ea7c9f49-248f-4f31-906c-1d31066c5cbe+or+d9b36b25-5db9-4ffc-9bad-a2440cc5ece7+or+b837629e-bf87-481d-9369-e675175c4178+or+a0943924-f866-4aca-a943-bf0a8cf7fcdf+or+5e51370f-5161-4114-aaa6-7d82bd06c931+or+cfae984e-4ace-4a51-9db5-a3e6f3b435f2+or+eb0b2f85-523a-4f30-9964-b3eb1e04eec2+or+69e88a67-7185-4907-bf43-041692963892+or+72494a43-b765-4a6d-abae-05b5a820a697+or+f4888121-3f4e-4be2-a59c-b2270398ab9d+or+147327de-e164-48f1-8ad4-1d1e85e309d0+or+a065c25d-4388-4510-8101-b6e857225d23+or+ddcbe1db-9c59-4bd2-acac-4d482df7f142+or+38b4a436-0201-4e72-8384-8a9680942a25+or+a4646a58-1c75-4a13-9931-b2e87c395de7+or+737b4cb5-3945-4dbd-93f4-f427eca3bc69+or+a6ca3003-4d5e-48ad-b2ca-a2c630ff2a46+or+cdc3201a-a038-47d6-ba36-cdc2bc62c28f+or+36e112fd-d698-4710-ac6c-afc9574656f2+or+26ae6e60-0ec1-444a-8940-37521ea27a48+or+90857041-1cb7-4170-b5c1-1c46517eb1f2+or+fc6215e6-b685-4010-80c5-b674d8c2e0e3+or+08b718e5-e2a1-43de-a0a6-6f605a004837+or+49089ac0-fbca-4b14-b79c-d83c948a745c+or+6760747f-4db9-4236-8611-d9118bbfbe5b+or+501c8510-589d-4538-b355-c4b5cf646ddf+or+0d064bb6-56c6-4fd4-a1e1-7c21f8e0306a+or+6b4f38d6-acd9-4232-a517-544746656ef1+or+173356cd-9b6b-44eb-a0d5-7c856c08c91c+or+09bc8f58-3f2a-40bc-b7e3-a5ebfe86f22b+or+f8d29bcf-fb2c-4488-85c8-fd3cc8abbea2+or+43040bbd-9ac2-43b5-9872-f02f0ec155a4+or+f1b4f71e-dd78-4758-a7a6-3b2e6007202e+or+2f1c34df-0173-4428-8e81-a72c6b373b99+or+4dbf774c-4e5f-438a-b9fa-7f54cde301a1+or+3e57479b-48f5-404a-80fb-d9bb0a017de0+or+2d6cf586-c281-402e-ada0-2c0d0f393f12+or+88254615-4998-42d9-950e-091bed60df50+or+21a1ee2b-f85d-4984-86c5-80f2ee4694fb+or+ff8d5cb3-335f-4995-84e7-0b33079bb8c7+or+572118f5-f817-4f55-a9ce-e16ae9ba67e8+or+9c58b532-b8a6-4b3d-ad99-96c3803a5e25+or+64a9a9a8-080f-474c-ac48-80b5a62cb94e+or+02300c15-7a87-468c-8673-f53b0c606972+or+111c6622-dfb8-4290-8b1c-6b27718c82e8+or+4589a664-7d04-41ad-bee4-1b3bbc9069d4+or+20b287fe-f978-4c01-8a35-c4b8e89ae6bc+or+1e9439c0-6264-4ea0-b4aa-95bae6a85438+or+58054e42-539b-4ef0-8494-4570110cd8a5+or+d644478b-cf73-4756-95b3-7e19f3467d58+or+32be2876-e2a4-459b-858f-ed70deacf843+or+cec10ce1-a19a-4869-817c-a9a6c39854e2+or+6cd349a2-9fc3-448a-87b4-5e9ea0c33874+or+00b095ae-8f5e-4112-8d32-edd817d05acd+or+4581e0d3-064e-4fc5-9ec7-cb05189ec055+or+b2e80081-2aed-4e81-8ca5-4d3b4be9f2a4+or+207286b8-8cf7-4227-b5aa-41176240d753+or+36f35251-adcd-472d-b594-8e0ebd2733c0+or+1a5e34a6-ec08-4629-a4f8-df357615b678+or+c09847b2-d8e1-41de-9985-f5c0a5baf7f3+or+e4144986-975b-4e5b-942b-9df9932e3903+or+4b80919d-aef3-4e12-b3d4-29e6c2f4ac66+or+278423cf-4e79-4973-8a66-e29b91b9f93c+or+fd7b9973-0504-47d5-90d6-0364ea417962+or+1619a4d5-9e9d-491a-ad45-aaa5bb9f450d+or+6d32519d-c33f-4be8-9c5e-c1316f8df22c+or+66bb3286-4828-4fba-808c-edab6a31e5db%29) failed 414: 
      
      

      Additional Information:

      This issue raises the question: Considering that the processing required to populate the Items coming out from /inventory/items is somewhat extensive, should we actually allow requests for unlimited number of Items, and if not, what should the limit be. 

      Interested parties:

      TestRail: Results

        Attachments

          Issue Links

            Activity

              People

                Unassigned Unassigned
                nielserik Niels Erik Gilvad Nielsen
                Votes:
                0 Vote for this issue
                Watchers:
                7 Start watching this issue

                Dates

                  Created:
                  Updated:
                  Resolved:

                  TestRail: Runs

                    TestRail: Cases