Re: [OPEN-ILS-GENERAL] Error adding copies to a title
Thank you Jason let me see what I find there. -Original Message- From: Open-ils-general [mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of Jason Stephenson Sent: Friday, November 30, 2018 2:51 PM To: open-ils-general@list.georgialibraries.org Subject: Re: [OPEN-ILS-GENERAL] Error adding copies to a title Hi, On 11/30/18 1:12 AM, Chazya Sinkamba wrote: > Hello, > DATABASE_UPDATE_FAILED > > The attempt to write to the DB failed" Usually when the above happens, you can find the database error in the PostgreSQL logs. Once you have that information, it should not be too difficult to figure out the problem. HtH, Jason
[OPEN-ILS-GENERAL] Error adding copies to a title
Hello, Our evergreen install recently went haywire, giving the following message when attempting to add a title. "FIXME: If you encounter this alert, please inform your IT/ILS helpdesk staff or your friendly Evergreen developers. Fri Nov 28 2018 12:46:40 GMT+0200 (South Africa Standard Time) copy update DATABASE_UPDATE_FAILED The attempt to write to the DB failed" Editing of records appears to be working fine. Anyone able to point me in the right direction to rectify this? Chazya Sinkamba, Dip AME, BIT(c) Programmer Associate chazya.sinkamba[at]northrise.net | m: +260 964 350 487 | p: +260 960776144 | skype: chazya.sinkamba <http://www.northriseuniversity.com/> www.northriseuniversity.com | <http://www.northrise.org/> www.northrise.org <https://www.facebook.com/Northrise><https://twitter.com/northriseu> <https://vimeo.com/northrise> Main Campus: 30029 Kitwe-Ndola Dual Carriage Highway . P.O. Box 240271 . Ndola . Zambia Town Campus: Buteko Avenue . Caravelle House . P.O. Box 240271 . Ndola . Zambia Solwezi Campus: Mary Begg Kansanshi Mine Clinic . Mushitala . P.O. Box 110274 . Solwezi . Zambia This message is confidential. It may also be privileged or otherwise protected by work product immunity or other legal rules. If you have received it by mistake, please let us know by e-mail reply and delete it from your system; you may not copy this message or disclose its contents to anyone. The integrity and security of this message cannot be guaranteed on the Internet.
Re: [OPEN-ILS-GENERAL] Evergreen Search function
Thank you Jason. I ran the program and then restarted my server. I'm still testing ,but it appeared to have worked. Appreciate the tip. -Original Message- From: Open-ils-general [mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of Jason Stephenson Sent: Thursday, July 05, 2018 3:24 PM To: open-ils-general@list.georgialibraries.org Subject: Re: [OPEN-ILS-GENERAL] Evergreen Search function On 07/05/2018 08:56 AM, Chazya Sinkamba wrote: > Thanks Jason. Yes the tables you have mentioned have appropriate entries. Chazya, you may need to "ingest" the records so that they are indexed for search. I wrote a script to do that in parallel: https://github.com/Dyrcona/evergreen_utilities/blob/master/perl/pingest.pl There is also a Launchpad bug to add this utility to Evergreen, itself: https://bugs.launchpad.net/evergreen/+bug/1768715 The git branch on the Launchpad bug has release notes with some documentation on how to use it. Hope that helps and good luck! Jason
Re: [OPEN-ILS-GENERAL] Evergreen Search function
Thanks Jason. Yes the tables you have mentioned have appropriate entries. -Original Message- From: Open-ils-general [mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of Jason Stephenson Sent: Thursday, July 05, 2018 2:16 PM To: open-ils-general@list.georgialibraries.org Subject: Re: [OPEN-ILS-GENERAL] Evergreen Search function On 07/05/2018 03:38 AM, Chazya Sinkamba wrote: > I just installed the 3.0 version. The problem still persists, but > instead of the ‘internal server error messages’, I am being redirected > to the ‘nothing found for your search’ page and being asked to refine my > search. Do you have copies in the database? That is were entries made in the asset.copy table when you imported your records and do these copies link to the bilbiographic record (biblio.record_entry table) via the asset.call_number table? If not, the OPAC will not return search results. You should get results in the staff client for empty records, however. Cheers, Jason
Re: [OPEN-ILS-GENERAL] Evergreen Search function
Please note my responses under the questions. Thank you for the assistance. -Original Message- From: Open-ils-general [mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of Jason Stephenson Sent: Monday, June 25, 2018 8:23 PM To: open-ils-general@list.georgialibraries.org Subject: Re: [OPEN-ILS-GENERAL] Evergreen Search function Hello, Chazya. I will ask/answer specific points in the quoted text below. On 06/25/2018 04:29 AM, Chazya Sinkamba wrote: > Hello, > > I am new to evergreen, I have set up a test server with a few thousand > titles imported from our old ILS. My problem is when in the web > interface, a user is able to find titles by barcode in the advanced > search tab, but nothing shows up when searching by keyword. How did you import these titles into Evergreen? Did you disable any database triggers during the import? I do not remember disabling any triggers, I made sql scripts based on the eg database schema, as I could not get the old ILS (Destiny Resource Manager (v8.5 (rc8) - 07/08/2008)) to export in a form that was suitable for direct batch import into evergreen. > > Further,browsing the catalog brings a list of titles, but clicking on > them results in a internal server error response. However, if I > click on a title that comes up as a result of a barcode search, > information comes up as expected. You should be able to start with the Apache error logs for the time that the error occurred. There will usually be a message pointing to the actual error that occurred in the back end. There will also be many less useful messages. See below > > I am running the 2.11 version of evergreen, and 2.4.2 version of > opensrf on Ubuntu 16.04 LTS. I recommend switching to the latest 3.0 version of both Evergreen and OpenSRF. The versions you are using are no longer supported by the community, not even for security updates. I just installed the 3.0 version. The problem still persists, but instead of the internal server error messages, I am being redirected to the nothing found for your search page and being asked to refine my search. > > Has anyone else experienced this? Would anyone have an explanation for > this behaviour? I've experienced many similar problems when setting up test and development environments for Evergreen. It almost always comes down to something that I did wrong or skipped during the installation process, or a bug in some experimental code that I am testing. Less often, it is a bona fide bug in Evergreen or OpenSRF. So many different things can lead to internal server errors with Apache and Evergreen that we cannot begin to speculate without more information. Hope that helps, and please share more information so we can help. Cheers, Jason
[OPEN-ILS-GENERAL] Evergreen Search function
Hello, I am new to evergreen, I have set up a test server with a few thousand titles imported from our old ILS. My problem is when in the web interface, a user is able to find titles by barcode in the advanced search tab, but nothing shows up when searching by keyword. Further,browsing the catalog brings a list of titles, but clicking on them results in a 'internal server error' response. However, if I click on a title that comes up as a result of a barcode search, information comes up as expected. I am running the 2.11 version of evergreen, and 2.4.2 version of opensrf on Ubuntu 16.04 LTS. Has anyone else experienced this? Would anyone have an explanation for this behaviour? Thanks in advance for your help. Chazya Sinkamba, Dip AME, BIT(c) Programmer Associate chazya.sinkamba[at]northrise.net | m: +260 964 350 487 | p: +260 960776144 | skype: chazya.sinkamba <http://www.northriseuniversity.com/> www.northriseuniversity.com | <http://www.northrise.org/> www.northrise.org <https://www.facebook.com/Northrise><https://twitter.com/northriseu> <https://vimeo.com/northrise> Main Campus: 30029 Kitwe-Ndola Dual Carriage Highway . P.O. Box 240271 . Ndola . Zambia Town Campus: Buteko Avenue . Caravelle House . P.O. Box 240271 . Ndola . Zambia Solwezi Campus: Mary Begg Kansanshi Mine Clinic . Mushitala . P.O. Box 110274 . Solwezi . Zambia This message is confidential. It may also be privileged or otherwise protected by work product immunity or other legal rules. If you have received it by mistake, please let us know by e-mail reply and delete it from your system; you may not copy this message or disclose its contents to anyone. The integrity and security of this message cannot be guaranteed on the Internet.
Re: [OPEN-ILS-GENERAL] Some help setting up.
Yes Ben I did rename the organizational units. From: Open-ils-general [mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of Ben Shum Sent: Monday, November 06, 2017 4:08 PM To: Evergreen Discussion Group <open-ils-general@list.georgialibraries.org> Subject: Re: [OPEN-ILS-GENERAL] Some help setting up. Ah okay, I re-read your original email. So this error is only occurring when you do a search by database ID? And you're on a 2.11 test system? And you're using the database ID from Evergreen for the bib record you want to find? Hmm... I'll think about that some more. It could be that there's some other misconfigured setting afoot. What other changes have you made to the test server? Did you rename any of the organizational units? -- Ben On Mon, Nov 6, 2017 at 8:58 AM, Chazya Sinkamba <chazya.sinka...@northrise.net <mailto:chazya.sinka...@northrise.net> > wrote: Hi Ben, Thanks . I have assigned 8GB RAM to the test server, and free reign of a core i3 processor From: Open-ils-general [mailto:open-ils-general-boun...@list.georgialibraries.org <mailto:open-ils-general-boun...@list.georgialibraries.org> ] On Behalf Of Ben Shum Sent: Monday, November 06, 2017 3:59 PM To: Evergreen Discussion Group <open-ils-general@list.georgialibraries.org <mailto:open-ils-general@list.georgialibraries.org> > Subject: Re: [OPEN-ILS-GENERAL] Some help setting up. Slow rate of response and internal server errors like that, my first instinct would be a potential memory exhaustion issue and Linux killing off critical services in between use and commands. How much RAM is assigned to your test server? For my test servers, I usually assign 4 GB of memory for my Evergreen virtual machines. For production, you will probably need more memory depending on the number of users expected to access, size of your database with real bib records and copy data, etc. -- Ben On Mon, Nov 6, 2017 at 7:22 AM, Chazya Sinkamba <chazya.sinka...@northrise.net <mailto:chazya.sinka...@northrise.net> > wrote: Thanks a lot for the response. Apache restart does not appear to help. From: Open-ils-general [mailto:open-ils-general-boun...@list.georgialibraries.org <mailto:open-ils-general-boun...@list.georgialibraries.org> ] On Behalf Of Dan Scott Sent: Monday, November 06, 2017 1:38 PM To: Evergreen Discussion Group <open-ils-general@list.georgialibraries.org <mailto:open-ils-general@list.georgialibraries.org> > Subject: Re: [OPEN-ILS-GENERAL] Some help setting up. Bit of a wild guess, but Apache needs to be started or restarted *after* the opensrf services. On Nov 6, 2017 2:38 AM, "Chazya Sinkamba" <chazya.sinka...@northrise.net <mailto:chazya.sinka...@northrise.net> > wrote: Hello, So I set up an evergreen server following the instructions here: http://docs.evergreen-ils.org/2.11/ some months back and loaded sample data (concerto). I got back to work on it today, and when I use the search by database ID option, I get the internal server error on my screen. I have confirmed the ID does exist in the database. Anyone else ever experienced this, or has a remedy for it? The 3 lines below appeared in the logs at the time I was searching: Nov 6 08:52:15 ubuntu-evergreen root: 10.5.1.84 - - [06/Nov/2017:08:50:05 +0200] "GET /eg/opac/results?blimit=10;qtype=title;locg=1;fi%3Ahas_browse_entry=631%2C31 HTTP/1.1" 500 982 Nov 6 08:53:10 ubuntu-evergreen apache2[13620]: [perl:warn] [pid 13620] [client 10.5.1.84:62785 <http://10.5.1.84:62785> ] egweb: template error: undef error - Can't use an undefined value as an ARRAY reference at /usr/local/share/perl/5.22.1/OpenILS/WWW/EGCatLoader/Util.pm line 102.\n Nov 6 08:53:10 ubuntu-evergreen root: 10.5.1.84 - - [06/Nov/2017:08:52:09 +0200] "GET /eg/opac/record/100 HTTP/1.1" 500 2552 Searching the catalog won’t work either as when I click on a title, the page takes an unbelievable amount of time to load, then brings up the search screen as in the attached screenshot. Some help will be appreciated. Regards Chazya Sinkamba, Dip AME, BIT(c) Programmer Associate chazya.sinkamba[at]northrise.net <http://northrise.net> | m: +260 964 350 487 | p: +260 212 622 195 | f: +260 212 622 198 <http://www.northriseuniversity.com/> www.northriseuniversity.com | <http://www.northrise.org/> www.northrise.org <https://www.facebook.com/Northrise><https://twitter.com/northriseu> <https://vimeo.com/northrise> Main Campus: 30029 Kitwe-Ndola Dual Carriage Highway • P.O. Box 240271 • Ndola • Zambia Town Campus: Buteko Avenue • Caravelle House • P.O. Box 240271 • Ndola • Zambia Solwezi Campus: Mary Begg Kansanshi Mine Clinic • Mushitala • P.O. Box 110274 • Solwezi • Zambia This message is confidentia
Re: [OPEN-ILS-GENERAL] Some help setting up.
I just noticed something, database IDs 1-4 are responding, everything after that is resulting in the same error. I don’t understand why, I imported the same xml file using the instructions on migration. Anyone else ever experienced this? From: Open-ils-general [mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of Ben Shum Sent: Monday, November 06, 2017 4:08 PM To: Evergreen Discussion Group <open-ils-general@list.georgialibraries.org> Subject: Re: [OPEN-ILS-GENERAL] Some help setting up. Ah okay, I re-read your original email. So this error is only occurring when you do a search by database ID? And you're on a 2.11 test system? And you're using the database ID from Evergreen for the bib record you want to find? Hmm... I'll think about that some more. It could be that there's some other misconfigured setting afoot. What other changes have you made to the test server? Did you rename any of the organizational units? -- Ben On Mon, Nov 6, 2017 at 8:58 AM, Chazya Sinkamba <chazya.sinka...@northrise.net <mailto:chazya.sinka...@northrise.net> > wrote: Hi Ben, Thanks . I have assigned 8GB RAM to the test server, and free reign of a core i3 processor From: Open-ils-general [mailto:open-ils-general-boun...@list.georgialibraries.org <mailto:open-ils-general-boun...@list.georgialibraries.org> ] On Behalf Of Ben Shum Sent: Monday, November 06, 2017 3:59 PM To: Evergreen Discussion Group <open-ils-general@list.georgialibraries.org <mailto:open-ils-general@list.georgialibraries.org> > Subject: Re: [OPEN-ILS-GENERAL] Some help setting up. Slow rate of response and internal server errors like that, my first instinct would be a potential memory exhaustion issue and Linux killing off critical services in between use and commands. How much RAM is assigned to your test server? For my test servers, I usually assign 4 GB of memory for my Evergreen virtual machines. For production, you will probably need more memory depending on the number of users expected to access, size of your database with real bib records and copy data, etc. -- Ben On Mon, Nov 6, 2017 at 7:22 AM, Chazya Sinkamba <chazya.sinka...@northrise.net <mailto:chazya.sinka...@northrise.net> > wrote: Thanks a lot for the response. Apache restart does not appear to help. From: Open-ils-general [mailto:open-ils-general-boun...@list.georgialibraries.org <mailto:open-ils-general-boun...@list.georgialibraries.org> ] On Behalf Of Dan Scott Sent: Monday, November 06, 2017 1:38 PM To: Evergreen Discussion Group <open-ils-general@list.georgialibraries.org <mailto:open-ils-general@list.georgialibraries.org> > Subject: Re: [OPEN-ILS-GENERAL] Some help setting up. Bit of a wild guess, but Apache needs to be started or restarted *after* the opensrf services. On Nov 6, 2017 2:38 AM, "Chazya Sinkamba" <chazya.sinka...@northrise.net <mailto:chazya.sinka...@northrise.net> > wrote: Hello, So I set up an evergreen server following the instructions here: http://docs.evergreen-ils.org/2.11/ some months back and loaded sample data (concerto). I got back to work on it today, and when I use the search by database ID option, I get the internal server error on my screen. I have confirmed the ID does exist in the database. Anyone else ever experienced this, or has a remedy for it? The 3 lines below appeared in the logs at the time I was searching: Nov 6 08:52:15 ubuntu-evergreen root: 10.5.1.84 - - [06/Nov/2017:08:50:05 +0200] "GET /eg/opac/results?blimit=10;qtype=title;locg=1;fi%3Ahas_browse_entry=631%2C31 HTTP/1.1" 500 982 Nov 6 08:53:10 ubuntu-evergreen apache2[13620]: [perl:warn] [pid 13620] [client 10.5.1.84:62785 <http://10.5.1.84:62785> ] egweb: template error: undef error - Can't use an undefined value as an ARRAY reference at /usr/local/share/perl/5.22.1/OpenILS/WWW/EGCatLoader/Util.pm line 102.\n Nov 6 08:53:10 ubuntu-evergreen root: 10.5.1.84 - - [06/Nov/2017:08:52:09 +0200] "GET /eg/opac/record/100 HTTP/1.1" 500 2552 Searching the catalog won’t work either as when I click on a title, the page takes an unbelievable amount of time to load, then brings up the search screen as in the attached screenshot. Some help will be appreciated. Regards Chazya Sinkamba, Dip AME, BIT(c) Programmer Associate chazya.sinkamba[at]northrise.net <http://northrise.net> | m: +260 964 350 487 | p: +260 212 622 195 | f: +260 212 622 198 <http://www.northriseuniversity.com/> www.northriseuniversity.com | <http://www.northrise.org/> www.northrise.org <https://www.facebook.com/Northrise><https://twitter.com/northriseu> <https://vimeo.com/northrise> Main Campus: 30029 Kitwe-Ndola Dual Carriage Highway • P.O. Box 240271 • Ndola • Zambia Town Cam
Re: [OPEN-ILS-GENERAL] Some help setting up.
Hi Ben, Thanks . I have assigned 8GB RAM to the test server, and free reign of a core i3 processor From: Open-ils-general [mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of Ben Shum Sent: Monday, November 06, 2017 3:59 PM To: Evergreen Discussion Group <open-ils-general@list.georgialibraries.org> Subject: Re: [OPEN-ILS-GENERAL] Some help setting up. Slow rate of response and internal server errors like that, my first instinct would be a potential memory exhaustion issue and Linux killing off critical services in between use and commands. How much RAM is assigned to your test server? For my test servers, I usually assign 4 GB of memory for my Evergreen virtual machines. For production, you will probably need more memory depending on the number of users expected to access, size of your database with real bib records and copy data, etc. -- Ben On Mon, Nov 6, 2017 at 7:22 AM, Chazya Sinkamba <chazya.sinka...@northrise.net <mailto:chazya.sinka...@northrise.net> > wrote: Thanks a lot for the response. Apache restart does not appear to help. From: Open-ils-general [mailto:open-ils-general-boun...@list.georgialibraries.org <mailto:open-ils-general-boun...@list.georgialibraries.org> ] On Behalf Of Dan Scott Sent: Monday, November 06, 2017 1:38 PM To: Evergreen Discussion Group <open-ils-general@list.georgialibraries.org <mailto:open-ils-general@list.georgialibraries.org> > Subject: Re: [OPEN-ILS-GENERAL] Some help setting up. Bit of a wild guess, but Apache needs to be started or restarted *after* the opensrf services. On Nov 6, 2017 2:38 AM, "Chazya Sinkamba" <chazya.sinka...@northrise.net <mailto:chazya.sinka...@northrise.net> > wrote: Hello, So I set up an evergreen server following the instructions here: http://docs.evergreen-ils.org/2.11/ some months back and loaded sample data (concerto). I got back to work on it today, and when I use the search by database ID option, I get the internal server error on my screen. I have confirmed the ID does exist in the database. Anyone else ever experienced this, or has a remedy for it? The 3 lines below appeared in the logs at the time I was searching: Nov 6 08:52:15 ubuntu-evergreen root: 10.5.1.84 - - [06/Nov/2017:08:50:05 +0200] "GET /eg/opac/results?blimit=10;qtype=title;locg=1;fi%3Ahas_browse_entry=631%2C31 HTTP/1.1" 500 982 Nov 6 08:53:10 ubuntu-evergreen apache2[13620]: [perl:warn] [pid 13620] [client 10.5.1.84:62785 <http://10.5.1.84:62785> ] egweb: template error: undef error - Can't use an undefined value as an ARRAY reference at /usr/local/share/perl/5.22.1/OpenILS/WWW/EGCatLoader/Util.pm line 102.\n Nov 6 08:53:10 ubuntu-evergreen root: 10.5.1.84 - - [06/Nov/2017:08:52:09 +0200] "GET /eg/opac/record/100 HTTP/1.1" 500 2552 Searching the catalog won’t work either as when I click on a title, the page takes an unbelievable amount of time to load, then brings up the search screen as in the attached screenshot. Some help will be appreciated. Regards Chazya Sinkamba, Dip AME, BIT(c) Programmer Associate chazya.sinkamba[at]northrise.net <http://northrise.net> | m: +260 964 350 487 | p: +260 212 622 195 | f: +260 212 622 198 <http://www.northriseuniversity.com/> www.northriseuniversity.com | <http://www.northrise.org/> www.northrise.org <https://www.facebook.com/Northrise><https://twitter.com/northriseu> <https://vimeo.com/northrise> Main Campus: 30029 Kitwe-Ndola Dual Carriage Highway • P.O. Box 240271 • Ndola • Zambia Town Campus: Buteko Avenue • Caravelle House • P.O. Box 240271 • Ndola • Zambia Solwezi Campus: Mary Begg Kansanshi Mine Clinic • Mushitala • P.O. Box 110274 • Solwezi • Zambia This message is confidential. It may also be privileged or otherwise protected by work product immunity or other legal rules. If you have received it by mistake, please let us know by e-mail reply and delete it from your system; you may not copy this message or disclose its contents to anyone. The integrity and security of this message cannot be guaranteed on the Internet. -- Benjamin Shum Evergreener
Re: [OPEN-ILS-GENERAL] Some help setting up.
Thanks a lot for the response. Apache restart does not appear to help. From: Open-ils-general [mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of Dan Scott Sent: Monday, November 06, 2017 1:38 PM To: Evergreen Discussion Group <open-ils-general@list.georgialibraries.org> Subject: Re: [OPEN-ILS-GENERAL] Some help setting up. Bit of a wild guess, but Apache needs to be started or restarted *after* the opensrf services. On Nov 6, 2017 2:38 AM, "Chazya Sinkamba" <chazya.sinka...@northrise.net <mailto:chazya.sinka...@northrise.net> > wrote: Hello, So I set up an evergreen server following the instructions here: http://docs.evergreen-ils.org/2.11/ some months back and loaded sample data (concerto). I got back to work on it today, and when I use the search by database ID option, I get the internal server error on my screen. I have confirmed the ID does exist in the database. Anyone else ever experienced this, or has a remedy for it? The 3 lines below appeared in the logs at the time I was searching: Nov 6 08:52:15 ubuntu-evergreen root: 10.5.1.84 - - [06/Nov/2017:08:50:05 +0200] "GET /eg/opac/results?blimit=10;qtype=title;locg=1;fi%3Ahas_browse_entry=631%2C31 HTTP/1.1" 500 982 Nov 6 08:53:10 ubuntu-evergreen apache2[13620]: [perl:warn] [pid 13620] [client 10.5.1.84:62785 <http://10.5.1.84:62785> ] egweb: template error: undef error - Can't use an undefined value as an ARRAY reference at /usr/local/share/perl/5.22.1/OpenILS/WWW/EGCatLoader/Util.pm line 102.\n Nov 6 08:53:10 ubuntu-evergreen root: 10.5.1.84 - - [06/Nov/2017:08:52:09 +0200] "GET /eg/opac/record/100 HTTP/1.1" 500 2552 Searching the catalog won’t work either as when I click on a title, the page takes an unbelievable amount of time to load, then brings up the search screen as in the attached screenshot. Some help will be appreciated. Regards Chazya Sinkamba, Dip AME, BIT(c) Programmer Associate chazya.sinkamba[at]northrise.net <http://northrise.net> | m: +260 964 350 487 | p: +260 212 622 195 | f: +260 212 622 198 <http://www.northriseuniversity.com/> www.northriseuniversity.com | <http://www.northrise.org/> www.northrise.org <https://www.facebook.com/Northrise><https://twitter.com/northriseu> <https://vimeo.com/northrise> Main Campus: 30029 Kitwe-Ndola Dual Carriage Highway • P.O. Box 240271 • Ndola • Zambia Town Campus: Buteko Avenue • Caravelle House • P.O. Box 240271 • Ndola • Zambia Solwezi Campus: Mary Begg Kansanshi Mine Clinic • Mushitala • P.O. Box 110274 • Solwezi • Zambia This message is confidential. It may also be privileged or otherwise protected by work product immunity or other legal rules. If you have received it by mistake, please let us know by e-mail reply and delete it from your system; you may not copy this message or disclose its contents to anyone. The integrity and security of this message cannot be guaranteed on the Internet.
[OPEN-ILS-GENERAL] Some help setting up.
Hello, So I set up an evergreen server following the instructions here: http://docs.evergreen-ils.org/2.11/ some months back and loaded sample data (concerto). I got back to work on it today, and when I use the search by database ID option, I get the internal server error on my screen. I have confirmed the ID does exist in the database. Anyone else ever experienced this, or has a remedy for it? The 3 lines below appeared in the logs at the time I was searching: Nov 6 08:52:15 ubuntu-evergreen root: 10.5.1.84 - - [06/Nov/2017:08:50:05 +0200] "GET /eg/opac/results?blimit=10;qtype=title;locg=1;fi%3Ahas_browse_entry=631%2C31 HTTP/1.1" 500 982 Nov 6 08:53:10 ubuntu-evergreen apache2[13620]: [perl:warn] [pid 13620] [client 10.5.1.84:62785] egweb: template error: undef error - Can't use an undefined value as an ARRAY reference at /usr/local/share/perl/5.22.1/OpenILS/WWW/EGCatLoader/Util.pm line 102.\n Nov 6 08:53:10 ubuntu-evergreen root: 10.5.1.84 - - [06/Nov/2017:08:52:09 +0200] "GET /eg/opac/record/100 HTTP/1.1" 500 2552 Searching the catalog won't work either as when I click on a title, the page takes an unbelievable amount of time to load, then brings up the search screen as in the attached screenshot. Some help will be appreciated. Regards Chazya Sinkamba, Dip AME, BIT(c) Programmer Associate chazya.sinkamba[at]northrise.net | m: +260 964 350 487 | p: +260 212 622 195 | f: +260 212 622 198 <http://www.northriseuniversity.com/> www.northriseuniversity.com | <http://www.northrise.org/> www.northrise.org <https://www.facebook.com/Northrise><https://twitter.com/northriseu> <https://vimeo.com/northrise> Main Campus: 30029 Kitwe-Ndola Dual Carriage Highway . P.O. Box 240271 . Ndola . Zambia Town Campus: Buteko Avenue . Caravelle House . P.O. Box 240271 . Ndola . Zambia Solwezi Campus: Mary Begg Kansanshi Mine Clinic . Mushitala . P.O. Box 110274 . Solwezi . Zambia This message is confidential. It may also be privileged or otherwise protected by work product immunity or other legal rules. If you have received it by mistake, please let us know by e-mail reply and delete it from your system; you may not copy this message or disclose its contents to anyone. The integrity and security of this message cannot be guaranteed on the Internet.
Re: [OPEN-ILS-GENERAL] Migration from Destiny ils
Thank you for the response. How did you handle the migration of transnational data? @Katie. This is my first interaction with Linux, Postgresql and Evergreen, so please bear with me if I ask questions that appear too elementary. On 8/31/17, Katie Greenleaf Martin <b...@blaircountylibraries.org> wrote: > Hello Chazya--7 of my libraries migrated from Destiny to Evergreen in 2016. > Equinox handled most of the Evergreen side of the migration but if you have > any specific questions I'd be happy to try to help :) > Katie > > On Thu, Aug 31, 2017 at 8:59 AM, Rogan Hamby <rha...@equinoxinitiative.org> > wrote: > >> Hi Chazya, >> >> Destiny isn't a particularly difficult ILS to migrate to Evergreen from. >> If you have the option I do recommend using their XML data sources rather >> than reports if you have them, simply avoid a few issues that you >> otherwise >> have to correct for later. >> >> >> >> >> Rogan Hamby >> >> Data and Project Analyst >> >> Equinox Open Library Initiative >> >> phone: 1-877-OPEN-ILS (673-6457) >> >> email: ro...@equinoxinitiative.org >> web: http://EquinoxInitiative.org >> >> On Thu, Aug 31, 2017 at 8:14 AM, Chazya Sinkamba < >> chazya.sinka...@northrise.net> wrote: >> >>> Greetings, >>> Has anyone on this forum ever migrated from Destiny to Evergreen? >>> Would like to know >>> how you went about it. >>> Thanks >>> >> >> >> > > > -- > Katie Greenleaf Martin, MLIS > b...@blaircountylibraries.org > 814.946.0417x132 > County Coordinator > Blair County Library System >
[OPEN-ILS-GENERAL] Migration from Destiny ils
Greetings, Has anyone on this forum ever migrated from Destiny to Evergreen? Would like to know how you went about it. Thanks
Re: [OPEN-ILS-GENERAL] Catalogue not loading as expected
So I just noticed the same is happening in the staff client. The apache2 log is still empty, but the syslog came back with some lines added to it: --- Jun 14 16:25:40 ubuntu-evergreen root: 10.5.1.84 - - [14/Jun/2017:16:24:40 +0200] "POST /osrf-gateway-v1 HTTP/1.1" 200 495 Jun 14 16:25:41 ubuntu-evergreen apache2[3157]: [core:info] [pid 3157] [client 10.5.1.84:60685] AH00128: File does not exist: /openils/var/web/xul/rel_2_11_3/server/skin/custom.js Jun 14 16:25:41 ubuntu-evergreen root: 10.5.1.84 - - [14/Jun/2017:16:25:41 +0200] "GET /xul/rel_2_11_3/server/skin/custom.js HTTP/1.1" 404 576 Jun 14 16:25:41 ubuntu-evergreen apache2[3157]: [core:info] [pid 3157] [client 10.5.1.84:60685] AH00128: File does not exist: /openils/var/web/xul/rel_2_11_3/server/locale/en-US/auth_custom.properties Jun 14 16:25:41 ubuntu-evergreen root: 10.5.1.84 - - [14/Jun/2017:16:25:41 +0200] "GET /xul/rel_2_11_3/server/locale/en-US/auth_custom.properties HTTP/1.1" 404 597 Jun 14 16:25:41 ubuntu-evergreen apache2[3157]: [core:info] [pid 3157] [client 10.5.1.84:60685] AH00128: File does not exist: /openils/var/web/xul/rel_2_11_3/server/locale/en-US/offline_custom.properties Jun 14 16:25:41 ubuntu-evergreen root: 10.5.1.84 - - [14/Jun/2017:16:25:41 +0200] "GET /xul/rel_2_11_3/server/locale/en-US/offline_custom.properties HTTP/1.1" 404 600 Jun 14 16:25:41 ubuntu-evergreen apache2[3157]: [core:info] [pid 3157] [client 10.5.1.84:60685] AH00128: File does not exist: /openils/var/web/xul/rel_2_11_3/server/locale/en-US/common_custom.properties Jun 14 16:25:41 ubuntu-evergreen root: 10.5.1.84 - - [14/Jun/2017:16:25:41 +0200] "GET /xul/rel_2_11_3/server/locale/en-US/common_custom.properties HTTP/1.1" 404 599 Jun 14 16:25:42 ubuntu-evergreen apache2[3157]: [ssl:info] [pid 3157] (70007)The timeout specified has expired: [client 10.5.1.84:60685] AH01991: SSL input filter read failed. Jun 14 16:26:28 ubuntu-evergreen root: 10.5.1.84 - - [14/Jun/2017:16:25:18 +0200] "GET /eg/opac/results?query=Trying+to+add+titles+to+evergreen%3A+This+is+like+my+45th+test+=title%3Asearch_format==1_record_view=0=0 HTTP/1.1" 200 18067 Jun 14 16:26:41 ubuntu-evergreen apache2[3166]: [perl:warn] [pid 3166] [client 10.5.1.84:60680] egweb: template error: undef error - Can't use an undefined value as an ARRAY reference at /usr/local/share/perl/5.22.1/OpenILS/Application/AppUtils.pm line 1303.\n, referer: http://10.5.1.19/eg/opac/advanced?qtype=title;fi%3Asearch_format=book;locg=1;detail_record_view=0 Jun 14 16:26:41 ubuntu-evergreen root: 10.5.1.84 - - [14/Jun/2017:16:24:28 +0200] "GET /eg/opac/results?bool=and=title=contains=Trying+to+add+titles=and=title=contains==and=author=contains=&_adv=1_record_view=0=1=is=== HTTP/1.1" 500 798 --- Let me check the file in question. -Original Message- From: Open-ils-general [mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of Jason Stephenson Sent: Wednesday, June 14, 2017 4:00 PM To: open-ils-general@list.georgialibraries.org Subject: Re: [OPEN-ILS-GENERAL] Catalogue not loading as expected Chazya, I notice that is a browse search. Can you do a normal search from the main page? It may just be something with the browse, or you may get some more useful information from a regular search. Jason On 06/14/2017 09:48 AM, Chazya Sinkamba wrote: > The next line starts talking about something else entirely. Apache2 error log > has no entries in it. That is the first place I checked. > Thanks for the response Jason. > > -Original Message- > From: Open-ils-general > [mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf > Of Jason Stephenson > Sent: Wednesday, June 14, 2017 3:14 PM > To: open-ils-general@list.georgialibraries.org > Subject: Re: [OPEN-ILS-GENERAL] Catalogue not loading as expected > > Chazya, > > Ok. There is no error message on that line, though that does have a 500 > status. > > Does the next line have more information? Is that from syslog or the > apache2 error.log? If that's from syslog or the access log, try looking in > the error log for apache2. > > Hope that helps, > Jason > > On 06/14/2017 06:45 AM, Chazya Sinkamba wrote: >> Hi, >> Thank you for the response. I checked the error log, and the error >> that came up after clicking on a link that was supposed to give me >> titles authored by 'chazya'(an author I made up to test the system), >> is as below; >> >> - >> - >> -- >> -- >> J
Re: [OPEN-ILS-GENERAL] Catalogue not loading as expected
The next line starts talking about something else entirely. Apache2 error log has no entries in it. That is the first place I checked. Thanks for the response Jason. -Original Message- From: Open-ils-general [mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of Jason Stephenson Sent: Wednesday, June 14, 2017 3:14 PM To: open-ils-general@list.georgialibraries.org Subject: Re: [OPEN-ILS-GENERAL] Catalogue not loading as expected Chazya, Ok. There is no error message on that line, though that does have a 500 status. Does the next line have more information? Is that from syslog or the apache2 error.log? If that's from syslog or the access log, try looking in the error log for apache2. Hope that helps, Jason On 06/14/2017 06:45 AM, Chazya Sinkamba wrote: > Hi, > Thank you for the response. I checked the error log, and the error > that came up after clicking on a link that was supposed to give me > titles authored by 'chazya'(an author I made up to test the system), > is as below; > > -- > -- > -- > Jun 14 12:37:02 ubuntu-evergreen root: 10.5.1.84 - - > [14/Jun/2017:12:34:51 > +0200] "GET > /eg/opac/results?blimit=10;qtype=author;bterm=Chazya;locg=1;fi%3Ahas_b > rowse_ > entry=1526%2C8 HTTP/1.1" 500 798 > -- > -- > --- > > Tried going to google with it, no joy there. > > -Original Message- > From: Open-ils-general > [mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf > Of Jason Stephenson > Sent: Tuesday, June 13, 2017 4:33 PM > To: open-ils-general@list.georgialibraries.org > Subject: Re: [OPEN-ILS-GENERAL] Catalogue not loading as expected > > Chazya, > > I haven't seen something like that for a long time, so I don't know > off the top of my head what might cause it. It could be a number of things. > > Since you got an internal server error, there should be log messages > from Apache, the web server, that will provide some clue as to what happened. > > Depending on your configuration, you can look in > /var/log/apache2/error.log or /var/log/syslog for the messages from Apache. > > Errors should be relatively obvious, but look for lines with a 500 in > a field by itself. That is the typical number for an internal server error. > That line should indicate when the error happened, and what caused it. > > If you can find that and share it, someone can probably tell you where > else to start looking. > > Good luck, > Jason > > On 06/13/2017 08:15 AM, Chazya Sinkamba wrote: >> Hi all, >> >> New to evergreen, just finished populating the data after initial >> installation. To confirm the data has been loaded, I searched for a >> title, and got the results as desired. Clicking on the title however >> resulted in the page loading for ages, and eventually giving me an >> internal server error. Has anyone else experienced this? Any idea >> what I did wrong? >> >> Thanks >> >> >> >> Chazya Sinkamba >> >
Re: [OPEN-ILS-GENERAL] Catalogue not loading as expected
Hi, Thank you for the response. I checked the error log, and the error that came up after clicking on a link that was supposed to give me titles authored by 'chazya'(an author I made up to test the system), is as below; -- Jun 14 12:37:02 ubuntu-evergreen root: 10.5.1.84 - - [14/Jun/2017:12:34:51 +0200] "GET /eg/opac/results?blimit=10;qtype=author;bterm=Chazya;locg=1;fi%3Ahas_browse_ entry=1526%2C8 HTTP/1.1" 500 798 --- Tried going to google with it, no joy there. -Original Message- From: Open-ils-general [mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of Jason Stephenson Sent: Tuesday, June 13, 2017 4:33 PM To: open-ils-general@list.georgialibraries.org Subject: Re: [OPEN-ILS-GENERAL] Catalogue not loading as expected Chazya, I haven't seen something like that for a long time, so I don't know off the top of my head what might cause it. It could be a number of things. Since you got an internal server error, there should be log messages from Apache, the web server, that will provide some clue as to what happened. Depending on your configuration, you can look in /var/log/apache2/error.log or /var/log/syslog for the messages from Apache. Errors should be relatively obvious, but look for lines with a 500 in a field by itself. That is the typical number for an internal server error. That line should indicate when the error happened, and what caused it. If you can find that and share it, someone can probably tell you where else to start looking. Good luck, Jason On 06/13/2017 08:15 AM, Chazya Sinkamba wrote: > Hi all, > > New to evergreen, just finished populating the data after initial > installation. To confirm the data has been loaded, I searched for a > title, and got the results as desired. Clicking on the title however > resulted in the page loading for ages, and eventually giving me an > internal server error. Has anyone else experienced this? Any idea what > I did wrong? > > Thanks > > > > Chazya Sinkamba >