Unable to view any VSE metrics in DevTest 10.5.0 Portal

Products

• CA Cloud Test Mobile
• CA Application Test

Issue/Introduction

Unable to view metrics in portal

Checked DB and metrics are available there, but not being displayed in the DevTest Portal.

Environment

Release : 10.5

Component : CA Service Virtualization

* Linux Redhat 7.7 (Enterprise Dashboard is on a different machine, everything else (Registry, VSE, Portal) is hosted on one machine.)
* PostgreSQL 11.7 (on separate machine)

Cause

Permissions issue.

See these errors in the portal-grails-res-hub.log:

2020-02-19 15:20:43,014Z (10:20) [qtp846492085-21608] ERROR org.grails.web.errors.GrailsExceptionResolver - RetrofitError occurred when processing request: [GET] /devtest/api/sv/vseServers/PAT4VSE/services
401 Unauthorized. Stacktrace follows:
retrofit.RetrofitError: 401 Unauthorized
 at retrofit.RetrofitError.httpError(RetrofitError.java:39)
 at retrofit.RestAdapter$RestHandler.invokeRequest(RestAdapter.java:382)
 at retrofit.RestAdapter$RestHandler.invoke(RestAdapter.java:240)
 at com.itko.lisa.vse.VseServerInfoService.$tt__getDeployedServices(VseServerInfoService.groovy:81)

2020-02-19 15:20:43,016Z (10:20) [qtp846492085-21596] ERROR org.grails.web.errors.GrailsExceptionResolver - JSONException occurred when processing request: [GET] /devtest/api/sv/recordingService/getRecordings/PAT4VSE
A JSONArray text must start with '[' at character 1 of {"id":401,"message":"Authorization failed"}
. Stacktrace follows:
org.grails.web.json.JSONException: A JSONArray text must start with '[' at character 1 of {"id":401,"message":"Authorization failed"}

Resolution

Access issue.

Looked into the permissions for the user requesting access to the PostgreSQL table and added additional permissions and all of a sudden it is fine. A bit odd considering everything was still being recorded in the new database, but we're good now!