Bug 40359 - SIP2 Patron Info Fails with "AFInvalid cardnumber" – Item Info Works
Summary: SIP2 Patron Info Fails with "AFInvalid cardnumber" – Item Info Works
Status: NEW
Alias: None
Product: Koha
Classification: Unclassified
Component: SIP2 (show other bugs)
Version: 25.05
Hardware: All All
: P5 - low enhancement
Assignee: Bugs List
QA Contact: Testopia
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2025-07-13 15:40 UTC by maher
Modified: 2025-07-15 15:24 UTC (History)
0 users

See Also:
GIT URL:
Change sponsored?: ---
Patch complexity: ---
Documentation contact:
Documentation submission:
Text to go in the release notes:
Version(s) released in:
Circulation function:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
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