You are currently reviewing an older revision of this page.
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
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.
Apply the latest hotfix to your Appian installation.
This article applies to all versions of Appian.