Doing a data upload and I get
"CRM is unable to proceed with this data upload as the Tomcat Server appears to be stopped"
After investigating I see dashboard is working.I also tried with a simple file as this was suggested in the community.
In the ewaresystem log I see this...
Nov 21 2017 12:44:11.844 6136 5932 1 CRMOpenThreadTokenWinVistaNov 21 2017 12:44:12.893 6136 5932 1 ERROR while Data upload. HTTP status:404 Message: <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN""http://www.w3.org/TR/html4/strict.dtd"><HTML><HEAD><TITLE>Not Found</TITLE><META HTTP-EQUIV="Content-Type" Content="text/html; charset=us-ascii"></HEAD><BODY><h2>Not Found</h2><hr><p>HTTP Error 404. The requested resource is not found.</p></BODY></HTML>
Any ideas what causes this?
CRM Together - Your Sage CRM Partner
We provide Sage CRM partners and customers world-wide with the best professional services and real value added solutions that make CRM deliver
Get our Free eBook- The Business Predictability Blueprint
But what version of Sage CRM are you using?
Are you uploading from XLS or CSV?
Does the error happen all the time?
Is the Tomcat working? What errors or messages are shown in the Tomcat log?
Sage CRM 2017 R2
Yes-I just tested on our demo environment and it works find there. So it is environmental.
Is the Tomcat working?
YES - dashboards working okay
What errors or messages are shown in the Tomcat log?
-no errors. looks to be fine. the only error i see is the one in my original post "ERROR while Data upload"
Mail Merge is not working
"Mail Merge failed. Please contact your System Administrator."
actually the crm.log file has this
ERROR [http-apr-10009-exec-2]: 22-Nov-2017 10:13:10.417 org.apache.catalina.connector.ClientAbortException: java.io.IOException
This is happening within the core Tomcat webapp I think.
Quoting shamelessly from
"Most likely, your server is taking too long to respond and the client is getting bored and closing the connection.
A bit more explanation: tomcat receives a request on a connection and tries to fulfill it. Imagine this takes 3mins, now, if the client has a timeout of say 2mins, it will close the connection and when tomcat finally comes back to try to write the response, the connection is closed and it throws an org.apache.catalina.connector.ClientAbortException."
This would tend to agree with you assessment that this is an environmental issue.
I wonder if Ravi's article would add some light
It happens in a second or two though so I don't think its a timeout issue.
I tried changing some of the settings as per the document but no luck.
I suspect that there is an internal url being used (from crm to tomcat) that is not working on the server and so it thinks it doesnt exist or has stopped.
If i figure it out I will update and let you know.
Then if it is an internal URL being used I wonder if you should look to any antivirus software intercepting the request?
I'll check that. Dashboards are working though so that's confusing things.
I figured out the issue
The clue was in the 404 error
In my demo environment it was working so I looked at the logs there and when i did a mail merge in crm I saw these...
So i tried the same url on my live and got 404
So it looks like "localhost" is always used (even though the server is at crm.server.com) .
To fix I had to open IIS and in the "bindings" for the site (it was not the default site) add in a new binding for "localhost" on port 80.
Ideally I shouldn't need this but that's what sorted it.
© The Sage Group plc 2017All Rights Reserved