[OPEN-ILS-DEV] Error when creating items

[Mike Rylander]

On Wed, Mar 12, 2008 at 1:29 PM, Robert Nix <glibrarysystem at gmail.com> wrote:
> Mike,
>
> When I am entering in the new information for the copy it will not let me
> add a shelf location. The location has three question marks in it ??? and
> when I click the box to change it there is no text box that comes up like
> the rest of the fields. Do I need to go into the postgresql and add the row
> back in there manually or is there another way to do it? Is there a file I
> can download like a sql file that can rebuild the database? I don't have any
> real information in it yet and I want to make sure that there are no other
> problems with the database itself before I continue so this would be the
> desireable direction to move in for me.
>

>From the Admin menu there is a Local Administration option.  On that
interface there is a Copy Locations editor.  You can use that to add
shelving locations to any part of the hierarchy that you have access
to.

However, it's disturbing that you have no shelving locations by
default.  Stacks is installed by default and is attached to the top of
the organizational hierarchy, and should be available to any staff
member account, so I'm wondering why this went away.  Did you see any
SQL errors other than SCHEMA DOES NOT EXIST during installation?

--miker

>
>
> On Wed, Mar 12, 2008 at 12:52 PM, Mike Rylander <mrylander at gmail.com> wrote:
>
> >
> > 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
> >
>
>



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