-
Bug
-
Resolution: Not a Bug
-
Major
-
7.1.0.GA
-
- RHPAM 7.1
- Oracle as a database;
When RHPAM is configured to use Oracle database, the first start up of the server will not show any error and the server will work fine. However, every subsequent restart will log errors like:
***********************************************************************
2018-06-21 11:11:28,013 WARN [org.hibernate.tool.schema.internal.ExceptionHandlerLoggedImpl] (ServerService Thread Pool – 71) 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.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)
...
Caused by: java.sql.SQLSyntaxErrorException: ORA-00955: name is already used by an existing object
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:193)
at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:1033)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1329)
at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1909)
at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1871)
at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:318)
at org.jboss.jca.adapters.jdbc.WrappedStatement.execute(WrappedStatement.java:198)
at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:54)
... 37 more
...
2018-06-21 11:11:28,558 WARN [org.hibernate.tool.schema.internal.ExceptionHandlerLoggedImpl] (ServerService Thread Pool – 71) 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.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)
...
Caused by: java.sql.SQLSyntaxErrorException: ORA-02275: such a referential constraint already exists in the table
...
***********************************************************************
However, it seems that server works fine despite the above errors.