[Koha] Unable to Checkin using SIP

[vimal laxman]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.katipo.co.nz/pipermail/koha/attachments/20090706/56068a21/attachment.htm