02-12-2018 01:44 AM
Could some one help me resolving this issue -
It was backing up till yesterday and its failing since one day
(2) none of the requested files were backed up.
I have attached the detailed status of the job.
Solved! Go to Solution.
02-12-2018 02:21 AM - edited 02-12-2018 05:57 AM
You need to find out what has changed on the SQL client.
Has anyone perhaps modified the script?
Please see if there is a GROUPSIZE entry in the script:
Feb 12, 2018 11:47:53 AM - Info dbclient (pid=8948) USER - GROUPSIZE must be between 1 and 32.
Feb 12, 2018 11:47:55 AM - Info dbclient (pid=8948) INF - Results of executing <C:\Program Files\Veritas\NetBackup\DbExt\MsSql\FullBackupDAG.bch>:
If this is not the issue, ensure dbclient log foilder exists on the client (under ...NetBackup\logs) and retry the backup.
Check dbclient log for errors (or upload as dbclient.txt).
02-12-2018 02:21 AM - edited 02-12-2018 05:57 AM
You need to find out what has changed on the SQL client.
Has anyone perhaps modified the script?
Please see if there is a GROUPSIZE entry in the script:
Feb 12, 2018 11:47:53 AM - Info dbclient (pid=8948) USER - GROUPSIZE must be between 1 and 32.
Feb 12, 2018 11:47:55 AM - Info dbclient (pid=8948) INF - Results of executing <C:\Program Files\Veritas\NetBackup\DbExt\MsSql\FullBackupDAG.bch>:
If this is not the issue, ensure dbclient log foilder exists on the client (under ...NetBackup\logs) and retry the backup.
Check dbclient log for errors (or upload as dbclient.txt).
02-12-2018 02:21 AM
Try the solution from here:https://vox.veritas.com/t5/NetBackup/SQL-Agent-GROUPSIZE-issue/td-p/424413
In the Detailed status you have the following error:
12, 2018 11:47:53 AM - Info dbclient (pid=8948) USER - GROUPSIZE must be between 1 and 32.
02-15-2018 04:00 AM
Hi Mariene,
I have uploaded the dbclient logs , please verify them and let me the further step to resolve the issue.
Thanks-Bala
02-15-2018 04:13 AM - edited 02-15-2018 04:23 AM
I am confused about the fact that you marked the post as solved.
Did you check the script?
Can you please upload it here?
There is definitely a problem with the script as we see the following in the log:
CDBbackmain:: OperationsAreGroupable: INF - The batch file is not groupable because the master database is included in the grouping set.
.....
ReadBatch: USER - GROUPSIZE must be between 1 and 32.
Oh! There seems to be 2 separate scripts - the log for 10 Feb shows this script name:
C:\Program Files\Veritas\NetBackup\DbExt\MsSql\FullBackupPhysical.bch
and seems to indicate successful backup.
The failure on 11 Feb shows this script name:
C:\Program Files\Veritas\NetBackup\DbExt\MsSql\FullBackupDAG.bch
You need to check FullBackupDAG.bch.
Compare with FullBackupPhysical.bch to see what is different.