Home → Installation and System Configuration →

Issues after upgrade from 7.6 to 7.14.1 using WAR file update method.

• Edit

emumpton

29 May, 2015 05:01 PM

Hello,
upgraded from 7.6 to 7.14.1 using WAR file method. Included installing JAVA 8 JRE and new Oracle drivers as specified in upgrade notes.

started up; was able to login in to application and perform normal actions.

Looked at report for assets with no owner (large number reported); then went on to other things

Started seeing ERRORs in cascade.log of the type RelationshipManagementServiceWorkerImpl :

2015-05-29 10:35:53,044 ERROR [RelationshipManagementServiceWorkerImpl] Error updating relationships for entity com.hannonhill.cascade.model.dom.Page@658ee885[type=page,id=e349011d80e612703d6f3621dddeb416,path=AS-space/physics/undergraduate/Spring2015TA-schedules]: IOException occurred reading textorg.hibernate.HibernateException: IOException occurred reading text
2015-05-29 10:35:53,046 ERROR [JDBCTransaction] JDBC commit failed
2015-05-29 10:35:53,050 ERROR [RelationshipManagementServiceImpl] An error occurred when creating relations for entity [id=e349011d80e612703d6f3621dddeb416, type=page]
2015-05-29 10:35:53,055 ERROR [JDBCExceptionReporter] Protocol violation: [ 54, ]
2015-05-29 10:35:53,104 ERROR [JDBCTransaction] JDBC rollback failed
2015-05-29 10:35:53,108 ERROR [TransactionInterceptor] Application exception overridden by rollback exception

with JDBC and SQL related errors being reported.

Then more ERRORs of a similar type:

2015-05-29 10:53:00,505 ERROR [RelationshipManagementServiceImpl] An error occurred when creating relations for entity [id=901c4fde80e612700057240eb5c5b9d2, type=block]

The application was hard to shutdown gracefully and I finally had to kill it. I then restarted the application and it seemed to run normally again. After a few minutes all actions were responded to with an error message and no pages would display.

System Information is:

General Information: Syracuse University (development/test instance)

System Time May 29, 2015 12:50:52 PM EDT
Total Memory    1724 MB
Free Memory 1203 MB
Used Memory 520 MB
License Version 1.2
License Start Date  December 10, 2014 7:00:00 PM EST
License End Date    January 16, 2016 7:00:00 PM EST
License Hosts   cms-dev.syr.edu
License Duration (days) 402
Concurrent Users Allowed    Unlimited
Named Users Allowed Unlimited
Java Version    1.8.0_45
Java Vendor Oracle Corporation
JVM Version 1.8
JVM Vendor  Oracle Corporation
JVM Implementation  25.45-b02
Java Runtime    Java Platform API Specification
Java VM Java HotSpot(TM) 64-Bit Server VM
User Name   cascade
Operating System    Linux
OS Architecture amd64
OS Version  2.6.32-431.20.5.el6.x86_64
Database Name   Oracle
Database Version    Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options
JDBC Driver Name    Oracle JDBC driver
JDBC Driver Version 12.1.0.1.0

This is our DEV environment which is loaded with a copy of our PROD data and being used to test out the upgrade to 7.14.1.
Our database server is running Oracle 11g.

Thank you for your assistance.
Eric Mumpton
[email blocked]
Syracuse University

• cascade.log.zip 3.87 MB
• catalina.out.zip 1.16 MB

1. 1 Posted by emumpton on 29 May, 2015 05:12 PM

   

   After a restart it seems I can get to pages and sites like normal; then I hit some page that produces an error :

   Error
   
   May 29, 2015 1:10 PM
   An error occurred while the page was loading.: org.springframework.transaction.TransactionSystemException: Could not roll back Hibernate transaction; nested exception is org.hibernate.TransactionException: JDBC rollback failed
   
   You may choose to retry the operation. If the problem persists, please contact a system administrator.
   

   After this nothing will work until an application restart.

   • Edit

2. Support Staff 2 Posted by Tim on 29 May, 2015 05:25 PM

   

   Hi Eric,

   Thanks for providing this information. I'm looking through it now and hope to have an update for you soon.

   • Edit

3. Support Staff 3 Posted by Tim on 29 May, 2015 05:44 PM

   

   Eric,

   When you have a moment, can you do the following:

   • Stop your Cascade instance
   • Delete the tomcat/work folder
   • Replace your Oracle driver with the one I've attached here (it is driver v12.1.0.2 as opposed to 12.1.0.1)
   • Start Cascade

   Let me know if that resolve any of the issues you are seeing. If not, I can continue investigating over here.

   Thanks

   • ojdbc7_g.jar 5.6 MB
   • Edit

4. 4 Posted by emumpton on 29 May, 2015 06:36 PM

   

   Wow!! You da' man, Tim!
   I followed your advice and after 15 minutes of poking around in the app No Problems.
   I have even worked with a page Asset which was consistently causing the application collapse.

   The Oracle driver was suspect and I had it in my head to grab a copy of the zip installer and rip the driver out of that to compare. But now I don't have to do that.

   We look good at this time. I will work in the DEV instance some more today, including running an Index Rebuild and see how it goes. If all is well I will repeat the upgrade (again in a test environment) on Monday and hand it over to users to test and look over for a bit before upgrading Prod.

   Thank you for the blazingly rapid solution.

   -Eric

   • Edit

5. Support Staff 5 Posted by Tim on 29 May, 2015 07:08 PM

   

   That's great news, Eric! Thanks for reporting back. Given the results you had with this new driver, I've filed an issue internally for us to update the driver we ship to use this one here. It's unfortunate that it appears they released this updated version just after our Cascade 7.14 release :/

   Anyhow, I would expect for us to release a patch soon containing the new driver for Oracle and if anyone else runs into this problem in the meantime, we'll have them replace the driver manually.

   Let me know how your continued testing goes!

   • Edit

6. Tim closed this discussion on 17 Jun, 2015 02:32 PM.