Registry not starting: Schema upgrade failed
Article ID: 126449
Updated On:
Products
Issue/Introduction
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:@<servername>.be.example.com: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
All supported DevTest releases.
Cause
Configured external Oracle DB in site.properties but didn't turned off Derby.
Also, the DB User configured in site.properties should have full permissions to create the tables first time when Registry is started, it did not.
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 turned off Derby with the below property:
lisadb.internal.enabled=false
Additional Information
Refer to section "Configure DevTest to Use Oracle" in the documentation of the DevTest release you are running.
Feedback
