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

Products

• CA Application Test
• Service Virtualization
• CA 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.