Backport the fix of DB query for loading the tags of the provider's packages which is breaking eholdings app in Q release

Description

Issue: In eholdings app when we select any package and click on it, it gives 'failed to fetch' error in the bottom of that record. See screenshot below. Issue is reported by Michstate Uni but I checked that this issue persists in many tenants in different cluster and region. While selecting the package , it gives 500 Internal Server Error in network console. In AWS logs, It seems like a database issue. below error is seen - 

 

"INFO  LogUtil              127.0.0.1:42164 GET /eholdings/providers/26/packages count=100&page=1 HTTP_1_1 500 107 186 tid=fs00001046 Internal Server Error ,qmch/mod-kb-ebsco-java

"Caused by: io.vertx.pgclient.PgException: ERROR: trailing junk after parameter at or near ""$101G"" (42601)",qmch/mod-kb-ebsco-java"

 

Steps to reproduce - 

Go to eholdings app>>Select Package (by default) >> Search title - "Elsevier Science" and go to bottom of that package, error is seen and no details of Usage and analysis is present there.  

 

How to resolve issue? You mentioned that the issue is fixed in v5.0.0 which is for Ramsons. Has the fix been backported to Quesnelia? I see that current version deployed in our production environments is v4.0.0 but there are minor versions released after 4.0.0 -> https://github.com/folio-org/mod-kb-ebsco-java/releases/tag/v4.1.0 . Was the issue fixed in 4.1.0 because we can then deploy it to all production environments? We are starting to get reports from customers for us. Thanks!

CSP Request Details

None

CSP Rejection Details

None

Potential Workaround

None

Attachments

4

Checklist

hide

Activity

Show:

Valery_Pilko February 10, 2025 at 8:25 AM

Verified on Quesnelia Bugfest environment - fixed.
Provider record:

Package record:

Title record:

Hi - could you please review it on https://bugfest-quesnelia.int.aws.folio.org/ and close this ticket?

Done

Details

Assignee

Reporter

Priority

Story Points

Sprint

Development Team

Spitfire

Fix versions

Release

Quesnelia (R1 2024) Service Patch #10

RCA Group

Data related (ex. Can be detected with large dataset only)

CSP Approved

Yes

TestRail: Cases

Open TestRail: Cases

TestRail: Runs

Open TestRail: Runs
Created January 29, 2025 at 2:44 PM
Updated February 10, 2025 at 1:51 PM
Resolved January 31, 2025 at 2:13 PM
TestRail: Cases
TestRail: Runs