Hello Team,

Env : JBossEAP v7.1.1, JBPM v7.0.2GA, Oracle12

We using JBPM v7.0.2, built DB on Oracle 12c. when trying to start JVM.. getting below exception.

Our concern is when DBA ran DDL on DB schema... is there any setting we need to use to stop running script again and again.

FYI..

WARN  [org.hibernate.tool.schema.internal.ExceptionHandlerLoggedImpl] (ServerService Thread Pool -- 70) GenerationTarget encountered exception accepting command : Error executing DDL via JDBC Statement: org.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing DDL via JDBC Statement

        at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:67)

        at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applySqlString(AbstractSchemaMigrator.java:524)

        at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applySqlStrings(AbstractSchemaMigrator.java:470)

        at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applyForeignKeys(AbstractSchemaMigrator.java:429)

        at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.performMigration(AbstractSchemaMigrator.java:245)

        at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.doMigration(AbstractSchemaMigrator.java:110)

        at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.performDatabaseAction(SchemaManagementToolCoordinator.java:176)

        at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.process(SchemaManagementToolCoordinator.java:65)

        at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:476)

        at org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:422)

        at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:880)

        at org.hibernate.jpa.HibernatePersistenceProvider.createContainerEntityManagerFactory(HibernatePersistenceProvider.java:135)

        at org.kie.server.services.jbpm.JbpmKieServerExtension.build(JbpmKieServerExtension.java:720)

        at org.kie.server.services.jbpm.JbpmKieServerExtension.configureServices(JbpmKieServerExtension.java:217)

        at org.kie.server.services.jbpm.JbpmKieServerExtension.init(JbpmKieServerExtension.java:179)

        at org.kie.server.services.impl.KieServerImpl.init(KieServerImpl.java:126)

        at org.kie.server.services.impl.KieServerLocator.<clinit>(KieServerLocator.java:23)

        at org.kie.server.services.Bootstrap.contextInitialized(Bootstrap.java:51)

        at io.undertow.servlet.core.ApplicationListeners.contextInitialized(ApplicationListeners.java:187)

        at io.undertow.servlet.core.DeploymentManagerImpl$1.call(DeploymentManagerImpl.java:205)

        at io.undertow.servlet.core.DeploymentManagerImpl$1.call(DeploymentManagerImpl.java:174)

        at io.undertow.servlet.core.ServletRequestContextThreadSetupAction$1.call(ServletRequestContextThreadSetupAction.java:42)

        at io.undertow.servlet.core.ContextClassLoaderSetupAction$1.call(ContextClassLoaderSetupAction.java:43)

        at org.wildfly.extension.undertow.security.SecurityContextThreadSetupAction.lambda$create$0(SecurityContextThreadSetupAction.java:105)

        at org.wildfly.extension.undertow.deployment.UndertowDeploymentInfoService$UndertowThreadSetupAction.lambda$create$0(UndertowDeploymentInfoService.java:1508)

        at org.wildfly.extension.undertow.deployment.UndertowDeploymentInfoService$UndertowThreadSetupAction.lambda$create$0(UndertowDeploymentInfoService.java:1508)

        at org.wildfly.extension.undertow.deployment.UndertowDeploymentInfoService$UndertowThreadSetupAction.lambda$create$0(UndertowDeploymentInfoService.java:1508)

        at org.wildfly.extension.undertow.deployment.UndertowDeploymentInfoService$UndertowThreadSetupAction.lambda$create$0(UndertowDeploymentInfoService.java:1508)

        at io.undertow.servlet.core.DeploymentManagerImpl.deploy(DeploymentManagerImpl.java:239)

        at org.wildfly.extension.undertow.deployment.UndertowDeploymentService.startContext(UndertowDeploymentService.java:99)

        at org.wildfly.extension.undertow.deployment.UndertowDeploymentService$1.run(UndertowDeploymentService.java:81)

        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)

        at java.util.concurrent.FutureTask.run(FutureTask.java:266)

        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)

        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)

        at java.lang.Thread.run(Thread.java:748)

        at org.jboss.threads.JBossThread.run(JBossThread.java:320)

Caused by: java.sql.SQLSyntaxErrorException: ORA-01031: insufficient privileges

        at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494)

        at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446)

        at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054)

        at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623)

        at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252)

        at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612)

        at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:213)

        at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:37)

        at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:896)

        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1119)

        at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1737)

        at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1692)

        at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:300)

        at org.jboss.jca.adapters.jdbc.WrappedStatement.execute(WrappedStatement.java:198)

        at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:54)

        ... 36 more

Caused by: Error : 1031, Position : 0, Sql = alter table <Schema-Nmae>.PeopleAssignments_BAs add constraint FKt4xs0glwhbsa0xwg69r6xduv9 foreign key (task_id) references <schema>.Task, OriginalSql = alter table <Schema-Nmae>.PeopleAssignments_BAs add constraint FKt4xs0glwhbsa0xwg69r6xduv9 foreign key (task_id) references <schema>.Task, Error Msg = ORA-01031: insufficient privileges

        at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:498)

        ... 50 more