Hi,
I am trying to point external Oracle DB blank schema from Devtest 10.3 but the registry is not getting started and getting below error.
Devtest Version : 10.3
Oracle Version : Oracle 12c Enterprise Edition Release 12.2.0.1.0 – 64 bit
2019-09-18 13:02:43,512Z (06:02) [main] ERROR System.err - [DevTest AGENT:C][ERROR][13054][1][main][Sep 18, 2019 6:02:43 AM] Unable to get schema version from the database
2019-09-18 13:02:43,527Z (06:02) [main] ERROR System.err - [DevTest AGENT:C][ERROR][13054][1][main][Sep 18, 2019 6:02:43 AM] Schema upgrade failed: java.sql.SQLException
2019-09-18 13:02:43,538Z (06:02) [main] ERROR System.err - [DevTest AGENT:C][ERROR][13054][1][main][Sep 18, 2019 6:02:43 AM] DB error for jdbc:oracle:thin:@isvtp1.unix.gsm1900.org:4684:isvtp1... No transactions will be saved there
2019-09-18 13:02:43,544Z (06:02) [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-09-18 13:02:43,548Z (06:02) [main] INFO System.out - Unexpected Exception: java.sql.SQLException: Schema upgrade failed
2019-09-18 13:02:43,551Z (06:02) [Thread-9] INFO com.itko.lisa.net.ActiveMQFactory - Closing AMQ connections
------------------------------
Thanks,
Varun Chand
------------------------------