Application Fails to Startup after Upgrading Oracle Database
Symptoms
You're running a Crowd version older than 2.4.2. Crowd fails to startup after upgrading Oracle from 10g to 11g, with the following error reported in the logs:
2010-08-18 16:00:00,409 DefaultQuartzScheduler_Worker-6 ERROR [hibernate.event.def.AbstractFlushingEventListener] Could not synchronize database state with session
org.hibernate.StaleStateException: Batch update returned unexpected row count from update [0]; actual row count: 0; expected: 1
at org.hibernate.jdbc.Expectations$BasicExpectation.checkBatched(Expectations.java:61)
at org.hibernate.jdbc.Expectations$BasicExpectation.verifyOutcome(Expectations.java:46)
at org.hibernate.jdbc.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:24)
2010-08-18 16:00:00,411 DefaultQuartzScheduler_Worker-6 ERROR [org.quartz.core.JobRunShell] Job DEFAULT.TokenReaperJob threw an unhandled Exception:
org.springframework.orm.hibernate3.HibernateOptimisticLockingFailureException: Batch update returned unexpected row count from update [0]; actual row count: 0; expected: 1; nested exception is org.hibernate.StaleStateException: Batch update returned unexpected row count from update [0]; actual row count: 0; expected: 1
Caused by: org.hibernate.StaleStateException: Batch update returned unexpected row count from update [0]; actual row count: 0; expected: 1
Cause
Oracle 11g is not a supported database for your version of Crowd. Oracle 11g support was added in version 2.4.2 and is available in 2.5 and newer versions.
Resolution
- Revert back to Oracle 10g, or upgrade to a version of Crowd that supports Oracle 11g.
Last modified on Feb 26, 2016
Powered by Confluence and Scroll Viewport.