Uploaded image for project: 'ERM Platform'
  1. ERM Platform
  2. ERM-672

Very slow loading of agreement lines from eHoldings

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • P2
    • Resolution: Won't Do
    • None
    • None
    • Bienenvolk
    • Chalmers, Cornell

    Description

      When having added many agreement lines from eHoldings, it takes a long time before they are shown under the Agreement lines accordion.

      For the agreement "De Gruyter EBA 2018 (ebooks)" we have added 138 agreement lines. When opening the agreement, zero or a few lines are shown, both in number count and when clicking on the Agreement line accordion. After a couple of minutes, all lines are loaded.

      Attaching some screenshots and log files if this can help you to see what is happening?

      When opening the agreement:

      After a minute or two:

      For the longest response.

      Header-tab
      Request URL: https://okapi-fse-eu-central-1.folio.ebsco.com/erm/entitlements?match=owner.id&perPage=100&stats=true&term=4bc5bb75-9a3f-4680-b8e5-3cf6b68f01da
      Request Method: GET
      Status Code: 200
      Remote Address: 3.120.8.12:443
      Referrer Policy: no-referrer-when-downgrade
      access-control-allow-origin: *
      access-control-expose-headers: location,X-Okapi-Trace,X-Okapi-Token,Authorization,X-Okapi-Request-Id
      content-type: application/json;charset=UTF-8
      date: Fri, 10 Jan 2020 09:49:25 GMT
      server: nginx/1.10.3
      status: 200
      x-application-context: application:production:8082
      x-okapi-trace: GET mod-authtoken-2.3.0 http://pvt.lb.q32f.folio-eis.eu-central-1:8051/mod-authtoken/erm/entitlements.. : 202 5303us
      x-okapi-trace: GET mod-agreements-1.10.0-FSE http://pvt.lb.q32f.folio-eis.eu-central-1:8051/mod-agreements/erm/entitlements.. : 200 22469364us
      :authority: okapi-fse-eu-central-1.folio.ebsco.com
      :method: GET
      :path: /erm/entitlements?match=owner.id&perPage=100&stats=true&term=4bc5bb75-9a3f-4680-b8e5-3cf6b68f01da
      :scheme: https
      accept: application/json
      accept-encoding: gzip, deflate, br
      accept-language: sv-SE,sv;q=0.9,en-US;q=0.8,en;q=0.7
      content-type: application/json
      origin: https://chalmers.folio.ebsco.com
      referer: https://chalmers.folio.ebsco.com/erm/agreements/4bc5bb75-9a3f-4680-b8e5-3cf6b68f01da?filters=agreementStatus.Active%2CagreementStatus.Draft%2CagreementStatus.In%20negotiation%2CagreementStatus.Requested&sort=name
      sec-fetch-mode: cors
      sec-fetch-site: same-site
      user-agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/79.0.3945.117 Safari/537.36
      x-okapi-tenant: fs00001000
      x-okapi-token: eyJhbGciOiJIUzI1NiJ9.eyJzdWIiOiI2NjA5Mjc1OTg0IiwidXNlcl9pZCI6ImUzZjY1YjVhLTZjMzQtNGRjMi05YzhlLWM1NmU3NWI4NGRhZSIsImlhdCI6MTU3ODY0OTM2OCwidGVuYW50IjoiZnMwMDAwMTAwMCJ9.8wq6rnbqV4Wfo_XJNEPJnXK0LCGoe4qanfrmZ42SAhs
      match: owner.id
      perPage: 100
      stats: true
      term: 4bc5bb75-9a3f-4680-b8e5-3cf6b68f01da

      Preview-tab

      {,…}

      results: [

      {id: "c57536cd-ce93-4316-8c26-b8793542be0d", type: "external", authority: "EKB-TITLE",…}

      ,…]
      pageSize: 100
      page: 1
      totalPages: 2
      meta: {}
      totalRecords: 138
      total: 138

      Response-tab
      {"results":[{"id":"c57536cd-ce93-4316-8c26-b8793542be0d","type":"external","authority":"EKB-TITLE","reference":"207-2593776-13576792","explanation":null,"startDate":null,"endDate":null,"contentUpdated":null,"haveAccess":true,"customCoverage":false,"coverage":[

      {"startDate":"2014-01-01","endDate":"2014-12-31","summary":"v*/i*/2014-01-01 - v*/i*/2014-12-31"}

      ],"reference_object":{"label":"Basics Design Methods","type":"Book","provider":"De Gruyter"}},{"id":"1a4dd947-9ba2-4040-bad0-d090fe5a43c0","type":"external","authority":"EKB-TITLE","reference":"207-2593776-16841146","explanation":null,"startDate":null,"endDate":null,"contentUpdated":null,"haveAccess":true,"customCoverage":false,"coverage":[

      {"startDate":"2018-01-01","endDate":"2018-12-31","summary":"v*/i*/2018-01-01 - v*/i*/2018-12-31"}

      ],"reference_object":{"label":"Hospitals: A Design Manual","type":"Book","provider":"De Gruyter"}},{"id":"44d8bcfa-d249-4a73-8de3-d27fa4b7ebe0","type":"external","authority":"EKB-TITLE","reference":"207-2593776-3206528","explanation":null,"startDate":null,"endDate":null,"contentUpdated":null,"haveAccess":true,"customCoverage":false,"coverage":[

      {"startDate":"2014-01-01","endDate":"2014-12-31","summary":"v*/i*/2014-01-01 - v*/i*/2014-12-31"}

      ],"reference_object":{"label":"Learn or Die: Using Science to Build a Leading-Edge Learning Organization","type":"Book","provider":"De Gruyter"}},{"id":"f6dca0aa-f6e9-4061-b128-99f3693f9220","type":"external","authority":"EKB-TITLE","reference":"207-2593776-3211917","explanation":null,"startDate":null,"endDate":null,"contentUpdated":null,"haveAccess":true,"customCoverage":false,"coverage":[

      {"startDate":"2014-01-01","endDate":"2014-12-31","summary":"v*/i*/2014-01-01 - v*/i*/2014-12-31"}

      ],"reference_object":{"label":"Lost in Space: Architecture and Dementia","type":"Book","provider":"De Gruyter"}}

      etc...

      Timing-tab

      Please let me know if there is anything else you need.

      TestRail: Results

        Attachments

          1. bugfest-agreement.png
            bugfest-agreement.png
            549 kB
          2. bugfest-agreements-prefetch.csv
            68 kB
          3. Bugfest-kb-ebsco-calls.csv
            69 kB
          4. entitlement.json
            66 kB
          5. image-2020-01-10-10-48-56-885.png
            image-2020-01-10-10-48-56-885.png
            118 kB
          6. image-2020-01-10-10-49-55-058.png
            image-2020-01-10-10-49-55-058.png
            114 kB
          7. image-2020-01-10-10-53-36-709.png
            image-2020-01-10-10-53-36-709.png
            144 kB
          8. image-2020-01-10-10-57-48-236.png
            image-2020-01-10-10-57-48-236.png
            21 kB
          9. request-to-mod-kb-ebsco.csv
            172 kB

          Issue Links

            Activity

              People

                ostephens Owen Stephens
                MarieWi Marie Widigson
                Votes:
                0 Vote for this issue
                Watchers:
                10 Start watching this issue

                Dates

                  Created:
                  Updated:
                  Resolved:

                  TestRail: Runs

                    TestRail: Cases