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

Article Id: 75626

Status: Published

Updated On: 16-10-2018 07:16

Products:

CA Application Test , Service Virtualization , CA Continuous Application Insight (PathFinder)

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