You are currently reviewing an older revision of this page.

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). Negative consequence, if any, is that it may take a fraction of a second longer for oracle to determine that the sequence.nextval is in order across the cluster instead of just grabbing it from that node's sequence cache, when trying to create or update a web api object. Web api objects are not created by end users. They are created by designers when designing an application or when importing an application that contains web api objects.

 

Action

undesirable side effects. If there is at least one valid action that doesn’t cause undesirable side effects, all other actions with negative side effects should go in the Workaround section.

 

Affected Versions 

  • This article applies to all versions of Appian.