-
제목
Front Side Data report fails after upgrade to NetVault 13.x -
설명
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.
-
해결 방안
The missing columns will be added to the table on NetVault 13.0.3; meanwhile, the following workaround could be applied: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_mediamanagementinsert 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_viewStep 3. Restart the NetVault PostgreSQL service.
Step 4. Run the Front Side Data report.
-
결함 ID
NV-1506