[OPEN-ILS-DEV] Error when creating items

Thu Mar 13 08:48:31 EDT 2008

I just wanted to report back and let you know that adding the shelving
information did fix the problem. I can add items to check out now. Thanks
again for all of your help. I will let you know if I run into any other
problems with the database but for now everything seems to be working as it
should and we are still in the testing phase right now so I will report any
other problems.

On Thu, Mar 13, 2008 at 8:39 AM, Robert Nix <glibrarysystem at gmail.com>
wrote:

> I don't recall any other SQL errors during the install but then again I
> was using the install scripts and a lot of the information went by really
> fast. I could've missed something. I will go in and add the shelving
> information into the DB and get back with the results. Thanks for the help
> thus far, it is greatly appreciated.
>
>
> On Wed, Mar 12, 2008 at 3:04 PM, Mike Rylander <mrylander at gmail.com>
> wrote:
>
> > 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
> >
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://list.georgialibraries.org/pipermail/open-ils-dev/attachments/20080313/f99ec33e/attachment.html