dear Mr.Joe,<br> 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.<br>
<br><accounts><br> <login id="root" password="root" delimiter="|" error-detect="enabled" institution="CCL" /><br> <login id="vimallaxman" password="ramlaxman" delimiter="|" error-detect="enabled" institution="CCL" /><br>
<login id="koha" password="koha" delimiter="|" error-detect="enabled" institution="CCL" /><br> </accounts><br><br><br><institutions><br> <institution id="CCL" implementation="ILS" parms=""><br>
<policy checkin="true" checkout="true" renewal="true"<br> status_update="true" offline="false"<br> timeout="100"<br> retries="1010" /><br>
</institution><br><br></institutions><br><br>My DBD:Mysql throws this error:<br><br>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.<br>
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.<br>
<br><br>My SIPServer times out after few tries saying this:<br><br>sip_protocol_loop: quitting after too many errors at SIPServer.pm line 286.<br><br><br>i would like you to thank you once again for your promt response.<br>
<br>regards,<br>vimal<br>