[OPEN-ILS-DEV] Error when creating items

[Mike Rylander]

On Wed, Mar 12, 2008 at 10:37 AM, Robert Nix <glibrarysystem at gmail.com> wrote:
> Bill,
>
>     I was able to locate the postgresql log and this is the error that I
> found:
>
> 2008-03-12 14:22:10 UTC LOG:  autovacuum: processing database "postgres"
> 2008-03-12 14:22:56 UTC WARNING:  there is no transaction in progress
>  2008-03-12 14:23:01 UTC ERROR:  insert or update on table "copy" violates
> foreign key constraint "copy_location_fkey"
> 2008-03-12 14:23:01 UTC DETAIL:  Key (location)=(1) is not present in table
> "copy_location".
>  2008-03-12 14:23:07 UTC WARNING:  there is no transaction in progress
>
> It looks like it doesn't want us to copy from the table but I can't be sure.
> What would be the next step?
>

It looks like the shelving location "Stacks", which is inserted by
default during installation, has been removed.  If you have added more
shelving locations and removed that one then you'll need to log out of
the staff client and log back in, as it caches those.  The expectation
is that shelving locations intended for use would not be removed
during normal operating hours.

You'll need at least one shelving location in the database, and the
location field will default to 1 (the id for the Stack location) if
you do not provide one when creating the copies.

Hope that gets you further.

--miker

>
>
>  On Tue, Mar 11, 2008 at 5:48 PM, Bill Erickson <erickson at esilibrary.com>
> wrote:
> >
> > Robert Nix wrote:
> > > Bill,
> > >
> > >   I have looked at the log and it seems to show that there is an error
> > > committing transactions with multiple modules. This could be from the
> > > initial module that fails to commit the transaction. I am attaching a
> > > copy of the osrfsys.log file. I took a sample from initial logon to exit
> > > so the actual error is at the bottom of the file but I just wanted to
> > > show that it was up and running and is able to interact with the client.
> > > Any help on the subject would be greatly appreciated.
> >
> > So, you were able to create the copy OK:
> >
> > -> editor[1|1] created a new asset.copy object with ID 32
> >
> > but the database commit failed:
> >
> > -> open-ils.cstore: Error committing transaction
> >
> > My next stop would be the Postgres logs.  It should provide some
> > SQL-level error message that sheds light on the commit failure.  I don't
> > recall offhand, however, where those logs are by default.
> >
> >
> >
> >
> > -bill
> >
> >
> > --
> > Bill Erickson
> > | VP, Software Development & Integration
> > | Equinox Software, Inc. / The Evergreen Experts
> > | phone: 877-OPEN-ILS (673-6457)
> > | email: erickson at esilibrary.com
> > | web: http://esilibrary.com
> >
>
>



-- 
Mike Rylander
 | VP, Research and Design
 | Equinox Software, Inc. / The Evergreen Experts
 | phone: 1-877-OPEN-ILS (673-6457)
 | email: miker at esilibrary.com
 | web: http://www.esilibrary.com