Video Screencast Help
Protect Your POS Environment Against Retail Data Breaches. Learn More.

Multiple Entries On OpsCentre Reports

Created: 27 Apr 2012 | 11 comments

Hi,

I have recently upgraded my OpsCenter Analytics to v7.5.01 and am now seeing multiple entries for successful backups for HPUX clients, I have checked the views that I use and these are Ok, I have checked the backup jobs to ensure that they only completed once which they had so not sure why they would show as multiple completed jobs in the reports.

Also is there an option to select unique entries as when a job fails and retries (5 times in our settings) I am getting 5 entries for the failed job on the reports.

 

Kev

Comments 11 CommentsJump to latest comment

Kevin Lamb's picture

The problem is only occuring if I use the Job Browser / Tabular Backup Report as my template.

 

 

tom_sprouse's picture

Which fields are selected for your Report and are there any operations or sorting being performed on those fields.

 

Example: 

 

 

Note: If this post provides you with a solution don't forget to mark the discussion as solved...

 

Kevin Lamb's picture

Hi,

I have the following fields selected:

Client Name
Schedule Type
Master Server
Media Server
Policy Name
Job Type
Schedule Name
Job Status
Status Code

I do not get a sort option on the report builder.....

 

Kev

tom_sprouse's picture

Are you running Analytics? 

What if you create a custom report instead of using a template?  

 

 

 

Note: If this post provides you with a solution don't forget to mark the discussion as solved...

 

Kevin Lamb's picture

I am running Analytics with View Builder.

I have created a custom report rather than using the template and this seems to work correctly, looks like it may be an issue with the Tabular Backup Report template.

Many thanks for the advice, not sure it is a solution but it is a valid work around. 

Kev

tom_sprouse's picture

Kevin, you previously mentioned upgrading to 7.5.0.1

Is this the version you are running for the tabular report template issue? (In case, there are multiple environments)

 

We do have it documented for 7.1.0.4, the following Technote:

 

The Tabular Backup Report fails after editing to remove one or more columns from the output after upgrade to 7.1.0.4
http://www.symantec.com/docs/TECH186090
 
 
Stating the issue does not exist in 7.5 - however, I have not tested 7.5.0.1 yet.. and was wondering if 7.5.0.1 needs to be added to this defect.
 
--Tom
 
 

Note: If this post provides you with a solution don't forget to mark the discussion as solved...

 

Kevin Lamb's picture

Hi Tom,

I upgraded from 7.1 to 7.1.0.4 originally and then had the issue with the tabular reports whereby I was losing the data within the reports as per the technote I then upgraded directly to 7.5.0.1 at which point the tabular reports were working but I then got the issue of duplicated entries for HP-UX clients in any report that was compiled with the Job Browser / Tabular Backup Report.

If I use the custom report builder I do not get the error.

An example is shown below, bf-orion is the HP-UX client which is repeated the bfb-00x clients which are RHEL clients and these only show one entry, this is the same with Wintel & MAC clients :

Praveen Choudhari's picture

Hi

The report has left outer joins on several tables (nb_jobfilesarchive,nb_JobAttemptArchive). The report is showing duplicate entiries because 

1. There might be some jobs which have multiple files backed up for that client.

2. There might be multiple attempts for some jobs on that client.

On selecting all columns for this report , you should be able to see unique tuple.

Kevin Lamb's picture

Hi Praveen,

There were no multiple attempts for the jobs shown as duplicates, there are multiple directories in the Backup Selection for the policy, having checked the full 420 entried for lastnights backups it would appear that the multiple entries in the Backup Selection is indeed causing this display, it is also affecting Wintel backups that have more then one directory listed in the Backup Selection

Using the Tabular Backup Report template I do not get the Unique option.

 

Kev

Praveen Choudhari's picture

Hi Kevin

The unique option is currently available only in custom reporting.  If you want the report with only few columns from Tabular backup report , then I would request you to create a custom report with those columns. Tabular backup report will show unique tuple only when you have job directory/attemp start time column + other column you have selected.

Kevin Lamb's picture

Hi Praveen,

I have altered my daily reports by using the custom reports and am now happy with the output, I always used the Tabular report previously but it looks like this option is not really viable for use in customising for general output of showing job success unless you want the added benefit of it showing which directories were backed up, this never used to show this output though...