When RHPAM is configured to use Oracle as a database, the first start-up will work fine but every subsequent restart will show ORA-00955 and ORA-02275 in the server.log file

Solution Unverified - Updated -

Issue

  • The connectivity of the integrated RHPAM (business-central + kie-server) is happening fine and without any issues. However, when I restart my server on next occasions the following errors occurs:

    ...
    Caused by: java.sql.SQLSyntaxErrorException: ORA-00955: name is already used by an existing object
    ...
    Caused by: java.sql.SQLSyntaxErrorException: ORA-02275: such a referential constraint already exists in the table
    
  • When RHPAM is configured to use Oracle as a database, the first start-up will work fine but every subsequent restart will show ORA-00955 and ORA-02275 in the server.log file

Environment

  • Red Hat Process Automation Manager (RHPAM)
    • 7
  • Oracle database driver
    • 12.1

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content