Derby: Internal Exception: java.sql.SQLException: Connections could not be acquired from the underlying database!
book
Article ID: 107144
calendar_today
Updated On:
Products
CA Application TestService VirtualizationCA Continuous Application Insight (PathFinder)CA Service Virtualization (DevTest / LISA / VSE / Application Test)
Issue/Introduction
My Registry is not coming. Getting this error in registry.log.
2018-07-17 20:49:18,744Z (13:49) [main] ERROR com.itko.lisa.utils.JpaUtil - Exception raised checking table existence: 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 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.allTablesExist(JpaUtil.java:599) at com.itko.lisa.utils.JpaUtil.<init>(JpaUtil.java:490) at com.itko.lisa.utils.JpaUtil.getDradisUtil(JpaUtil.java:406) at com.itko.lisa.dradis.comm.JpaUtilWrapper.getAnnotations(JpaUtilWrapper.java:24) at com.itko.lisa.dradis.comm.DradisCommContext.doEnterpriseDashboardHandshake(DradisCommContext.java:133) at com.itko.lisa.coordinator.TestRegistryImpl.initialize(TestRegistryImpl.java:280) at com.itko.lisa.coordinator.TestRegistryImpl.<init>(TestRegistryImpl.java:239) at com.itko.lisa.coordinator.TestRegistryImpl.main(TestRegistryImpl.java:2163) 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) 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
Cause
Properties to target Derby were not set in dradis.properties or site.properties file.
You can also get this error if the Derby database is full.
Environment
Release: Component: ITKOTF
Resolution
In the dradis.properties set
dradis.db.internal.enabled=true
In the site.properties set:
lisadb.internal.enabled=true
Restart Both Enterprise Dashboard and Registry.
Was then able to see both Enterprise Dashboard and Registry to come up.