DCB Patron barcode issue

Description

While testing DCB, was encountered this response from FOLIO:

"responseBody": { "errors": [ { "code": "VALIDATION_ERROR", "type": "-1", "message": "[400 Bad Request] during [GET] to [http://users?query=barcode%3D%3D%3B00013%3D01921712863%3F%20and%20id%3D%3Dbb1d3f1a-1d18-4a5d-b8f5-677e37769afe] [UsersClient#fetchUserByBarcodeAndId(String)]: [org.folio.cql2pgjson.exception.QueryValidationException: ? wildcard not allowed in full text query string: barcode==;00013=01921712863? and id==bb1d3f1a-1d18-4a5d-b8f5-677e37769afe]" } ] },

This is the actual patron barcode: ;00013=01921712863? Following is the barcode format they use:[semicolon][5 numbers][equal sign][11 numbers][question mark]

CSP Request Details

Describe issue impact on business >>TA: Washington U. is a lynchpin for MOBIUS success. This was an unexpected need but is critical. What institutions are affected? (field “Effected Institutions” in Jira to be populated) >>TA: All of MOBIUS. What is the workaround if exists? >>TA: none. What areas will be impacted by fix (i.e. what areas need to be retested) >>TA: retrieval by barcode. Brief explanation of technical implementation and the level of effort (in workdays) and technical risk (low/medium/high) >>TA: low Brief explanation of testing required and level of effort (in workdays). Provide test plan agreed with by QA Manager and PO. >> less than one day. What is the roll back plan in case the fix does not work? >> previous release

CSP Rejection Details

None

Potential Workaround

None

Attachments

2
  • 02 Oct 2024, 12:19 PM
  • 02 Oct 2024, 11:19 AM

Checklist

hide

Activity

Show:

Irina PokhyletsOctober 10, 2024 at 6:08 PM
Edited

Hi
This ticket has been released in Q CSP #5 and should be deployed to MOBIUS' production FOLIO ECS system.

Jag GorayaOctober 10, 2024 at 3:26 PM

In ‘s absence, just noting here that Poppy CSP approval has been confirmed. Given this ticket is Closed, I’m guessing the backport for that is covered elsewhere. Will leave that with you to take whatever action is needed. Thanks.

Polina UstimenkoOctober 8, 2024 at 12:44 PM

Oleksii PetrenkoOctober 8, 2024 at 9:39 AM

Deployed to Q BF env

Vignesh KalyanasundaramOctober 4, 2024 at 10:31 AM

Hi New tag is created for this fix in Poppy https://github.com/folio-org/mod-dcb/releases/tag/2024.10.04

The release details have been updated in the https://folio-org.atlassian.net/wiki/spaces/FOLIJET/pages/1405816/DCB+Releases page as well.

Thanks.
cc :

Done

Details

Assignee

Reporter

Labels

Priority

Story Points

Sprint

Development Team

Volaris

Fix versions

Release

Quesnelia (R1 2024) Service Patch #5

RCA Group

Incomplete/missing requirements

CSP Approved

Yes

TestRail: Cases

Open TestRail: Cases

TestRail: Runs

Open TestRail: Runs

Created October 1, 2024 at 11:49 AM
Updated November 5, 2024 at 10:59 AM
Resolved October 2, 2024 at 11:46 AM
TestRail: Cases
TestRail: Runs

Flag notifications