Registry not starting

Document ID : KB000126449
Last Modified Date : 08/02/2019
Show Technical Document Details
Issue:
While starting the registry service after enterprise dashboard, get the following error in the fresh installation of DevTest and using external Oracle database.
----
2019-01-25 08:52:57,351Z (09:52) [main] INFO System.out - END; 2019-01-25 08:52:57,365Z (09:52) [main] ERROR System.err - [DevTest AGENT:C][ERROR][20341][1][main][25-Jan-2019 09:52:57] Schema upgrade failed: ORA-01422: exact fetch returns more than requested number of rows 2019-01-25 08:52:57,365Z (09:52) [main] ERROR System.err - ORA-06512: at line 11 2019-01-25 08:52:57,378Z (09:52) [main] ERROR System.err - [DevTest AGENT:C][ERROR][20341][1][main][25-Jan-2019 09:52:57] !!!!!!!! Pathfinder schema upgrade failed !!!!!!!! 2019-01-25 08:52:57,380Z (09:52) [main] INFO System.out - [DevTest AGENT:C][WARN][20341][1][main][25-Jan-2019 09:52:57] Please do one of the following: 2019-01-25 08:52:57,380Z (09:52) [main] INFO System.out - [DevTest AGENT:C][WARN][20341][1][main][25-Jan-2019 09:52:57] - Contact CA support to recover the schema. 2019-01-25 08:52:57,380Z (09:52) [main] INFO System.out - [DevTest AGENT:C][WARN][20341][1][main][25-Jan-2019 09:52:57] - Drop the Pathfinder tables or point to a new database and the new schema will be created automatically (or manually if you prefer via: java -jar LisaAgent.jar -ddl [dialect]) 2019-01-25 08:52:57,381Z (09:52) [main] ERROR System.err - [DevTest AGENT:C][ERROR][20341][1][main][25-Jan-2019 09:52:57] Schema upgrade failed: java.sql.SQLException 2019-01-25 08:52:57,382Z (09:52) [main] ERROR System.err - [DevTest AGENT:C][ERROR][20341][1][main][25-Jan-2019 09:52:57] DB error for jdbc:oracle:thin:@Dboccasv02c.be.fortis.bank:48952/CASV02C... No transactions will be saved there 2019-01-25 08:52:57,386Z (09:52) [main] ERROR com.itko.lisa.coordinator.TestRegistryImpl - Schema upgrade failed java.sql.SQLException: Schema upgrade failed at com.itko.lisa.remote.persist.SchemaPersister.createOrUpgradeSchemaIfNeeded(SchemaPersister.java:949) at com.itko.lisa.remote.persist.PersistManager.createSchemaIfNeeded(PersistManager.java:383) at com.itko.lisa.remote.persist.PersistManager.getSafeConnection(PersistManager.java:592) at com.itko.lisa.coordinator.TestRegistryImpl.main(TestRegistryImpl.java:2171) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at com.exe4j.runtime.LauncherEngine.launch(Unknown Source) at com.install4j.runtime.launcher.UnixLauncher.main(Unknown Source) 2019-01-25 08:52:57,387Z (09:52) [main] INFO System.out - Unexpected Exception: java.sql.SQLException: Schema upgrade failed 2019-01-25 08:52:57,391Z (09:52) [Thread-9] INFO com.itko.lisa.net.ActiveMQFactory - Closing AMQ connections 2019-01-25 08:52:57,392Z (09:52) [Thread-0] INFO System.out - java.sql.SQLException: Schema upgrade failed at com.itko.lisa.remote.persist.SchemaPersister.createOrUpgradeSchemaIfN eeded(SchemaPersister.java:949) at com.itko.lisa.remote.persist.PersistManager.createSchemaIfNeeded(Pers istManager.java:383) at com.itko.lisa.remote.persist.PersistManager.getSafeConnection(Persist Manager.java:592) at com.itko.lisa.coordinator.TestRegistryImpl.main(TestRegistryImpl.java :2171) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl. java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces sorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at com.exe4j.runtime.LauncherEngine.launch(Unknown Source) at com.install4j.runtime.launcher.UnixLauncher.main(Unknown Source)
Environment:
DevTest 10.3
Cause:
Configured external Oracle DB in site.properties but didn't turned of Derby.

Also, the DB User configured in site.properties should have full permissions to create the tables first time when Registry is started.
Resolution:
Need to configuring the below with the correct Oracle DB information in site.properties:

## ==================================================================================
## Oracle
## ==================================================================================
## lisadb.pool.common.driverClass=oracle.jdbc.driver.OracleDriver
## Select one of the two connection URLs depending on usage of SID or SERVICE
## lisadb.pool.common.url=jdbc:oracle:thin:@[HOST]:1521:[SID]
## lisadb.pool.common.url=jdbc:oracle:thin:@//[HOST][:PORT]/SERVICE
## lisadb.pool.common.user=[USER]
## lisadb.pool.common.password=[PASSWORD]
##

and also turning off Derby with the below property: 
lisadb.internal.enabled=false
Additional Information:
https://docops.ca.com/devtest-solutions/10-3/en/administering/database-administration/external-registry-database-configuration/configure-devtest-to-use-oracle