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 each occasion the following errors:

    ...
    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 (PAM) 7;
  • Oracle database;

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In
Close

Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.