org.apache.ddlutils.DatabaseOperationException

Error while executing SQL ALTER TABLE PROCESS DROP CONSTRAINT PROCESS_FK_CURRENTACTIVITYID_ACTIVITYDEFINITION

Samebug tips0

We couldn't find tips for this exception.

Don't give up yet. Paste your full stack trace to get a solution.

Solutions on the web408

  • via Unknown by Unknown author,
  • Stack trace

    • org.apache.ddlutils.DatabaseOperationException: Error while executing SQL ALTER TABLE PROCESS DROP CONSTRAINT PROCESS_FK_CURRENTACTIVITYID_ACTIVITYDEFINITION at org.apache.ddlutils.platform.PlatformImplBase.evaluateBatch(PlatformImplBase.java:344) at org.apache.ddlutils.platform.PlatformImplBase.evaluateBatch(PlatformImplBase.java:279) at com.ericsson.cas.db.dbunit.DbLoader.executeDataXMLOperation(DbLoader.java:134) at com.ericsson.cas.componenttest.dbinitializer.PerCaseDbInitializerSpringImpl.initPerCaseDb(PerCaseDbInitializerSpringImpl.java:45) at com.ericsson.cas.functest.core.db.DbInitalizer.initPerCaseDb(DbInitalizer.java:57) at com.ericsson.cas.functest.core.CasSystemTest.initDb(CasSystemTest.java:90) at com.ericsson.cas.functest.core.CasSystemTest.init(CasSystemTest.java:74) at com.ericsson.cas.inttest.awm.RemoteUserResetPasswordListPresenterIT.init(RemoteUserResetPasswordListPresenterIT.java:83) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:47) at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12) at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:44) at mockit.integration.junit4.internal.JUnit4TestRunnerDecorator.invokeExplosively(JUnit4TestRunnerDecorator.java:44) at mockit.integration.junit4.internal.MockFrameworkMethod.invokeExplosively(MockFrameworkMethod.java:37) at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java) at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:24) at org.springframework.test.context.junit4.statements.RunBeforeTestMethodCallbacks.evaluate(RunBeforeTestMethodCallbacks.java:75) at org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:27) at org.springframework.test.context.junit4.statements.RunAfterTestMethodCallbacks.evaluate(RunAfterTestMethodCallbacks.java:86) at org.junit.internal.runners.statements.FailOnTimeout$StatementThread.run(FailOnTimeout.java:74) Caused by: java.sql.SQLIntegrityConstraintViolationException: integrity constraint violation: unique constraint or index violation; SYS_PK_11827 table: PROCESS in statement [ALTER TABLE PROCESS DROP CONSTRAINT PROCESS_FK_CURRENTACTIVITYID_ACTIVITYDEFINITION] at org.hsqldb.jdbc.JDBCUtil.sqlException(JDBCUtil.java:324) at org.hsqldb.jdbc.JDBCUtil.sqlException(JDBCUtil.java:247) at org.hsqldb.jdbc.JDBCStatement.fetchResult(JDBCStatement.java:1797) at org.hsqldb.jdbc.JDBCStatement.executeUpdate(JDBCStatement.java:208) at org.apache.ddlutils.platform.PlatformImplBase.evaluateBatch(PlatformImplBase.java:323) ... 22 more Caused by: org.hsqldb.HsqlException: integrity constraint violation: unique constraint or index violation; SYS_PK_11827 table: PROCESS at org.hsqldb.error.Error.error(Error.java:137) at org.hsqldb.Constraint.getException(Constraint.java:883) at org.hsqldb.index.IndexAVLMemory.insert(IndexAVLMemory.java:233) at org.hsqldb.persist.RowStoreAVL.indexRow(RowStoreAVL.java:241) at org.hsqldb.persist.RowStoreAVL.moveData(RowStoreAVL.java:564) at org.hsqldb.TableWorks.moveData(TableWorks.java:1382) at org.hsqldb.TableWorks.dropConstraint(TableWorks.java:1030) at org.hsqldb.SchemaManager.dropConstraint(SchemaManager.java:1525) at org.hsqldb.StatementSchema.getResult(StatementSchema.java:888) at org.hsqldb.StatementSchema.execute(StatementSchema.java:274) at org.hsqldb.Session.executeCompiledStatement(Session.java:1384) at org.hsqldb.Session.executeDirectStatement(Session.java:1259) at org.hsqldb.Session.execute(Session.java:1024) at org.hsqldb.jdbc.JDBCStatement.fetchResult(JDBCStatement.java:1789) ... 24 more

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    marcbouvierdavmarcbouvierdav
    5 times, last one
    AxeloAxelo
    2 times, last one
    Unknown visitor
    Unknown visitorOnce,
    Unknown UserUnknown User
    2 times, last one
    ivanszkypeterivanszkypeter
    24 times, last one
    92 more bugmates