ERROR: "Database Query(selectPreferences)fails." F5 Load Balancer OM Web Viewer 12.1
search cancel

ERROR: "Database Query(selectPreferences)fails." F5 Load Balancer OM Web Viewer 12.1

book

Article ID: 7907

calendar_today

Updated On:

Products

Output Management Web Viewer

Issue/Introduction

Getting

com.ca.erm.webviewer.control.AdminPrefDetailBean: getPrefList - Database Query(selectPreferences)fails. Attempting to execute an operation on a closed EntityManagerFactory.

when configuring the F5 load balancer to make health checks on Web Viewer 12.1.

Environment

  • F5 load balancer
  • Output Management Web Viewer 12.1
  • Apache Tomcat®

Cause

The Load Balancer was looking at Web Viewer login.jsf or login.jsp files to ensure the application was alive - that caused the number of sessions on Tomcat to grow to over 750. 

Resolution

Configuring the F5 load balancer to use a ping.html page to ensure the Web Viewer application was alive avoided the problem.

Additional Information