Upgrade to 13.1.2.11 will correct the issue with Netvault Database.
IMPORTANT: Please verify that you have a recent backup of the Netvault Database before running upgrade.
1. Make sure you have Netvault database password available
2. Open PowerShell
a. Change directory to Netvault installation directory
Typically this is c:\program files\quest\netvault\
b. cd c:\program files\quest\netvault\
3. Change directory to pgsql\bin\
c. cd pgsql\bin
4. Run the following command
.\psql -p 51486 -U postgres -d netvault_mediamanagement -c "select DISTINCT iscdpsegment,actualbyteswrriten,v3imageinfo from medmgrretiredrassegment;"5. If you get any error that indicates a column doesn't exist then you have the issue.
PS C:\Program Files\Quest\NetVault\pgsql\bin> .\psql -p 51486 -U postgres -d netvault_mediamanagement -c "select DISTINCT iscdpsegment,actualbyteswrriten,v3imageinfo from medmgrretiredrassegment;" Password for user postgres: ERROR: column "iscdpsegment" does not exist LINE 1: select DISTINCT iscdpsegment,actualbyteswrriten,v3imageinfo...
If you get any result then you do not have the issue.
Note: the number of returned rows does not matter.
PS C:\Program Files\Quest\NetVault\pgsql\bin> .\psql -p 51486 -U postgres -d netvault_mediamanagement -c "select DISTINCT iscdpsegment,actualbyteswrriten,v3imageinfo from medmgrretiredrassegment;" Password for user postgres: iscdpsegment | actualbyteswrriten | v3imageinfo --------------+--------------------+------------- (0 rows)
1. Make sure you have Netvault database password available
2. Open ssh session to Netvault server
a. Change directory to Netvault installation directory
Typically this is /usr/netvault
b. cd /usr/netvault
3. Change directory to pgsql/bin/
c. cd pgsql/bin
4. Run the following command
./psql -p 51486 -U postgres -d netvault_mediamanagement -c "select DISTINCT iscdpsegment,actualbyteswrriten,v3imageinfo from medmgrretiredrassegment;"5. If you get any error that indicates a column doesn't exist then you have the issue.
[root@netvault-server bin]# ./psql -p 51486 -U postgres -d netvault_mediamanagement -c "select DISTINCT iscdpsegment,actualbyteswrriten,v3imageinfo from medmgrretiredrassegment;" Password for user postgres: ERROR: column "iscdpsegment" does not exist LINE 1: select DISTINCT iscdpsegment,actualbyteswrriten,v3imageinfo ...
If you get any result then you do not have the issue.
Note: the number of returned rows does not matter.
[root@netvault-server bin]# ./psql -p 51486 -U postgres -d netvault_mediamanagement -c "select DISTINCT iscdpsegment,actualbyteswrriten,v3imageinfo from medmgrretiredrassegment;" Password for user postgres: iscdpsegment | actualbyteswrriten | v3imageinfo --------------+--------------------+------------- (0 rows)
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center