ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.
Cannot Start DevTest Registry Due To Error: ORA-00955- no current activation was found in the local
Article ID: 105889
Updated On:
Products
CA Application Test
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)
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.
Feedback
Yes
No
Powered by
