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