Service Virtualization

Expand all | Collapse all

I am facing below error while opening .tst, .vsi, .vsm files in LISA 7.5. Please suggest what may the root cause .

  • 1.  I am facing below error while opening .tst, .vsi, .vsm files in LISA 7.5. Please suggest what may the root cause .

    Posted 03-10-2016 07:36 AM

    javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.3.2.v20111125-r10461): org.eclipse.persistence.exceptions.DatabaseException

    Internal Exception: java.sql.SQLException: Connections could not be acquired from the underlying database!

    Error Code: 0

        at org.eclipse.persistence.internal.jpa.EntityManagerSetupImpl.deploy(EntityManagerSetupImpl.java:517)

        at org.eclipse.persistence.internal.jpa.EntityManagerFactoryDelegate.getDatabaseSession(EntityManagerFactoryDelegate.java:188)

        at org.eclipse.persistence.internal.jpa.EntityManagerFactoryDelegate.createEntityManagerImpl(EntityManagerFactoryDelegate.java:277)

        at org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.createEntityManagerImpl(EntityManagerFactoryImpl.java:294)

        at org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:272)

        at com.itko.lisa.utils.JpaUtil.getEm(JpaUtil.java:1240)

        at com.itko.lisa.test.data.TestDataGenerator.ensureTestDataExists(TestDataGenerator.java:269)

        at com.itko.lisa.test.data.TestDataGenerator.getBuiltinPatterns(TestDataGenerator.java:255)

        at com.itko.lisa.coordinator.TestRegistryImpl.getBuiltInPatterns(TestRegistryImpl.java:3505)

        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

        at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

        at java.lang.reflect.Method.invoke(Unknown Source)

        at com.itko.lisa.net.RemoteMethodExec.execute(RemoteMethodExec.java:57)

        at com.itko.lisa.net.ServerRequestHandler.processRMIMessage(ServerRequestHandler.java:432)

        at com.itko.lisa.net.ServerRequestHandler.access$300(ServerRequestHandler.java:67)

        at com.itko.lisa.net.ServerRequestHandler$4.run(ServerRequestHandler.java:355)

        at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)

        at java.util.concurrent.FutureTask.run(Unknown Source)

        at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)

        at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

        at java.lang.Thread.run(Unknown Source)

    Caused by: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.3.2.v20111125-r10461): org.eclipse.persistence.exceptions.DatabaseException

    Internal Exception: java.sql.SQLException: Connections could not be acquired from the underlying database!

    Error Code: 0

        at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:309)

        at org.eclipse.persistence.sessions.JNDIConnector.connect(JNDIConnector.java:135)

        at org.eclipse.persistence.sessions.DatasourceLogin.connectToDatasource(DatasourceLogin.java:162)

        at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.loginAndDetectDatasource(DatabaseSessionImpl.java:584)

        at org.eclipse.persistence.internal.jpa.EntityManagerFactoryProvider.login(EntityManagerFactoryProvider.java:206)

        at org.eclipse.persistence.internal.jpa.EntityManagerSetupImpl.deploy(EntityManagerSetupImpl.java:488)

        ... 21 more

    Caused by: java.sql.SQLException: Connections could not be acquired from the underlying database!

        at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:118)

        at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:689)

        at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:140)

        at com.itko.lisa.utils.db.LisaWrappedDataSource.getConnection(LisaWrappedDataSource.java:32)

        at org.eclipse.persistence.sessions.JNDIConnector.connect(JNDIConnector.java:123)

        ... 25 more

    Caused by: com.mchange.v2.resourcepool.CannotAcquireResourceException: A ResourcePool could not acquire a resource from its primary factory or source.

        at com.mchange.v2.resourcepool.BasicResourcePool.awaitAvailable(BasicResourcePool.java:1418)

        at com.mchange.v2.resourcepool.BasicResourcePool.prelimCheckoutResource(BasicResourcePool.java:606)

        at com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java:526)

        at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutAndMarkConnectionInUse(C3P0PooledConnectionPool.java:755)

        at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:682)

        ... 28 more



  • 2.  Re: I am facing below error while opening .tst, .vsi, .vsm files in LISA 7.5. Please suggest what may the root cause .

    Posted 03-10-2016 07:55 AM

    Is this error on a fresh install or have you been using this env for some time and just started seeing these errors?



  • 3.  Re: I am facing below error while opening .tst, .vsi, .vsm files in LISA 7.5. Please suggest what may the root cause .

    Posted 03-10-2016 07:55 AM

    Also what database is this and version?



  • 4.  Re: I am facing below error while opening .tst, .vsi, .vsm files in LISA 7.5. Please suggest what may the root cause .

    Posted 03-10-2016 08:11 AM



  • 5.  Re: I am facing below error while opening .tst, .vsi, .vsm files in LISA 7.5. Please suggest what may the root cause .

    Posted 03-10-2016 08:11 AM

    Just started seeing this error ..no clue why .



  • 6.  Re: I am facing below error while opening .tst, .vsi, .vsm files in LISA 7.5. Please suggest what may the root cause .

    Posted 03-18-2016 10:28 PM

    I believe I've seen a similar issue in the version you're using when the workstation doesn't have connectivity to the LISA database. In case the database is on a separate machine, can you verify that you're able to ping the IP of the machine where the database is installed, this may help confirm it's the same issue



  • 7.  Re: I am facing below error while opening .tst, .vsi, .vsm files in LISA 7.5. Please suggest what may the root cause .

    Posted 03-18-2016 10:32 PM

    Are you able to open the Lisa console & check the database connectivity under reports tab?

    Please provide a screenshot of the same.



  • 8.  Re: I am facing below error while opening .tst, .vsi, .vsm files in LISA 7.5. Please suggest what may the root cause .

    Posted 03-21-2016 05:40 AM

    Is this the same error that RohanDoshi described in https://communities.ca.com/message/241834467? Unless it is, please elaborate about the differences? As mentioned in the other issue, this appears to be a DB connectivity problem, which can have multiple reasons. Among those are false DB user IDs, wrong password, host names that cannot be resolved by a name service (DNS), wrong/blocked port numbers, outdated/missing JDBC drivers. Please verify that your DB configuration in site.properties on the registry server is correct, and that the registry starts without any DB connectivity errors logged in registry.log. Consult the 7.5 Administration guide for correct setup of the DB connection. If the issue still occurs, I'd recommend to open a ticket with CA support. However, please bear in mind that LISA 7.5 went EOS on 12/15/15, 7.5.1 will reach EOS on 04/15/16 and 7.5.2 will reach EOS on 06/01/16 (http://www.ca.com/us/support/ca-support-online/product-content/status/support-life-cycle/indexes/devtest-solutions-release-and-support-lifecycle-dates.aspx?id=%7BB93A8BB5-DF34-4488-8985-5CD4BA81C9F5%7D).