Enterprise Dashboard, connected to PostgreSQL, is not showing up data, just showing Loading...

Products

• Service Virtualization

Issue/Introduction

Enterprise Dashboard, connected to PostgreSQL, is not showing up data, just showing Loading...

 

Warning messages in enterprisedashboard.log file:

2022-12-26T09:52:15,218Z (03:52) [main] WARN  net.sf.ehcache.config.ConfigurationFactory - No configuration found. Configuring ehcache from ehcache-failsafe.xml  found in the classpath: jar:file:/opt/lisa/CA/DevTest/lib/dradis/ehcache-2.10.6.jar!/ehcache-failsafe.xml
2022-12-26T09:52:17,877Z (03:52) [main] WARN  org.springframework.beans.GenericTypeAwarePropertyDescriptor - Invalid JavaBean property 'exceptionMappings' being accessed! Ambiguous write methods found next to actually used [public void grails.plugin.springsecurity.web.authentication.AjaxAwareAuthenticationFailureHandler.setExceptionMappings(java.util.List)]: [public void org.springframework.security.web.authentication.ExceptionMappingAuthenticationFailureHandler.setExceptionMappings(java.util.Map)]

Environment

All supported DevTest releases and platforms.

External database is PostgreSQL 13.5

Cause

Userid being used to connect to the PostgreSQL database for the Enterprise Dashboard did not have the permissions to create the tables.

The messages in the log file did not indicate there was a permissions issue, but when looking at the schema for the Enterprise Dashboard in the PostgreSQL console, there were no tables.

Resolution

Once DBA Authority was given to the userid, DevTest created all the tables and the Enterprise Dashboard displayed properly in the browser.