Very slow loading of agreement lines from eHoldings
Description
CSP Request Details
CSP Rejection Details
Potential Workaround
Attachments
is cloned by
relates to
Checklist
hideTestRail: Results
Activity

Owen Stephens August 24, 2023 at 3:59 PMEdited
Issues have been addressed through work on with incremental improvements being release in Nolana and Orchid with a full solution in Poppy release

Carole Godfrey January 29, 2020 at 1:04 PM
-- glad we are on same page as well and thanks for the details from you and both
There currently is not an endpoint which fetches a list of title (Resources) based on a list of ids. This seems like something which would be of value here. Will check with on investigating adding this functionality.

steve.osguthorpe January 29, 2020 at 9:14 AM
- Sorry I'd miss-understood. Glad we are on the same page regarding the duplicate requests.
Is there a way of fetching a list of titles from a list of IDs? Maybe we could bulk together some of these but I'd need some way of getting at a collection of titles based on a list of IDs. We can't really use the package/{ID}/resources endpoint because we'd have to build in e-holdings only logic that titles are from the same package, and then we may end up fetching 1000+ titles to render only 3 of them.
If you can point me at an end point I'll investigate a little when I get a bit of free time.

Carole Godfrey January 28, 2020 at 6:20 PMEdited
– I didn't mean to imply that the same title was requested 4X from the same request to mod-agreements.
There was time in between (15 seconds) requests for the same title (as you noted) – I was trying to understand why there were multiple request for the same title happening in a short time frame – I was looking at the requests from the perspective of mod-kb-ebsco-java http requests
Ok – understand – this duplication is more a result of a stripes-connect duplicate request

steve.osguthorpe January 28, 2020 at 5:04 PMEdited
But you are saying fetching the same title 4 times per request? That's what I'm struggling to see.
For instance taking that log you noted and filtering for "/eholdings/resources/207-2593776-13484569" shows 3 results for that title 15 seconds in between each one and in separate requests. And that suggests the issue has already put it down to with stripes-connect.
Details
Assignee
Owen StephensOwen StephensReporter
Marie WidigsonMarie WidigsonPriority
TBDDevelopment Team
BienenvolkRelease
Not For ReleaseTestRail: Cases
Open TestRail: CasesTestRail: Runs
Open TestRail: Runs
Details
Details
Assignee

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.