You can follow these steps to verify this is the problem.
1. Go to <NetVault Home>/pgsql/bin and launch pgAdmin3.exe
2. Go to File menu and select add server option
3. Fill Name field with anything, Host => localhost, Port => <Value given during installation>, UserName => postgres, Password => <Given to postgres during NetVault Installation> and then click on OK button.
4. Expand the newly added server.
5. Expand the database
6. Expand "netvault_mediamangement" database.
7. Expand Schemas => Public => tables
8. Select 'medmgrbackuprecord' table and see the table schema in Right hand bottom pane (SQL pane)
It should have created a table query like this
CREATE TABLE medmgrbackuprecord
(
backupid bytea NOT NULL,
sessionid bytea NOT NULL,
sessionjobid integer NOT NULL,
sessioninstance integer NOT NULL,
sessionphase integer NOT NULL,
strclient text NOT NULL,
strserver text NOT NULL,
pluginname text NOT NULL,
pluginid integer NOT NULL,
plugindata bytea,
backupdate integer NOT NULL,
backupset text NOT NULL,
bincremental boolean NOT NULL,
barchive boolean NOT NULL,
permissions bytea,
strtag bytea,
fileid integer NOT NULL,
recordid serial NOT NULL,
jobname text NOT NULL,
jobid integer NOT NULL,
restoreoptions bytea,
delimiters bytea,
extensions bytea,
fullsize bigint NOT NULL,
incrementalsize bigint NOT NULL,
indexlife integer NOT NULL,
CONSTRAINT medmgrbackuprecord_pkey PRIMARY KEY (backupid),
CONSTRAINT medmgrbackuprecord_recordid_key UNIQUE (recordid)
)
The problem is it will be missing THESE columns below:
fullsize bigint NOT NULL,
incrementalsize bigint NOT NULL,
To repair the database, follow these steps.
1. Stop NetVault service.
2. Launch command prompt with admin privileges.
3. Change directory to <NetVault Home>\util
4. Run nvrepdbmigrate2pg.exe
5. Check through pgadmin, if the missing columns are there now.
6. If yes, then restart the service and Login to WebUI and perform the Explorer Storage operation.
