Opscenter 7.6 Not showing all Failed Jobs

[gbrougham]

Good Afternoon Everyone,

I have a question that hopefully is an easy one. We recently implemented an upgraded OpsCenter server at version 7.6 running Windows Server 2008 R2.

Everything is up and running and our 3 backup hosts (multiple sites) are reporting in normally.

My question is as follows:

When I create a custom failed job report, it lists all failed job except for the jobs that failed due to the backup window closing.

I checked the configuration of the report on our old OpsCenter 7.1 server and it is identical.

Even if I choose a standard report for failed jobs, the backup window closed failures do not show. I can run a separate report for the backup window being closed which does show those jobs.

Is this a normal function now in 7.6 as I would have thought a failed job report would list all failures regardless of type of failure

thank you in advance of any insight

Gordon

[Dollypee]

Hi, Are you running opscenter Analytic? If yes, here's query to display all failed jobs

SELECT networkName as 'Master Server',
max(UTCBigIntToNomTime(domain_Job.startTime)) as 'Start Time',
clientName as 'Client Name',
policyName as "Policy Name",
statusCode as "Status Code"
FROM domain_Job,domain_MasterServer,lookup_jobtype
WHERE domain_MasterServer.id = domain_Job.masterserverId
and domain_Job.scheduleName not like '%hour'
and domain_Job.scheduleName not like '%ERROR'
and domain_Job.scheduleName != 'online'
and lookup_jobtype.name = 'Backup'
and statusCode not in (0,1) and policyName NOT LIKE 'SLP_%' and type IN (0,22,28)
AND DATEDIFF(hour,UTCBigIntToNomTime(startTime), GETDATE()) <= 24
group by "Client Name","Status Code","Master Server","Policy Name"
order by networkName,clientName ASC

[areznik]

Click the view SQL option and show us what you get back

[Dollypee]

I am also suddenly experiencing this issue for our backup domain running 7.6.1.2

Here's the equivalent sql 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 '137724552000000000' AND '137724840000000000') 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.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, -1 )) ) AND ( (domain_JobArchive.type IN (0, 2, 6, 28 )) ) AND ( (domain_JobArchive.statusCode NOT IN (200, 228, 191 )) ) AND ( (domain_JobArchive.isValid = '1') ) AND ( (domain_MasterServer.id IN (4708846,4949386,10083258,10113645,10356508 )) ) )