Metrics for Virtual Service Response Time are not available in DevTest Portal

Products

• CA Application Test
• Service Virtualization
• CA Continuous Application Insight (PathFinder)
• CA Service Virtualization (DevTest / LISA / VSE / Application Test)

Issue/Introduction

In DevTest Portal, under Reporting, VSE Metrics, when selecting Virtual Response Time and specifying a time range, no chart is being created.
If a different time range is specified, the chart is generated.

Cause

The VSE collects the metrics details in memory and then write out the details to the database configured with the Registry.
For the VSE Metrics, the following tables are verified:

VSE_METRICS_EVENTS
VSE_METRICS_PERIODICS
VSE_METRICS_TXN_COUNTS

When verifying the database, there is no data available for the time range specified.
Looking at the log files, we could confirm there is a database connectivity issue.
 

Environment

All supported releases of DevTest.

Resolution

The site.properties file holds the database configuration.
There were two connection strings enabled on the site.properties file.
After the incorrect connection string was commented out and DevTest components were restarted, the VSE Metrics Reports were available.

Additional Information

More information regarding Virtual Service Metrics Reports​:
https://docops.ca.com/devtest-solutions/10-1/en/using/using-ca-service-virtualization/using-devtest-portal-with-ca-service-virtualization/virtual-service-metrics-reports