You are currently reviewing an older revision of this page.

[DRAFT ]INT-XXXX Unique constraint upon importing/saving a WebAPI

Symptoms

When attempting to import a package that contains a WebAPI or saving a WebAPI, the following error is produced intermittently

 org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update;

 org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update;
 ERROR org.hibernate.util.JDBCExceptionReporter - ORA-00001: unique constraint (APPIANJ_PRIMARY.TEST_DATA_UC) violated 

Cause

The error is generally produced when using Oracle Real Application Clusters (RAC). As Oracle RAC has a node sequence cache, which the sequence.nextval uses to determine the node, the fix guarantees to return the next value of the sequence in order across the RAC cluster, not just for that particular RAC cluster node's sequence cache.

Action

Apply the latest hotfix to your Appian installation.

Affected Versions 

This article applies to all versions of Appian.