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 associated with using Oracle Real Application Clusters (RAC) as the database for the Appian Primary Datasource.
Oracle RAC has a node sequence cache, which the sequence.nextval uses to determine the node. The associated fix for this issue guarantees that the next value of the sequence will be in order across the entire RAC cluster, not just for that particular RAC cluster node's sequence cache.
This issue has been addressed via AN-105127 in the following Appian hotfixes/versions:
Apply the latest hotfix to your Appian installation.
This article applies to Appian 18.1 and earlier.
© 2022 Appian. All rights reserved.