Problem while generating reports.
Hi All,
We are getting error while generating a report i.e when we try to generate a report for 48 hrs using any format, in report we are getting error "1 Dashlet was removed because the limit of 5000 rows in tables overall was reached, had 41209 table rows in report.
"
Please Find the attachment for further information.
So how to increase rows limit to get complete results in report.
Please Help.
Best Regards,
Jaydatt.
[report_2012-07-07 13-01.xls|^report_2012-07-07 13-01.xls]
please any help???????? it is urgent....
Hi Jaydatt,
You need to change some options.
Are you using a webstart client? If you are, in order to make this work for the Webstart Client, you have to add the setting to the file (replace build-nr with the build that you are running):
C:\Program Files\dynaTrace\dynaTrace 4.1.0\server\conf\plugins\c.d.d.autoupdate.client.common_4.1.0.<build-nr>\common\plugin.properties
where build_nr is your build number, in a new line:
com.dynatrace.diagnostics.reporting.maxTableRows=65000
For non-webstart clients, the following setting has to be added to dtclient.ini file in c:\users\<username>.dynaTrace\dynaTrace 4.1.0 folder
-Dcom.dynatrace.diagnostics.reporting.maxTableRows=65000
Please keep in mind that in some cases Excel may also prohibit files with more than 65536 rows, you will see something like the following if you try to report more: Invalid row number (65536) outside allowable range (0..65535)
If the settings are in effect, you will see the following log message in both server and client log,
yyyy-mm-dd hh:mm:ss INFO [ServerReportManager] Using non-default limit of table rows per report: '65000'
Please ensure that you're inserting the option before the following option in dtclient.ini,
-Deof=eof
Thanks,
Rob
Hi Rob,
What setting would I change to increase the lines to 65000 for a recurring report? We have a daily report that we created on the server that emails an Excel spreadsheet out.
Thanks,
Frank
Hi Rob,
Thanks for Reply its working now,But for this I have to change ini file on each system where my client is installed is there way by which I can change config file at server level and get report from any system where client is installed.
Please suggest.
Amol
Can you use the Web Start Client in your scenario? In this case you only need to change this in one location on the dynaTrace Server.
Andi
hi Rob/Andi,
yes we will try to use web start client.
we are facing one more issue that when we generate report start time and end time format is changed into binary number hoe can I get proper time format in report?
please find the attachment for further detail.
Regards,
Jaydatt.
The value represents the time in milliseconds since Jan 1 1970. In Excel you can use a simple function as explained in the following post to display it in a nice way: http://stackoverflow.com/questions/2666112/convert-miliseconds-to-date-in-excel
Once you have the converted value you can set the cell format to date and it should show corretly
Andi
Hi
I have made changes in ini file and I'm also getting report if I'm generating manualy But when I trying to generate report using scheduled Task I'm getting same error
""1 Dashlet was removed because the limit of 5000 rows in tables overall was reached, had 41209 table rows in report.
"
Please suggest.
Hi All,
I am also facing same issue...
Please suggest.
Best Regards,
Jaydatt.
Hi
When you setup a Scheduled Report you can select the Execution Target of that Report on the second Tab. If you select dynaTrace Server or a Collector make sure that the setting for the maxTableRow is set in the respective collector or server ini files
Andi
Hi Andi,
Thanks, it is working.
Best Regards,
Jaydatt.
Hi Andi,
It was working few days back but not I'm getting message in report
"Not showing 335 additional table rows, adjust the limits in the Dashboard or Dashlet properties to show the additional table rows."
I want to inform you that We have changed Max no of lines under dashboard properties to max but still I'm getting this error.
We are getting only 10 rows for each type of error please find the attached report for details.
Hi Amol
have you looked into the properties of the Errors dashlet itself? Can you change these settings on the dashlet and try if that makes a difference?
Hi Andi,
I tried both the alternatives Dashlet as well Dashboard properties but I'm getting same result. Here would like to mention that we are facing this issue only for Error dashboard all other reports are working properly.
Please suggest.
Amol
Hi,
the Dashlet/Dashboard properties only allow you to raise the limits up to a pre-defined limit. This is in place to avoid oversized reports bringing down the whole dynaTrace Server.
If you want to create larger reports, you can use the setting
-Dcom.dynatrace.diagnostics.reporting.maxTableRows=65000
However you may need to set this in different places depending on which parts of the reporting functionality you are using:
- Set it in the dtclient.ini for installed client versions
- Set it as described above for Webstart client
- Set it in the dtserver.ini file for reports created via schedules/REST calls
Hi Dominik,
We already configured that setting in all collector,server and agent ini files and we are getting reports for all other reports properly but we are getting this error only for Error dashboard.
Please suggest.
Regards,
Amol
Hi,
ah, ok, this sounds like a problem in the reporting functionality, please report a Support-Case linking to this thread so we can investigate.
Thanks... Dominik.
