Re: Unable to Checkin using SIP

View: New views
6 Messages — Rating Filter:   Alert me  

Re: Unable to Checkin using SIP

by vimal laxman :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

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

_______________________________________________
Koha mailing list
Koha@...
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: Unable to Checkin using SIP

by Joe Atzberger :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

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@...>
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.


_______________________________________________
Koha mailing list
Koha@...
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: Unable to Checkin using SIP

by vimal laxman :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

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

_______________________________________________
Koha mailing list
Koha@...
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: Unable to Checkin using SIP

by vimal laxman :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

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@...
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: Unable to Checkin using SIP

by Marijana Glavica :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

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@...
> http://lists.katipo.co.nz/mailman/listinfo/koha

_______________________________________________
Koha mailing list
Koha@...
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: Unable to Checkin using SIP

by vimal laxman :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

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
_______________________________________________
Koha mailing list
Koha@...
http://lists.katipo.co.nz/mailman/listinfo/koha