Tomcat: Crashes while Running a Report

This requires being connected to your server.

Problem:

Tomcat crashes every time a particularly large report is run from a chart inside iDashboards. Specifically, the chart loads fine but when the report is requested, the new browser window opens and seems like it times out after waiting for quite some time. Then a generic unable to complete the request message appears.

Information: 

The SQL Server data source that this chart is pulling data from is not having any connection problems. Even adding a validation query does not resolve the issue. The SQL data that is being requested in the report is coming from a very large chart data set. One odd observation is that for this particular issue, when Tomcat crashes, it does not log any errors anywhere, even in the Windows Event Viewer.

Resolution:

Increase the max heap size to 1024MB. After this, the report started working. Depending on your Java version you may need to upgrade the JDK to 1.8 or the most recent version.

• Right click on the Apache Tomcat system tray icon
• Run TomcatXw.exe or idashboardsw.exe 
• Select Java
• In Maximum Memory Pool: 1024
• Click Apply
• Click OK
• Restart the Tomcat/iDashboards Service (iDashboardsSRV)

OR In Administrative Command Prompt:

• cd C:\Program Files\iDashboards_SRV\Server\bin
  
  • Then Enter
  • idashboardsw //ES//iDashboardsSRV
  • Then Enter
• Select Java
• In Maximum Memory Pool: 1024
• Click Apply
• Click OK
• Restart the Tomcat/iDashboards Service (iDashboardsSRV)

If the above is unable to resolve the issue, then please contact iDashboards Support for further assistance.