• Forums
    • Public Forums
      • Community Connect
      • Dynatrace
        • Dynatrace Open Q&A
      • Application Monitoring & UEM
        • AppMon & UEM Open Q&A
      • Network Application Monitoring
        • NAM Open Q&A
  • Home
  • Public Forums
  • Application Monitoring & UEM
  • AppMon & UEM Open Q&A
avatar image
Question by Jaydatt D. · Jul 07, 2012 at 09:52 AM · web performance monitoring

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]

Comment

People who like this

0 Show 0
10 |2000000 characters needed characters left characters exceeded
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

12 Replies

  • Sort: 
  • Most voted
  • Newest
  • Oldest
avatar image

Answer by Praveen P. · May 21, 2014 at 08:37 PM

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.

Comment

People who like this

0 Show 1 · Share
10 |2000000 characters needed characters left characters exceeded
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

avatar image Saad T. · Dec 15, 2014 at 03:26 PM 0
Share

Any update on this ?, still the error is reproducible 

Thanks 

avatar image

Answer by amol k. · Dec 18, 2012 at 05:04 AM

Hi Dominik,

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

Regards,
Amol

Comment

People who like this

0 Show 0 · Share
10 |2000000 characters needed characters left characters exceeded
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

avatar image

Answer by Dominik S. · Dec 17, 2012 at 10:26 AM

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.

Comment

People who like this

0 Show 0 · Share
10 |2000000 characters needed characters left characters exceeded
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

avatar image

Answer by amol k. · Dec 17, 2012 at 07:13 AM

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

Comment

People who like this

0 Show 0 · Share
10 |2000000 characters needed characters left characters exceeded
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

avatar image

Answer by Dominik S. · Dec 17, 2012 at 06:50 AM

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
Comment

People who like this

0 Show 0 · Share
10 |2000000 characters needed characters left characters exceeded
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

avatar image

Answer by amol k. · Dec 15, 2012 at 01:36 AM

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

Comment

People who like this

0 Show 0 · Share
10 |2000000 characters needed characters left characters exceeded
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

avatar image

Answer by amol k. · Dec 14, 2012 at 09:26 AM

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

Comment

People who like this

0 Show 1 · Share
10 |2000000 characters needed characters left characters exceeded
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

avatar image Andreas G. ♦ · Dec 14, 2012 at 11:02 AM 0
Share

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?

avatar image

Answer by amol k. · Sep 17, 2012 at 03:36 PM

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.

Comment

People who like this

0 Show 3 · Share
10 |2000000 characters needed characters left characters exceeded
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

avatar image Jaydatt D. · Sep 18, 2012 at 12:45 PM 0
Share

Hi All,

I am also facing same issue...
Please suggest.

Best Regards,
Jaydatt.

avatar image Andreas G. ♦ Jaydatt D. · Sep 18, 2012 at 05:19 PM 0
Share

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

avatar image Jaydatt D. Andreas G. ♦ · Sep 21, 2012 at 11:46 AM 0
Share

Hi Andi,

Thanks, it is working.

Best Regards,
Jaydatt.

avatar image

Answer by amol k. · Jul 09, 2012 at 07:39 AM

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.

Comment

People who like this

0 Show 4 · Share
10 |2000000 characters needed characters left characters exceeded
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

avatar image Andreas G. ♦ · Jul 09, 2012 at 09:00 AM 0
Share

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

avatar image Jaydatt D. Andreas G. ♦ · Jul 09, 2012 at 09:23 AM 0
Share

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.

Test.xls

avatar image Andreas G. ♦ Jaydatt D. · Jul 09, 2012 at 09:44 AM 0
Share

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

avatar image Jaydatt D. Andreas G. ♦ · Jul 09, 2012 at 09:59 AM 0
Share

thanks..

avatar image

Answer by Rob V. · Jul 07, 2012 at 02:43 PM

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

Comment

People who like this

0 Show 1 · Share
10 |2000000 characters needed characters left characters exceeded
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

avatar image Frank P. · Jul 23, 2012 at 03:30 PM 0
Share

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

  • 1
  • 2
  • ›

How to get started

First steps in the forum
Read Community User Guide
Best practices of using forum

NAM 2019 SP5 is available


Check the RHEL support added in the latest NAM service pack.

Learn more

LIVE WEBINAR

"Performance Clinic - Monitoring as a Self Service with Dynatrace"


JANUARY 15, 3:00 PM GMT / 10:00 AM ET

Register here

Follow this Question

Answers Answers and Comments

8 People are following this question.

avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image

Related Questions

Web Service metrics are not showing up for SOAP web service method calls

dynaTrace Monitor

smarter action names for BSM

Calculate % for availability

Visit dashlest not showing OSVersion correctly for Mac and Linux

Forum Tags

dotnet mobile monitoring load iis 6.5 kubernetes mainframe rest api dashboard framework 7.0 appmon 7 health monitoring adk log monitoring services auto-detection uem webserver test automation license web performance monitoring ios nam probe collector migration mq web services knowledge sharing reports window java hybris javascript appmon sensors good to know extensions search 6.3+ server documentation easytravel web dashboard kibana system profile purelytics docker splunk 6.1 process groups account 7.2 rest dynatrace saas spa guardian appmon administration production user actions postgresql upgrade oneagent measures security Dynatrace Managed transactionflow technologies diagnostics user session monitoring unique users continuous delivery sharing configuration alerting NGINX splitting business transaction client 6.3 installation database scheduler apache mobileapp RUM php dashlet azure purepath agent 7.1 appmonsaas messagebroker nodejs 6.2 android sensor performance warehouse
  • Forums
  • Public Forums
    • Community Connect
    • Dynatrace
      • Dynatrace Open Q&A
    • Application Monitoring & UEM
      • AppMon & UEM Open Q&A
    • Network Application Monitoring
      • NAM Open Q&A