Bug 40359

Summary: SIP2 Patron Info Fails with "AFInvalid cardnumber" – Item Info Works
Product: Koha Reporter: maher <maherahmad1994>
Component: SIP2Assignee: Bugs List <koha-bugs>
Status: NEW --- QA Contact: Testopia <testopia>
Severity: enhancement    
Priority: P5 - low    
Version: 25.05   
Hardware: All   
OS: All   
GIT URL: Change sponsored?: ---
Patch complexity: --- Documentation contact:
Documentation submission: Text to go in the release notes:
Version(s) released in:
Circulation function:

Description maher 2025-07-13 15:40:08 UTC
We are experiencing an issue with SIP2 in Koha. When we send a request to retrieve patron information,or even checkout the response returns AFInvalid cardnumber, and the logs show that the system cannot satisfy constraints like cardnumber, userid, and borrowernumber.

However, item information requests work correctly, and the SIP2 connection and authentication are confirmed to be successful.

The cardnumber we use exists in the Koha borrowers table, and the SIP2 account is configured properly. It seems that the cardnumber value is not being passed or recognized correctly during patron lookup.

We need assistance in identifying the cause of this issue and how to resolve it.
Comment 1 maher 2025-07-13 16:53:18 UTC
Unable to satisfy requested constraint 'cardnumber', missing values for column(s): 'cardnumber'
Unable to satisfy requested constraint 'userid'
Unable to satisfy requested constraint 'primary', missing values for column(s): 'borrowernumber'

request : 6320250713    150905YN|AOMK|AA123321123321|ACSip@123456|\r

response : 
64YYYY          20220250713    180907000000000000000000000000AOMK|AA|AE|BLN|AFInvalid cardnumber|
Comment 2 maher 2025-07-15 15:24:55 UTC
@Owen Leonard
i need solution !!!!
please u just ignore me