Prior to the upgrade, the "Front Side Data" report could be generated fine, but after upgrading to NV 13.x, the job fails.
Binary Log show the following entries:
| Status | Class | Message |
| Information | Schedule | Starting phase 1 on NVServer |
| JobMessage | Jobs | Starting job 49 'Front Side Data' (Phase 1 , Instance 10) for UID 0 |
| JobMessage | System | Start a new job component |
| Error | System | Failed to initialise reports system from parameters |
| Error | System | Failed when processing report components |
| Error | Jobs | Fatal error: Report Failed |
| Error | Jobs | Job Status: Report Failed |
| JobMessage | Jobs | NVServer Finished job 49, phase 1 (instance 10) |
Additionally, the License Management reports also indicates that license capacity has been exceeded even it is not the case.
New rows for 'client' and 'parentjobid' in columninfo_view (or columninfo table) needed for front side data usage calculation on NetVault 13 are not being added during the upgrade.
Manually add row/s for 'client' and/or 'parentjobid' in columninfo_view (or columninfo table):
cd $NV_HOME/pgsql/bin psql --port 51486 --username postgres
\c netvault_mediamanagement
insert into columninfo_view (table_name, column_name, reporting_datatype, measure, nicename, description, nicenameid, descriptionid) values ('frontsidedata_view', 'client', 'string', 'f', 'client', 'Name of the client where backup ran', 16444, 16445);
insert into columninfo_view (table_name, column_name, reporting_datatype, measure, nicename, description, nicenameid, descriptionid) values ('frontsidedata_view', 'parentjobid', 'integer', 'f', 'Parent Job Id', 'The Parent Job of this job\\(in case of CIB, last full would be parent job\\)', 16446, 16447);
Additionally, add the corresponding stanzas to the frontsidedatafields file
1. Open the NV_home/reports/fields/frontsidedatafields file in the text editor.
2. Append the following two stanzas in the file .
[field:client]
type = string
nicename = client
nicenameid = 16444
characters = 12
description = Name of the client where backup ran
descriptionid = 16445
measure=FALSE
view=frontsidedata_view
[field:parentjobid]
type = integer
characters = 6
nicename = Parent Job Id
nicenameid = 16446
description = The Parent Job of this job(in case of CIB, last full would be parent job)
descriptionid = 16447
measure=FALSE
view=frontsidedata_view
Step 3. Restart the NetVault PostgreSQL service.
Step 4. Run the Front Side Data report.
