CRM is unable to proceed with this data upload as the Tomcat Server appears to be stopped - ERROR while Data upload

This question is not answered

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    CRMOpenThreadTokenWinVista
Nov 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

Facebook:  http://www.facebook.com/CRMTogether

Twitter: @crmtogether

Get our Free eBook- The Business Predictability Blueprint

https://crmtogether.com/guides/business-predictability-blueprint/

 

All Replies
  • Hello

    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?


  • Hi Jeff,

    But what version of Sage CRM are you using?

    Sage CRM 2017 R2

    Are you uploading from XLS or CSV?

    CSV

    Does the error happen all the time?  

    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"

    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

    Facebook:  http://www.facebook.com/CRMTogether

    Twitter: @crmtogether

    Get our Free eBook- The Business Predictability Blueprint

    https://crmtogether.com/guides/business-predictability-blueprint/

     

  • Mail Merge is not working

    "Mail Merge failed. Please contact your System Administrator."

    actually the crm.log file has this

    java.io.IOException

    ----

    ERROR [http-apr-10009-exec-2]: 22-Nov-2017 10:13:10.417 org.apache.catalina.connector.ClientAbortException: java.io.IOException

    org.apache.catalina.connector.ClientAbortException: java.io.IOException

    at org.apache.catalina.connector.OutputBuffer.doFlush(OutputBuffer.java:367)

    at org.apache.catalina.connector.OutputBuffer.flush(OutputBuffer.java:331)

    at org.apache.catalina.connector.CoyoteOutputStream.flush(CoyoteOutputStream.java:101)

    at org.springframework.security.web.util.OnCommittedResponseWrapper$SaveContextServletOutputStream.flush(OnCommittedResponseWrapper.java:513)

    at org.springframework.security.web.util.OnCommittedResponseWrapper$SaveContextServletOutputStream.flush(OnCommittedResponseWrapper.java:513)

    at com.fasterxml.jackson.core.json.UTF8JsonGenerator.flush(UTF8JsonGenerator.java:1037)

    at com.fasterxml.jackson.databind.ObjectWriter.writeValue(ObjectWriter.java:607)

    at org.springframework.http.converter.json.AbstractJackson2HttpMessageConverter.writeInternal(AbstractJackson2HttpMessageConverter.java:266)

    at org.springframework.http.converter.AbstractGenericHttpMessageConverter.write(AbstractGenericHttpMessageConverter.java:100)

    at org.springframework.web.servlet.mvc.method.annotation.AbstractMessageConverterMethodProcessor.writeWithMessageConverters

    ....

    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

    Facebook:  http://www.facebook.com/CRMTogether

    Twitter: @crmtogether

    Get our Free eBook- The Business Predictability Blueprint

    https://crmtogether.com/guides/business-predictability-blueprint/

     

  • Hello

    This is happening within the core Tomcat webapp I think.

    Quoting shamelessly from

    stackoverflow.com/.../org-apache-catalina-connector-clientabortexception-java-io-ioexception-apr-err

    "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

    community.sagecrm.com/.../unable-to-proceed-with-data-upload-and-export-reports-to-excel-or-csv.aspx


  • Hi Jeff,

     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.

    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

    Facebook:  http://www.facebook.com/CRMTogether

    Twitter: @crmtogether

    Get our Free eBook- The Business Predictability Blueprint

    https://crmtogether.com/guides/business-predictability-blueprint/

     

  • 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.

    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

    Facebook:  http://www.facebook.com/CRMTogether

    Twitter: @crmtogether

    Get our Free eBook- The Business Predictability Blueprint

    https://crmtogether.com/guides/business-predictability-blueprint/

     

  • 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...

    http://localhost/sdata/crmj/async/mailMergeTask?trackingId=2398DC30-2BA3-4117-9D19-fsdfsdfds

    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.

    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

    Facebook:  http://www.facebook.com/CRMTogether

    Twitter: @crmtogether

    Get our Free eBook- The Business Predictability Blueprint

    https://crmtogether.com/guides/business-predictability-blueprint/