02-02-2012 02:22 AM
Morning,
I'm having very basic, but irritating issues with OpsCenter included with out NetBackup 7.1.0.2 installation. OpsCenter is the free version.
I have daily reports of backups that succeed or fail. On a daily basis I export these and use them for reporting.
When I export, I like to do so via CSV as it allows me to remove the parent jobs that I cannot remove through the report configuration itself. However, when exporting to CSV, there seems to be a limit of 266 rows. As the report extends beyond 266 rows I end up losing a small amount of report data. When exporting to PDF I get all data, but can't edit it as I can with a CSV in Excel.
I initially assumed it would be an Excel issue, however the imported CSV shows the "report generated on" line on 266.
The same issue applies to XML exports.
Does anyone know how to fix this issue? If I could exclude the parent jobs this wouldn't even be an issue, which is possibly the most annoying aspect of this.
Thanks,
Jason
02-02-2012 05:54 AM
Please refer to Technote:
Article: TECH170334 | | | Created: 2011-09-26 | | | Updated: 2011-09-26 | | | Article URL http://www.symantec.com/docs/TECH170334 |
After upgrading OpsCenter to 7.1.0.2, the setting of "maxTabularRows" parameter in web.xml (OpsCenter Webserver GUI config file) is required to be tuned.
This config file is located at %INSTALL_PATH%\Symantec\OpsCenter\gui\webserver\webapps\opscenter\WEB-INF\ folder.
Edit web.xml file and locate the session of "maxTabularRows", as below -
<init-param>
<param-name>maxTabularRows</param-name>
<param-value>4000</param-value>
</init-param>
Change the value "4000" (default setting) to an appropriate number, say, 10000, if the Tabular Report has less than 10,000 rows.
After the change is made, exit and save the edited web.xml file. Stop and restart OpsCenter Server Service and OpsCenter Webserver Service.
Please note that the higher the setting, the more system resources will be consumed, which would cause some performance degradation.
If the report is still only exporting 266 rows, there maybe a filter on the report that is preventing all data from being reported. Please double check the report parameters by editing the report and confirming the FILTER options.
02-02-2012 07:13 AM
Hi there Tom,
I made the change from 4000 to 10000 in the web.xml file and restarted the services, but it has made no difference, I'm still only getting 266 rows.
I'm sure it's probably only missing 5-6 rows off of the end of the CSV file.
Do you have any further suggestions? I've gone through everything I could find regarding the report and my settings, but cannot see any filters that would limit the rows in the CSV (and allow the PDF to display everything).
Thanks,
Jason.
EDIT:
I should probably add that the report displays 100% correctly in OpsCentre and on PDF. It is only CSV/XML data that is being cut off.
02-06-2012 01:19 AM
Sorry to bump this, I'm no closer to an answer and after recreating the report, the same still happens.
I need to use these reports on a daily basis, so will have to raise a Symantec Support ticket if no one can help here.
Thanks,
Jason
02-06-2012 03:52 PM
Can you let us know what the name of the report which you are using?
02-07-2012 12:13 AM
The report I've customised is Tabular Backup Report under Job Browser.
I hope this helps
02-07-2012 07:49 AM
i tried to generate same report and i got everything when i exported it. you should probably contact symantec on this.
02-08-2012 05:27 AM
Since I cannot confirm nor recommend posting your results to this forum, I would suggest opening a case with support.
I have not run into a situation where exporting a csv of a report would differ from the pdf version of the exact same report.
Are you able to locate the differences?
Are there jobs running 24 / 7 ?
If you have jobs running 24 / 7, and the report is expected to execute the last 24 hours of data, could it be possible that in the past 24 hours when the csv was executed, would vary by a few jobs.
Example: CSV was executed at 12:00 pm (local time)
PDF was executed at 12:10 pm (local time)
The reports vary by 6 jobs because between 12:00pm and 12:10pm yesterday 6 jobs completed.
Therefore these 6 jobs were present on the 12pm report, but not on the 12:10 report.
Attempt exporting a report using absolute time.
2/7/2012 12:00 am ---> 2/8/2012 12:00 am and export csv & pdf
Using absolute time the report should not vary.
--Tom
02-09-2012 03:19 AM
Hi Tom,
Using absolute time makes no difference. In this daily report I am limited to 266 rows.
Interestingly, the same report of the past 48 hours generates both day's worth of rows, confirmed against the PDF.
I've tried exporting earlier and later (10 mins - 3 hours) and the same can be seen each time. The PDF shows more results.
If there's a way of disabling the view of parent jobs I am confident I will get all the data.
Is this possible in this report?
Thanks,
Jason
02-09-2012 04:03 AM
Hi Jason
here what i have done in past for more or less the same issue.
Update :
C:\Program Files\Symantec\OpsCenter\server\config\report.conf
with line :
report.schedule.max.tabular.rows=20000
--> 20000 is what i have modified.
Unfortunately i could'nt find any Technote nor my email where it was suggested from symantec to update this file.
Ramazan
02-09-2012 02:26 PM
Is it related to free version. is this issue, or just limitation?
02-10-2012 12:33 AM
i have licensed version and this was a limitation
02-10-2012 12:48 AM
Ramazan,
Mine is currently set to 4000 rows which is more than adequate for a report that should only generate 280 rows at a maximum.
I have changed 4000 to 10000 in another config file and it has made no difference.
The most important fact in this though, is that it *will* export more rows in other reports.
Is there a limitation on rows in one 24 hour period? That's the only thing I could think of.
02-10-2012 01:14 AM
Well I have the same issue which i need to lookk on my site. As you mentioned when i export a CSV file then somehow this 4000 line limit hits BUT when i export the same via email then i'll get only 20000 lines which is specified in report.conf.
(i made a tabular backup report for last 24 hours, where i had 26'586 lines)
so i need to investigate also on my site.....
02-23-2012 08:03 AM