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

Details

    • Bug
    • Resolution: Not a Bug
    • 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.

    Description

      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.

      Attachments

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved: