Opscenter version - 8.1.1
Affected master server version - 7.6.1.2
Hello all,
I had configured canned report to generate all failed backups. However, It was brought to my attention, the report is skipping or failing to report error codes 196. I took a look, I discovered this is indeed happening. Has any one encountered this issue and how it was resolved?
Here's the show query report :
select TOP 100 START AT 1 domain_MasterServer.id as "domain_MasterServer.id",domain_Client.id as "domain_Client.id",domain_Policy.name as "domain_Policy.name",domain_JobArchive.statusCode as "domain_JobArchive.statusCode",(case when domain_JobArchive.state =106 then 3 when domain_JobArchive.state =3 and domain_JobArchive.statusCode =0 then 0 when domain_JobArchive.state =3 and domain_JobArchive.statusCode =1 then 1 when domain_JobArchive.state =3 and domain_JobArchive.statusCode>1 then 2 else -1 end) as "jobExitStatus",adjust_timestamp(domain_JobArchive.startTime,-14400000 ) as "domain_JobArchive.startTime",adjust_timestamp(domain_JobArchive.endTime,-14400000 ) as "domain_JobArchive.endTime",NOM_DateDiff(domain_JobArchive.startTime, domain_JobArchive.endTime) as "backupJobDuration",nb_JobFilesArchive.fileinfo as "nb_JobFilesArchive.fileinfo",domain_JobArchive.state as "domain_JobArchive.state",nb_JobBackupAttributesArchive.destStorageUnit as "nb_JobBackupAttributesArchive.destStorageUnit" from domain_JobArchive , domain_MasterServer , domain_Client , domain_Policy , nb_JobFilesArchive , nb_JobBackupAttributesArchive , nb_JobArchive where domain_MasterServer.id = domain_JobArchive.masterServerId and domain_MasterServer.id = domain_Client.masterServerId and domain_MasterServer.id = domain_Policy.masterServerId and domain_MasterServer.id = domain_JobArchive.masterServerId AND domain_JobArchive.masterServerId = nb_JobFilesArchive.masterserverId and domain_JobArchive.clientName = nb_JobFilesArchive.clientName and domain_JobArchive.id = nb_JobFilesArchive.jobId and domain_MasterServer.id = domain_JobArchive.masterServerId AND domain_JobArchive.masterServerId = nb_JobArchive.masterServerId and domain_JobArchive.clientName = nb_JobArchive.clientName and domain_JobArchive.id = nb_JobArchive.id AND nb_JobArchive.masterServerId = nb_JobBackupAttributesArchive.masterserverId and nb_JobArchive.clientName = nb_JobBackupAttributesArchive.clientName and nb_JobArchive.id = nb_JobBackupAttributesArchive.jobId and domain_Client.masterServerId = domain_JobArchive.masterServerId and domain_Client.name = domain_JobArchive.clientName and domain_Client.masterServerId = domain_JobArchive.masterServerId and domain_Client.name = domain_JobArchive.clientName AND domain_Policy.masterServerId = domain_JobArchive.masterServerId and domain_Policy.name = domain_JobArchive.policyName and domain_Policy.policyDomainName = domain_JobArchive.policyDomainName and domain_Policy.versionNo = domain_JobArchive.policyVersionNo and domain_Client.masterServerId = domain_JobArchive.masterServerId and domain_Client.name = domain_JobArchive.clientName AND domain_JobArchive.masterServerId = nb_JobFilesArchive.masterserverId and domain_JobArchive.clientName = nb_JobFilesArchive.clientName and domain_JobArchive.id = nb_JobFilesArchive.jobId and domain_Client.masterServerId = domain_JobArchive.masterServerId and domain_Client.name = domain_JobArchive.clientName AND domain_JobArchive.masterServerId = nb_JobArchive.masterServerId and domain_JobArchive.clientName = nb_JobArchive.clientName and domain_JobArchive.id = nb_JobArchive.id AND nb_JobArchive.masterServerId = nb_JobBackupAttributesArchive.masterserverId and nb_JobArchive.clientName = nb_JobBackupAttributesArchive.clientName and nb_JobArchive.id = nb_JobBackupAttributesArchive.jobId and domain_Policy.masterServerId = domain_JobArchive.masterServerId and domain_Policy.name = domain_JobArchive.policyName and domain_Policy.policyDomainName = domain_JobArchive.policyDomainName and domain_Policy.versionNo = domain_JobArchive.policyVersionNo AND domain_JobArchive.masterServerId = nb_JobFilesArchive.masterserverId and domain_JobArchive.clientName = nb_JobFilesArchive.clientName and domain_JobArchive.id = nb_JobFilesArchive.jobId and domain_Policy.masterServerId = domain_JobArchive.masterServerId and domain_Policy.name = domain_JobArchive.policyName and domain_Policy.policyDomainName = domain_JobArchive.policyDomainName and domain_Policy.versionNo = domain_JobArchive.policyVersionNo AND domain_JobArchive.masterServerId = nb_JobArchive.masterServerId and domain_JobArchive.clientName = nb_JobArchive.clientName and domain_JobArchive.id = nb_JobArchive.id AND nb_JobArchive.masterServerId = nb_JobBackupAttributesArchive.masterserverId and nb_JobArchive.clientName = nb_JobBackupAttributesArchive.clientName and nb_JobArchive.id = nb_JobBackupAttributesArchive.jobId and nb_JobArchive.masterServerId = nb_JobBackupAttributesArchive.masterserverId and nb_JobArchive.clientName = nb_JobBackupAttributesArchive.clientName and nb_JobArchive.id = nb_JobBackupAttributesArchive.jobId AND domain_JobArchive.masterServerId = nb_JobArchive.masterServerId and domain_JobArchive.clientName = nb_JobArchive.clientName and domain_JobArchive.id = nb_JobArchive.id AND domain_JobArchive.masterServerId = nb_JobFilesArchive.masterserverId and domain_JobArchive.clientName = nb_JobFilesArchive.clientName and domain_JobArchive.id = nb_JobFilesArchive.jobId and ( ( (domain_JobArchive.startTime BETWEEN '137723688000000000' AND '137723976000000000') AND (DATEDIFF(second, DATEADD(second,21600,DATE(DATEADD(second,-21600,adjust_timestamp(domain_JobArchive.startTime,-14400000) ))),adjust_timestamp(domain_JobArchive.startTime,-14400000 )) < '28800') ) AND ( ((CASE WHEN domain_JobArchive.parentJobId is null or domain_JobArchive.parentJobId=0 or domain_JobArchive.parentJobId=domain_JobArchive.id THEN 1 ELSE 0 END) = '0') ) AND ( ((case when domain_JobArchive.state =106 then 3 when domain_JobArchive.state =3 and domain_JobArchive.statusCode =0 then 0 when domain_JobArchive.state =3 and domain_JobArchive.statusCode =1 then 1 when domain_JobArchive.state =3 and domain_JobArchive.statusCode>1 then 2 else -1 end) IN (2, 3 )) ) AND ( (domain_JobArchive.type IN (0, 6, 28 )) ) AND ( (domain_JobArchive.statusCode NOT IN (200, 288, 191 )) ) AND ( (domain_JobArchive.isValid = '1') ) AND ( (domain_MasterServer.id IN (4708846,4949386,10083258,10113645,10356508 )) ) )
