Service Virtualization

Hi All,

I am getting below error when trying to run Registry service. I am using DB2 database. Can anyone tell me what is the root cause.

2016-04-21 21:57:55,875Z (16:57) [main] ERROR System.err                     - [DevTest AGENT:C][ERROR][22710][1][main][Apr 21, 2016 4:57:55 PM] Unable to get schema version from the database

2016-04-21 21:57:55,876Z (16:57) [main] ERROR System.err                     - [DevTest AGENT:C][ERROR][22710][1][main][Apr 21, 2016 4:57:55 PM] DB error for jdbc:db2://***************:55000/XXXXXXX:currentSchema=***;... No transactions will be saved there

2016-04-21 21:57:55,877Z (16:57) [main] ERROR com.itko.lisa.coordinator.TestRegistryImpl - DB connection/Schema creation/upgrade failed

java.sql.SQLException: DB connection/Schema creation/upgrade failed

        at com.itko.lisa.remote.persist.PersistManager.getSafeConnection(PersistManager.java:581)

        at com.itko.lisa.coordinator.TestRegistryImpl.main(TestRegistryImpl.java:2405)

        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:497)

        at com.exe4j.runtime.LauncherEngine.launch(Unknown Source)

        at com.install4j.runtime.launcher.UnixLauncher.main(Unknown Source)

2016-04-21 21:57:55,877Z (16:57) [main] INFO  System.out                     - Unexpected Exception: java.sql.SQLException: DB connection/Schema creation/upgrade failed

2016-04-21 21:57:55,881Z (16:57) [Thread-0] INFO  System.out                     -

2016-04-21 21:57:55,882Z (16:57) [Thread-9] INFO  com.itko.lisa.net.ActiveMQFactory - Closing AMQ connections

Can you check this System Requirements - DevTest Solutions - 9.1 - CA Technologies Documentation

and verify that the version of database and the page size setting is as required?

Thanks Koustubh. As you have mentoned we checked with DBA on code page and page size. There was a DB user access permission issue on DB2 schema along with page size.

great....good to know it works now!

Koustubh.Warty For me this issue got resolved by dropping both old tables and old Views.I am not sure if this is somewhat a glitch in database update during 9.51 installation.