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

Products

• CA Application Test
• CA Continuous Application Insight (PathFinder)

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

Environment

Release:
Component: ITKOTF

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.

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.