Virtual Service Response Time Reporting Error - "JasperReports encountered an error on context creation!"

Products

• Service Virtualization

Issue/Introduction

While trying to access the Virtual Service Response Time Reporting page, are getting  error:

"JasperReports encountered an error on context creation!"

Environment

All supported DevTest releases an PostgreSQL.

Cause

Messages in the registry.log:

2023-01-24T14:44:53,916Z (09:44) [qtp1174359965-251069] ERROR System.err                     
    - org.postgresql.util.PSQLException: FATAL: sorry, too many clients already

DevTest is trying to establish more connections to the Registry database than allowed.

According to PostgreSQL, the default max_connections is 100.

Resolution

The new connection pool and shared buffer size were increased from default to 300 and 80 MB respectively, which resolved this issue.