Circulation History CSV download fails with large number of circulations

[Chris Sharp]

When a user downloads their circulation history as a CSV file and the number of history items is too large, CSV creation fails and the user is presented with an Internal Server Error. "Too large" in this case is 998 items - not sure where the breakpoint is.

Evergreen 2.12.4
OpenSRF 2.5.2
Ubuntu 14.04 LTS
PostgreSQL 9.5

[Kathy Lussier (klussier)]

Adding a note that the code from bug 1208875 should already be applied since it was added as a fix for the 2.12.4 release.

[Michele Morgan (mmorgan)]

We are seeing this on our 2.12.4 system. This is the error in the gateway.log:

2018-05-23 09:24:14 brick0 osrf_json_gw: [perl:error] [pid 136594] [client 192.168.0.19:59550] egweb: Context Loader error: Can't locate object method "content" via package "OpenSRF::DomainObject::oilsMethodException" at /usr/local/share/perl/5.20.2/OpenILS/Utils/CStoreEditor.pm line 458.\n, referer: https://evergreen.noblenet.org/eg/opac/myopac/circ_history

[Michele Morgan (mmorgan)]

We are still seeing this problem on our production server running Evergreen 3.0.9. As an example, a user with a circ history of 1031 items gets an internal server error. Attaching log entries for that attempt. User id has been replaced with xxxxxxx.

[Michele Morgan (mmorgan)]

We are also running a test server on 3.1.7, and a user with 995 items in circ history is able to download successfully. I'm not sure if something has changed, or if the download was successful because our test server isn't busy. Attaching log entries for the successful attempt as well.

[Terran McCanna (tmccanna)]

We are still seeing this problem on 3.2 - a patron with around 700 items is unable to download.

[Michele Morgan (mmorgan)]

We are still seeing this issue in 3.4. On a test server, I was able to download 1000 items, but got an internal server error with 1500 items.

[Terran McCanna (tmccanna)]

Confirming that we're still having this problem in 3.6.

[Terran McCanna (tmccanna)]

Still a problem in 3.8

[Benjamin Kalish (bkalish)]

We're seeing this with Evergreen Version 3.7.3, though I can't help but wonder if it might be a server configuration issue. It sounds a lot like the kind of error I've seen in other systems when not enough resources were allocated on the server or a timeout threshold was set too low.

[Cheryl Middleton (cheryl-middleton)]

Still an issue in 4/2023; first reported in 2017. Patrons are complaining about not being able to do this task, no explanation or message as to why the download doesn't work, they just know it used to work now it doesn't (their lists got too long). Time for this bug to be addressed.

[Elizabeth Davis (elidavis)]

We are still seeing this in 3.9.2.