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.
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.