[OPEN-ILS-DEV] Errors Upgrading Evergreen 2.4.4 to 2.5.4

[Jesse McCarty]

Hi,

I am going through the process of upgrading our 2.4.4 installation of Evergreen to 2.5.4. Currently running through the install on a test server (which is an exact copy of our production server as it sat several weeks ago, albeit with a different IP Address).

After upgrading OpenSRF to 2.2.2 and the Evergreen code, I started getting errors when running the update DB scripts. I started by running the 2.4.3-2.5.0-upgrade-db.sql (There was no 2.4.4-2.5.0-upgrade-db.sql) with more errors that could fit on a screen shot, then ran into additional errors on different update scripts:

For 2.4.3-2.5.0-upgrade-db.sql errors see attached 243-250Error.JPG (this also shows the reingest records script information, which I ran after running all the DB upgrade scripts).

For 2.5.0-2.5.1-upgrade-db.sql errors see attached 250-251Error.JPG

No errors where reported when running the 2.5.1-2.5.2-upgrade-db.sql script.

For 2.5.2-2.5.3-upgrade-db.sql errors see attached 252-253Error.JPG

For 2.5.3-2.5.4-upgrade-db.sql errors see attached 253-254Error.JPG

After starting Evergreen, I can connect via the web browser and login to my account with no issues, searching the catalog produces and internal server error. I can also connect to the staff client and register the workstation and test/add SSL exemption with no issues. Once the work station is registered I get a Network error (can ping the server from the workstation connecting) show in the attached StaffClientError.JPG file. If I close that error the Staff Client loads and then I can browse patrons and interact with the Server OK.

I have a snapshot of the VM I can revert to that was taken prior to any update scripts running against the DB to work through the process again for further testing if needed.

Thanks,

Jesse McCarty
City of Burlington
IT Technical Assistant

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://libmail.georgialibraries.org/pipermail/open-ils-dev/attachments/20140519/5c130ad6/attachment-0001.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: 243-250Error.JPG
Type: image/jpeg
Size: 212062 bytes
Desc: 243-250Error.JPG
URL: <http://libmail.georgialibraries.org/pipermail/open-ils-dev/attachments/20140519/5c130ad6/attachment-0005.jpeg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: 250-251Error.JPG
Type: image/jpeg
Size: 84749 bytes
Desc: 250-251Error.JPG
URL: <http://libmail.georgialibraries.org/pipermail/open-ils-dev/attachments/20140519/5c130ad6/attachment-0006.jpeg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: 252-253Error.JPG
Type: image/jpeg
Size: 83523 bytes
Desc: 252-253Error.JPG
URL: <http://libmail.georgialibraries.org/pipermail/open-ils-dev/attachments/20140519/5c130ad6/attachment-0007.jpeg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: 253-254Error.JPG
Type: image/jpeg
Size: 137130 bytes
Desc: 253-254Error.JPG
URL: <http://libmail.georgialibraries.org/pipermail/open-ils-dev/attachments/20140519/5c130ad6/attachment-0008.jpeg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: StaffClientError.JPG
Type: image/jpeg
Size: 45372 bytes
Desc: StaffClientError.JPG
URL: <http://libmail.georgialibraries.org/pipermail/open-ils-dev/attachments/20140519/5c130ad6/attachment-0009.jpeg>