Tomcat crashes every time a particular large report is run from a chart inside iDashboards User App. Specifically, the chart loads fine but when the report is requested, the new IE window opens and seems like it times out after waiting for quite some time. Then a generic unable to complete the request message appears.
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 crashed, it did not log any errors anywhere, even in the Windows Event Viewer.
Increase the max heap size to 1024MB. After this, the report started working. Depending on the Java version you may need to upgrade the JDK to the most recent version. Note: Java 8 will no longer support ODBC connection so upgrading to Java 8 will break the Excel and Access functionality.
- X Platform
- Enterprise Suite