x Want to participate? Join the group to interact
Conrad Roux
Related
Recommended

Tomcat Troubleshooting Guide for Sage CRM - updated 2020

1 minute read time.

Apache Tomcat is a service that Sage CRM uses to perform functions that handles features in the core app of CRM. Apache Tomcat handles the redirects into CRM from the sdata sub-domain. These redirects are functions like the dashboard, calendar, exporting files and uploads. When the dashboard does not work, it might be an indication that the Tomcat service is having trouble in the back end and needs to be looked at.



When you get the dreaded "The Dashboard has experienced a problem. Please contact your System Administrator". It should not be a doom and gloom affair; it can normally be corrected with just a few steps and basic checks. 

Before doing any of these steps, you can check your Tomcat health status under the menu in CRM, Administration->System->System Health. This should show you if something is wrong with Tomcat and other CRM functions.

Here are my steps to diagnose Tomcat for Sage CRM

  1. Verify the logs. This is the first place you should start.
  2. Verify to see if the service is running.
  3. Verify if Tomcat is connecting to your SQL database.
  4. Verify your redirection ports in IIS.
  5. Verify your SDATA handler mapping and authorization.
  6. Advanced section.

For more logging and debugging, see the Advanced section, numbers 3,4,5. This will give more technical info on the debugging process or finding failed requests.

Let's look at each of these steps now.

Parents

  • Thanks Conrad for this article.  I just did a fresh install of CRM 2020 R2 on a windows 2019 OS with Sage 300 2021.1 and I ran into the dreaded dashboard not working error in CRM.  Looking at the catalina log file I found that Tomcat was shutting down because it was trying to configure port 10101 as its server shutdown port but the Sage.CNS.WindowsService was already listening on that port.  I manually modified the server.xml file in the tomcat/conf folder to use 10109 instead and that solved my immediate problem but it seems odd that two Sage installed programs would try to use the same port.

Comment

  • Thanks Conrad for this article.  I just did a fresh install of CRM 2020 R2 on a windows 2019 OS with Sage 300 2021.1 and I ran into the dreaded dashboard not working error in CRM.  Looking at the catalina log file I found that Tomcat was shutting down because it was trying to configure port 10101 as its server shutdown port but the Sage.CNS.WindowsService was already listening on that port.  I manually modified the server.xml file in the tomcat/conf folder to use 10109 instead and that solved my immediate problem but it seems odd that two Sage installed programs would try to use the same port.

Children
No Data
Generic Content
Generic Content

*Community Hub is the new name for Sage City