[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 




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

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

Setup & maintenance
Views: 17