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
Discussion Filed Under:
Comments 11 Comments • Jump to latest comment
The problem is only occuring if I use the Job Browser / Tabular Backup Report as my template.
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&l
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
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&l
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
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:
Note: If this post provides you with a solution don't forget to mark the discussion as solved&l
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 :
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.
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
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.
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...
Would you like to reply?
Login or Register to post your comment.