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

Products

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

Issue/Introduction

Trying to install DevTest 10.1. The enterprise dashboard successfully installed, but the registry cannot be started.  We are 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.

We were 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 constrains that still remained in the existing database. 


 

Environment

All supported DevTest Environments

Resolution

Create a clean Schemas for Registry database or if you are using an existing database make sure all tables are dropped and no constrains 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.