NetVault Database backup fails with a 'Failed during main database backup phase' error message. (4037031)

NetVault Database backup fails with a 'Failed during main database backup phase' error message.

The NVDB backup for NVBU 10 fails as soon as the logs section has been reached (even when the …\NetVault Backup\logs section was moved i.e. checking for log corruption):

1] Job Message   2015/01/05 08:54:42   39   Jobs   NV   Starting job 39 'NVDB' (Phase 1 , Instance 226) for UID 0
2] Job Message   2015/01/05 08:56:27   39   Media   NV   (WFML6030) Media in 'DRIVE 1:WFNVSD01' assigned to job ready for data transfer
3] Job Message   2015/01/05 08:57:38   39   Data Plugin   NV   Backup logs Database
4] Error   2015/01/05 09:04:32   39   Data Plugin   NV   Failed to backup logs db
5] Error   2015/01/05 09:04:34   39   Data Plugin   NV   Failed during main database backup phase
6] Error   2015/01/05 09:04:34   39   Jobs   NV   Job Status: Backup Failed

The trace files show the following…

Job Manager:
2   JOBMGR   ???   5620   62   0   85633058273   Plugin is now in state Backing up logs db
2   JOBMGR   ???   5620   210   1   90434739631   Plugin exited: "Backup failed" status 2 flags 0x0

NVDB Plugin:
2   DBBACKUP   ???   5284   179   0   85633058273   Backing up logs database
2   DBBACKUP   ???   5284   202   0   85739094452   Entering NvPgDbBackup for backing up netvault_logs
3   DBBACKUP   ???   5284   193   0   85739094452   Entering GetBinDirectoryPath()
3   DBBACKUP   ???   5284   194   0   85739094452   Leaving GetBinDirectoryPath()
3   DBBACKUP   ???   5284   195   0   85739110060   Entering GetPGCredentials()
3   DBBACKUP   ???   5284   196   0   85739125667   Leaving GetPGCredentials()
3   DBBACKUP   ???   5284   203   0   85739125667   NvPgDbBackup::obtained pstrBinPath: [D:\NV\pgsql\bin]
3   DBBACKUP   ???   5284   204   0   85739125667   The backup command is: D:\NV\pgsql\bin\pg_dump.exe -U postgres --format=tar --port 51486 netvault_logs.
3   DBBACKUP   ???   5284   205   0   85739125667   Calling PgCreateFifo() for backup
3   DBBACKUP   ???   5284   197   0   85739125667   Entering PgCreateFifo()
3   DBBACKUP   ???   5284   199   0   85739125667   Created StdOut Fifo
3   DBBACKUP   ???   5284   206   0   85739125667   Create process
3   DBBACKUP   ???   5284   207   0   85739125667   NvPgDbBackup()::pg_dump Tool created.
3   DBBACKUP   ???   5284   214   0   85739125667   Making child status CHILD_RUNNING;
3   DBBACKUP   ???   5284   215   0   85739890446   FileSysRead 4096
3   DBBACKUP   ???   5284   216   0   85739890446   non-zero bytes read from file
3   DBBACKUP   ???   5284   218   0   85739890446   BackupStreamSendData successful
3   DBBACKUP   ???   5284   215   0   85739906052   FileSysRead 4096
3   DBBACKUP   ???   5284   216   0   85739906052   non-zero bytes read from file
3   DBBACKUP   ???   5284   218   0   85739906052   BackupStreamSendData successful
3   DBBACKUP   ???   5284   215   0   90430982598   FileSysRead 1024
3   DBBACKUP   ???   5284   216   0   90430982598   non-zero bytes read from file
3   DBBACKUP   ???   5284   218   0   90430982598   BackupStreamSendData successful
3   DBBACKUP   ???   5284   215   0   90430982598   FileSysRead 65
3   DBBACKUP   ???   5284   216   0   90430982598   non-zero bytes read from file
3   DBBACKUP   ???   5284   218   0   90430982598   BackupStreamSendData successful
0   FILESYS   ???   5284   6   109   90432610646   Failed to read: The pipe has been ended.
0   DBBACKUP   ???   5284   220   0   90432610646   Failed to read from pipe while backup netvault_logs
0   DBBACKUP   ???   5284   222   0   90432626300   bSuccess=FALSE;
3   DBBACKUP   ???   5284   236   0   90432626300   NvPgDbBackup()::Exit.
0   DBBACKUP   ???   5284   181   0   90432626300   Failed to backup log database
3   DBBACKUP   ???   5284   186   0   90432626300   Ececution of NVPGBackupLogsDatabase completed
4   PLGLIB   ???   5284   2355   0   90432626300   CP: PlgJobMgrUpdateTransferInfo(262144, 00000000
4   PLGLIB   ???   5284   2355   0   90432626300   CP: PlgJobMgrUpdateTransferInfo(262144, 00000000
0   MSGWAIT   ???   5284   16   0   90432641954   Message 'LOGD_START_BACKUP_LOGS_REPLY_MSG' not handled at depth 0
4   PLGLIB   ???   5284   2355   0   90434692668   CP: PlgJobMgrUpdateTransferInfo(262144, 00000000
2   DBBACKUP   ???   5284   95   0   90434739631   NetVault Database Backup failed
0   NET   ???   5284   84   0   90434739631   Connection down

We also see that the NVDB plugin appears to backup "General Report Files" but not "Reports database". It seems to skip "Reports database" and goes directly to "logs db".

The NVBU 10.0.1 version and above, has an additional setting and was introduced for the NVDB backup.
The two settings are “Tar” and “Custom”. The default is “Tar” and has the following limitations:

• It requires a large amount of disk space to store temporary files during backup. The backup could fail if the tmp directory in the NetVault Backup installation directory does not have sufficient space to store the files.

• It has a table size limit of 8GB. Database tables that are larger than 8GB in size cannot be backed up using this format. In such cases, you can set the backup format to custom.

The issue was resolved by changing the setting to the "Custom" option.
The instructions for changing the setting is in the following link (there are two ways to change that setting listed there):

https://support.quest.com/technical-documents/netvault-backup/10.0.1/built-in-plug-ins-user-guide/5#TOPIC-230050