Reviews cannot be created due to ConstraintViolationException

Still need help?

The Atlassian Community is here for you.

Ask the community


When creating a review, the following message is displayed to the user:

URL: /json/cru/createReviewDialog
An org.hibernate.exception.ConstraintViolationException was encountered
could not execute statement
ORA-00001: unique constraint (CRUCIBLE.SYS_C0054150) violated


The following appears in the atlassian-fisheye-YYYY-MM-DD.log:

WARN  [qtp1345923076-254092 ] org.hibernate.engine.jdbc.spi.SqlExceptionHelper SqlExceptionHelper-logExceptions - SQL Error: 1, SQLState: 23000
ERROR [qtp1345923076-254092 ] org.hibernate.engine.jdbc.spi.SqlExceptionHelper SqlExceptionHelper-logExceptions - ORA-00001: unique constraint (CRUCIBLE.SYS_C0054150) violated
ERROR [qtp1345923076-254092 ] fisheye SessionState-commitAllTx - Commit failed. Rolling back.
org.hibernate.exception.ConstraintViolationException: could not execute statement
	at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert( [hibernate-core-4.2.13.Final.jar:4.2.13.Final]
Caused by: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (CRUCIBLE.SYS_C0054150) violated


Two separate Fisheye/Crucible servers (e.g. a test and a production one) are connecting to the same database.

There is an existing suggestion to prevent this case from happening:  FE-6658 - Getting issue details... STATUS


Stop the non-production Fisheye/Crucible server.

Last modified on Jul 31, 2018

Was this helpful?

Provide feedback about this article
Powered by Confluence and Scroll Viewport.