Cannot Start DevTest Registry Due To Error: ORA-00955- no current activation was found in the local

Products

• CA Application Test
• CA Continuous Application Insight (PathFinder)
• Service Virtualization

Issue/Introduction

Recently did an upgrade using existing databases. The Enterprise Dashboard successfully installed, but the Registry cannot be started.  Seeing the below error in Registry logs.

2018-07-05 20:17:49,822Z (15:17) [main] ERROR System.err                     -
2018-07-05 20:17:49,822Z (15:17) [main] ERROR System.err                     - The Enterprise Dashboard Server at 'http://<EDhost>:1506'
2018-07-05 20:17:49,822Z (15:17) [main] ERROR System.err                     - could not be contacted, and no current activation was found in the local
2018-07-05 20:17:49,822Z (15:17) [main] ERROR System.err                     - activation cache for this registry.
2018-07-05 20:17:49,829Z (15:17) [main] ERROR System.err                     -
2018-07-05 20:17:49,829Z (15:17) [main] ERROR System.err                     - This registry will not be allowed to start until it can be activated by a
2018-07-05 20:17:49,829Z (15:17) [main] ERROR System.err                     - valid Enterprise Dashboard Server.

Also seeing database related errors in the Registry logs.

com.mchange.v2.c3p0.impl.NewPooledConnection - [email protected] handling a throwable.
java.sql.SQLSyntaxErrorException: ORA-00955: name is already used by an existing object
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1059)

Cause

The error is because the table already exists in the database. There might be some constraints that still remained in the existing database. 


 

Environment

All supported DevTest releases.

Resolution

Created clean Schema for Registry database or if using an existing database make sure all tables are dropped and no constraints remain.  

Ensure that the character set of the Oracle database supports Unicode.

In addition, for the initial creation of the database, the Oracle user must have the CREATE VIEW system privilege. Without this privilege, the following error might be generated during installation: Schema creation failed: ORA-01031: insufficient privileges.