[Oracle] An error ORA-0001 occurs after updating to a new version

Issue Symptoms

 

When starting Tomcat after an update on Oracle, you get the following error:

ORA-00001: unique constraint (IOBEYA.PK_QRTZ_SCHEDULER_HISTORY) violated 

 

Solution

 

The sequences in the Oracle database must be regenerated and repositioned properly

  1. Shutdown the server
  2. Launch the sync-sequences.sql script in your database
  3. Start the server

Support
If you require assistance to resolve the problem, please ask for support. (See Requesting Support)

Setup & maintenance
Views: 21