In CU6 report schedules that were created in the old Flash scheduler show up as "metric view"

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

I have a bunch of Performance Reports that were created in the old Flash version of Performance Report Designer (PRD).  Previously these had been scheduled to be emailed, but this has not been working since Flash was removed from the product.

When I went to ReportScheduler I could see all the reports still existed but they were incorrectly listed as "Metric View" when I know they are PRD reports.

Environment

Release : 20.4

Cause

In UMP 8.x/9.x/20.1, the reportType column in DB was populated based on the index of the following data structure: {PRD,SLA}. 
So reportType field values were as follows : PRD=0, SLA=1

However during OC 20.3 release, initially it was decided that PRD reports will not be part of the reportscheduler and instead metricviewer will be added.

At this time someone seemed to have made the assumption that nobody would still have any of the old PRD's scheduled because they hadn't been working for so long. So the above data structure became as follows : {METRIC_VIEW,SLA}
The reportType was then generated as follows : METRIC_VIEW=0, SLA=1

Eventually when PRD was re-added to the reportscheduler, so the above datastructure became : {METRIC_VIEW,SLA,PRD}
So the reportType was then generated as follows : METRIC_VIEW = 0, SLA = 1, PRD=2

Resolution

Run a query against the database - 

update umpreportinfo set reportType = 2 where ID in (select reportinfo from umpjob) and reportType=0;

This will update the scheduled PRD's accordingly.

Note that if you also have some metric views scheduled to send, you may have to alter this query to accomodate them.