Cannot Start Registry Due To Error: no current activation was found in the local

Products

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

Issue/Introduction

Migrating from 9.1 to 10.1, The enterprise dashboard successfully installed, but the registry cannot be started because license cannot be verified. But this license was valid


2018-07-05 20:17:49,822Z (15:17) [main] ERROR System.err                     - The Enterprise Dashboard Server at 'http://ABC.104: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.

The registry logs shows. 

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

Customer dropped the 9.1 Registry database and used the same Schema for 10.1, but it looks like some of the constraints and indexes still remain on the Oracle DB 

Environment

DevTest 10.1 and up

Resolution

Create new Schemas for Registry database , 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.