[OPEN-ILS-DEV] Can't Create bib record

[Frances Dean McNamara]

We have a database where we've loaded bibs in batch.  However, when I try to create a new bib I get the below error which is an insert error.  I'm wondering, is there something obvious that causes this?  Like does something have to be set for it to start incrementing to the next correct ID number as it adds more records to the db?  Is there some setup step I have missed?  Thanks.  Frances McNamara

{
                "ilsevent":"2002",
                "textcode":"DATABASE_QUERY_FAILED",
                "servertime":"Tue Aug 11 10:05:54 2009",
                "stacktrace":"/opt/openils/lib/perl5/OpenILS/Utils/CStoreEditor.pm:652 (eval 1637):1 /opt/openils/lib/perl5/OpenILS/Application/Cat/BibCommon.pm:109",
                "pid":"13858",
                "desc":"The attempt to query to the DB failed",
                "debug":"Exception: OpenSRF::DomainObject::oilsMethodException 2009-08-11T10:05:54 OpenILS::Utils::CStoreEditor
/opt/openils/lib/perl5/OpenILS/Utils/CStoreEditor.pm:652 <500>  INSERT error -- please see the error log for more details\n",
                "payload":
                {
                                "__c":"bre",
                                "__p":
                                [
                                                null,
                                                null,
                                                null,
                                                null,
                                                null,
                                                null,
                                                "now",
                                                1,
                                                null,
                                                "now",
                                                1,
                                                null,
                                                null,
                                                null,
                                                "<record xmlns=\"http://www.loc.gov/MARC21/slim\" xmlns:marc=\"http://www.loc.gov/MARC21/slim\">\n  <
leader>00620cam a2200205Ka 4500</leader>\n  <controlfield tag=\"005\">20090811150553.0</controlfield>\n  <controlfield tag=\"008\">070101s                            eng d</controlfield>\n  <datafield tag=\"010\" ind1=\"\" ind2=\"\">\n    <subfield code=\"a\"/>\n  </datafield>\n  <datafield tag=\"020\" ind1=\"\" ind2=\"\">\n    <subfield code=\"a\"/>\n  </datafield>\n  <datafield tag=\"082\" ind1=\"0\" ind2=\"4\">\n    <subfield code=\"a\"/>\n  </datafield>\n  <datafield tag=\"092\" ind1=\"\" ind2=\"\">\n    <subfield code=\"a\"/>\n  </datafield>\n  <datafield tag=\"100\" ind1=\"\" ind2=\"\">\n    <subfield code=\"a\"/>\n  </datafield>\n  <datafield tag=\"245\" ind1=\"\" ind2=\"\">\n    <subfield code=\"a\">FM test of create bib record</subfield>\n    <subfield code=\"b\"/>\n    <subfield code=\"c\"/>\n  </datafield>\n  <datafield tag=\"260\" ind1=\"\" ind2=\"\">\n    <subfield code=\"a\"/>\n    <subfield code=\"b\"/>\n    <subfield code=\"c\"/>\n  </datafield>\n  <datafield tag=\"300\" ind1=\"\" ind2=\"\">\n    <subfield code=\"a\"/>\n    <subfield code=\"b\"/>\n    <subfield code=\"c\"/>\n  </datafield>\n  <datafield tag=\"500\" ind1=\"\" ind2=\"\">\n
<subfield code=\"a\"/>\n  </datafield>\n  <datafield tag=\"650\" ind1=\"\" ind2=\"\">\n    <subfield code=\"a\"/>\n    <subfield code=\"v\"/>\n
</datafield>\n  <datafield tag=\"650\" ind1=\"\" ind2=\"\">\n    <subfield code=\"a\"/>\n  </datafield>\n</record>",
                                                null,
                                                2
                                ]

                }

}
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://libmail.georgialibraries.org/pipermail/open-ils-dev/attachments/20090811/d20c174b/attachment.htm