0 Replies Latest reply on Sep 25, 2018 4:14 PM by Sreecharan Challagundla

    DDL Triggering every time, JVM starts - ORA-01031: insufficient privileges

    Sreecharan Challagundla Newbie

      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