Problem while generating reports.

Hello Is there any update on this? I'm using 5.6 and I have same issue. I have 65k and 100k on dtclient.ini file but I still get some xxx additional rows are missing.

Hi Dominik,

Thanks for update. I will open support case for this issue.

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.

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,

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 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 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.

Reporting Error.png

report_2012-12-14_19-39-05.xls

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 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.

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