Re: [Koha] Unable to Checkin using SIP
Dear List , I am trying to checkin using SIP but unable to .iam alble to do the checkout but when i give the checkin message it give the message saying it has sucessfully checked in but the syslog does not reflect the same.copy of both checkout and checkin messages from syslog for your reference. Jul 6 05:49:34 boss acs-server[17728]: INPUT MSG: ' 11YN20090629 01234820090629 012348AO||AA1888|ABMIC004|^M' Jul 6 05:49:34 boss acs-server[17728]: Sip::MsgType::new('Sip::MsgType', '11YN200906...', '11'): seq.no '0', protocol 1 Jul 6 05:49:34 boss acs-server[17728]: Sip::MsgType::_initialize('Checkout', 'YN20090629 01234820090629 012348AO||AA1888|ABMIC004', 'CCA18A18', '38', ...) Jul 6 05:49:34 boss acs-server[17728]: Unsupported field '' in Checkout message 'YN20090629 01234820090629 012348AO||AA1888|ABMIC004' Jul 6 05:49:34 boss acs-server[17728]: new ILS::Patron(1888): found patron '1888' Jul 6 05:49:34 boss acs-server[17728]: new ILS::Item('MIC004'): found with title 'The 8051 Micro Controller-Architecture,Programming and Applications ' Jul 6 05:49:34 boss acs-server[17728]: ILS::Transaction::Checkout performing checkout... Jul 6 05:49:34 boss acs-server[17728]: ILS::Checkout: patron 1888 has checked out HASH(0x9738c9c), MIC004 Jul 6 05:49:34 boss acs-server[17728]: OUTPUT MSG: '121NNY20090706 054934AOCCL|AA1888|ABMIC004|AJThe 8051 Micro Controller-Architecture,Programming and Applications |AH0|' Jul 6 05:50:03 boss acs-server[17728]: INPUT MSG: ' ^M' Jul 6 05:50:03 boss acs-server[17728]: sip_protocol_loop: empty input skipped Jul 6 05:50:21 boss acs-server[17728]: INPUT MSG: ' 09N20090629 024548 AP|AOCCL|ABMIC004^M' Jul 6 05:50:21 boss acs-server[17728]: Sip::MsgType::new('Sip::MsgType', '09N2009062...', '09'): seq.no '0', protocol 1 Jul 6 05:50:21 boss acs-server[17728]: Sip::MsgType::_initialize('Checkin', 'N20090629 024548 AP|AOCCL|ABMIC004', 'CA18A18', '37', ...) Jul 6 05:50:21 boss acs-server[17728]: new ILS::Item('MIC004'): found with title 'The 8051 Micro Controller-Architecture,Programming and Applications ' Jul 6 05:50:21 boss acs-server[17728]: new ILS::Patron(1888): found patron '1888' Jul 6 05:50:21 boss acs-server[17728]: OUTPUT MSG: '101YNN20090706 055021AOCCL|ABMIC004|AQ|AJThe 8051 Micro Controller-Architecture,Programming and Applications |' from my understanding of the code the checkin doesnot initialize or the ILS is not initializing the checkin process .i have searched the entire web looking for an answer.please do help me out to resolve this issue. Thanks in advance for your kind help. regards, vimal
The Checkin Response message is: 101YNN20090706 055021AOCCL|ABMIC004|AQ|AJThe 8051 Micro Controller... The first two digits identify the message (10 - Checkin Response). The next digit identifies the success of the result: 1 means OK. So SIP says you got checked in fine. Your SIP client may be misinterpreting the result. However, the AQ (permanent location) field being empty and the lack of an AO (institution id) field suggest that the item here may not have a populated homebranch, or that your SIP config has not established what branch the terminal is operating at. The SIP user also should have a valid branchcode in their record, and SIPconfig.xml should have that valid branchcode as part of their "institution". That could cause the checkin to fail, since Koha would not know what branch the return should be happening at. Also, your SIP client is sending empty fields. That's why you get the "unsupported field" warning with the empty string. -- Joe Atzberger LibLime - Open Source Library Solutions 2009/7/6 vimal laxman <vimallaxman@gmail.com>
Dear List , I am trying to checkin using SIP but unable to .iam alble to do the checkout but when i give the checkin message it give the message saying it has sucessfully checked in but the syslog does not reflect the same.copy of both checkout and checkin messages from syslog for your reference.
Jul 6 05:49:34 boss acs-server[17728]: INPUT MSG: ' 11YN20090629 01234820090629 012348AO||AA1888|ABMIC004|^M' Jul 6 05:49:34 boss acs-server[17728]: Sip::MsgType::new('Sip::MsgType', '11YN200906...', '11'): seq.no '0', protocol 1 Jul 6 05:49:34 boss acs-server[17728]: Sip::MsgType::_initialize('Checkout', 'YN20090629 01234820090629 012348AO||AA1888|ABMIC004', 'CCA18A18', '38', ...) Jul 6 05:49:34 boss acs-server[17728]: Unsupported field '' in Checkout message 'YN20090629 01234820090629 012348AO||AA1888|ABMIC004' Jul 6 05:49:34 boss acs-server[17728]: new ILS::Patron(1888): found patron '1888' Jul 6 05:49:34 boss acs-server[17728]: new ILS::Item('MIC004'): found with title 'The 8051 Micro Controller-Architecture,Programming and Applications '
Jul 6 05:49:34 boss acs-server[17728]: ILS::Transaction::Checkout performing checkout... Jul 6 05:49:34 boss acs-server[17728]: ILS::Checkout: patron 1888 has checked out HASH(0x9738c9c), MIC004 Jul 6 05:49:34 boss acs-server[17728]: OUTPUT MSG: '121NNY20090706 054934AOCCL|AA1888|ABMIC004|AJThe 8051 Micro Controller-Architecture,Programming and Applications |AH0|' Jul 6 05:50:03 boss acs-server[17728]: INPUT MSG: ' ^M' Jul 6 05:50:03 boss acs-server[17728]: sip_protocol_loop: empty input skipped Jul 6 05:50:21 boss acs-server[17728]: INPUT MSG: ' 09N20090629 024548 AP|AOCCL|ABMIC004^M' Jul 6 05:50:21 boss acs-server[17728]: Sip::MsgType::new('Sip::MsgType', '09N2009062...', '09'): seq.no '0', protocol 1 Jul 6 05:50:21 boss acs-server[17728]: Sip::MsgType::_initialize('Checkin', 'N20090629 024548 AP|AOCCL|ABMIC004', 'CA18A18', '37', ...) Jul 6 05:50:21 boss acs-server[17728]: new ILS::Item('MIC004'): found with title 'The 8051 Micro Controller-Architecture,Programming and Applications '
Jul 6 05:50:21 boss acs-server[17728]: new ILS::Patron(1888): found patron '1888' Jul 6 05:50:21 boss acs-server[17728]: OUTPUT MSG: '101YNN20090706 055021AOCCL|ABMIC004|AQ|AJThe 8051 Micro Controller-Architecture,Programming and Applications |'
from my understanding of the code the checkin doesnot initialize or the ILS is not initializing the checkin process .i have searched the entire web looking for an answer.please do help me out to resolve this issue.
dear Mr.Joe, Thank you so much for your reply.i too understood from the message stream that the checkin was fine but unfortunately i dont dee the check in happen.i kept wondering why some fields were empty and i got the answer from you.but the item which i am erfering too has both permanent location and current location fields populated(with 'C-DAC Central Library') and the AO field reflects CCL which is the institution ID.iam not sure as how to make the terminal understand that it is operating in 'CDAC Central Library'.The SIP user has a valid brancode 'CCL' in their record and SIPconfig.xml also has 'CCL' as a branchcode as part of the "institution".piece of the SIPconfig.xml for your persual. <accounts> <login id="root" password="root" delimiter="|" error-detect="enabled" institution="CCL" /> <login id="vimallaxman" password="ramlaxman" delimiter="|" error-detect="enabled" institution="CCL" /> <login id="koha" password="koha" delimiter="|" error-detect="enabled" institution="CCL" /> </accounts> <institutions> <institution id="CCL" implementation="ILS" parms=""> <policy checkin="true" checkout="true" renewal="true" status_update="true" offline="false" timeout="100" retries="1010" /> </institution> </institutions> My DBD:Mysql throws this error: DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key constraint fails (`Koha/items`, CONSTRAINT `items_ibfk_3` FOREIGN KEY (`holdingbranch`) REFERENCES `branches` (`branchcode`) ON UPDATE CASCADE) at /usr/share/koha/lib/C4/Items.pm line 1870. DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key constraint fails (`Koha/branchtransfers`, CONSTRAINT `branchtransfers_ibfk_1` FOREIGN KEY (`frombranch`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE) at /usr/share/koha/lib/C4/Items.pm line 471. My SIPServer times out after few tries saying this: sip_protocol_loop: quitting after too many errors at SIPServer.pm line 286. i would like you to thank you once again for your promt response. regards, vimal
Eureka, Its working.Thank you so much Mr.Joe and the list for your support.As rightly pointed by you the problem was with the branch code and institution ID.it has to be the same as the permanent location of the item.but still i get the empty fields and the SIPServer connection gets closed after say few tries saying: Jul 6 10:29:21 boss acs-server[1407]: sip_protocol_loop: quitting after too many errors . is it because of the empty fields if so how to avoid the same.kindly suggest. Thanks and Regards, vimal
branch code is hardcoded in C4/SIP/ILS/Transaction/Checkin.pm (line 40) did you change this? Marijana On Mon, Jul 06, 2009 at 10:36:23AM -0400, vimal laxman wrote:
Eureka, Its working.Thank you so much Mr.Joe and the list for your support.As rightly pointed by you the problem was with the branch code and institution ID.it has to be the same as the permanent location of the item.but still i get the empty fields and the SIPServer connection gets closed after say few tries saying:
Jul 6 10:29:21 boss acs-server[1407]: sip_protocol_loop: quitting after too many errors .
is it because of the empty fields if so how to avoid the same.kindly suggest.
Thanks and Regards, vimal
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Hi Marijana, Yes I did change the same.in my last mail i forgot to mention the same.but still i get the empty fields and the SIPServer connection gets closed after say few tries saying: Jul 6 10:29:21 boss acs-server[1407]: sip_protocol_loop: quitting after too many errors . is it because of the empty fields if so how to avoid the same.awaiting your valuable suggestions. Thanks and Regards, vimal
participants (3)
-
Joe Atzberger -
Marijana Glavica -
vimal laxman