Reviews cannot be created due to ConstraintViolationException

Still need help?

The Atlassian Community is here for you.

Ask the community

Problem

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(SQLExceptionTypeDelegate.java:74) [hibernate-core-4.2.13.Final.jar:4.2.13.Final]
...
Caused by: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (CRUCIBLE.SYS_C0054150) violated

Cause

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

Resolution

Stop the non-production Fisheye/Crucible server.

Last modified on Jul 31, 2018

Was this helpful?

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