Uploaded image for project: 'Red Hat Process Automation Manager'
  1. Red Hat Process Automation Manager
  2. RHPAM-1270

Error when RHPAM is configured with an Oracle database

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Not a Bug
    • Icon: Major Major
    • 7.1.0.GA
    • 7.1.0.GA
    • Configuration
      • RHPAM 7.1
      • Oracle as a database;
    • Hide
      • Install RHPAM 7 (business-central + kie server on the same machine) and configure it to use Oracle database;
      • Start the server and confirm that no errors is logged in the server.log file;
      • Stop the server and start it again;
      • Check the server.log file and confirm that ORA errors are logged.
      Show
      Install RHPAM 7 (business-central + kie server on the same machine) and configure it to use Oracle database; Start the server and confirm that no errors is logged in the server.log file; Stop the server and start it again; Check the server.log file and confirm that ORA errors are logged.

      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.

              mnovotny@redhat.com Marek Novotny
              rhn-support-bkramer1 Biljana Kramer
              Martin Cimbalek Martin Cimbalek (Inactive)
              Martin Cimbalek Martin Cimbalek (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              8 Start watching this issue

                Created:
                Updated:
                Resolved: