Service Virtualization

Expand all | Collapse all

Hi All, I am getting below error while opening any vsm in LISA 7.5

Jump to Best Answer
  • 1.  Hi All, I am getting below error while opening any vsm in LISA 7.5

    Posted 10-21-2015 05:31 AM

    Error loading VS Model document: 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!

     

     

    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

    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: Hi All, I am getting below error while opening any vsm in LISA 7.5
    Best Answer

    Posted 10-21-2015 10:19 AM

    Hello RohanDoshi,

     

    It looks like you are running into database connectivity issues in the Workstation you are trying to open the VSM.

    Are you facing this problem just with one workstation or with different components as well?

    If your Registry is configured to use an external DB, make sure you have the jdbc driver under LISA_HOME/lib folder.



  • 3.  Re: Hi All, I am getting below error while opening any vsm in LISA 7.5

    Posted 03-10-2016 07:53 AM

    I am facing this problem with all workstations connected to Registry .



  • 4.  Re: Hi All, I am getting below error while opening any vsm in LISA 7.5

    Posted 03-10-2016 08:11 AM

    Rohan - Can you verify that you are able to connect to this database with the same credentials from outside Lisa without any issues?



  • 5.  Re: Hi All, I am getting below error while opening any vsm in LISA 7.5

    Posted 03-10-2016 08:19 AM

    U mean this Derby database details ? LISA derby databse right ?



  • 6.  Re: Hi All, I am getting below error while opening any vsm in LISA 7.5

    Posted 03-10-2016 08:42 AM

    So you are using internal Derby then...ok. How much do you care about the data in the existing derby database? If you do not, stop registry and backup the exists derby database as another name (Lisa.db.backup) and then delete the Lisa.db database. Restart the registry and the database should be recreated. Check if this resolves the issue. 



  • 7.  Re: Hi All, I am getting below error while opening any vsm in LISA 7.5

    Posted 03-18-2016 03:42 AM

    Which file exactly to be renamed from this ?

    Also U mean just rename the file >Restart LISA workstation ? and Registry both ?



  • 8.  Re: Hi All, I am getting below error while opening any vsm in LISA 7.5

    Posted 03-18-2016 03:43 AM

    Problem is with all the workstations .



  • 9.  Re: Hi All, I am getting below error while opening any vsm in LISA 7.5

    Posted 03-12-2016 12:43 PM

    Rohan - anything on this?



  • 10.  Re: Hi All, I am getting below error while opening any vsm in LISA 7.5

    Posted 03-17-2016 08:32 AM

    It is working at times unable to open ..not getting the exact error.



  • 11.  Re: Hi All, I am getting below error while opening any vsm in LISA 7.5

    Posted 03-17-2016 10:41 AM

    Ok....do you see this problem from just one Workstation or are many Workstations seeing this intermittent issue? Did you try dropping the database and let a new one be created when the Registry starts OR is this not an option?



  • 12.  Re: Hi All, I am getting below error while opening any vsm in LISA 7.5

    Posted 03-17-2016 10:48 AM

    Also can you check if on the Workstation machine you have the database drive in the Lisa_Home/lib folder?



  • 13.  Re: Hi All, I am getting below error while opening any vsm in LISA 7.5

    Posted 03-18-2016 04:39 AM

    As deoma03 indicated, this appears to be a DB connectivity issue, 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 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).