x Want to participate? Join the group to interact
Ravinder
Related
Recommended

Unable to proceed with Data Upload and Exporting reports to Excel or CSV

1 minute read time.

The Data Upload function in Sage CRM is delivered via Apache Tomcat.

Generally, if your dashboards are working you would expect once the file has been uploaded to Sage CRM server from Data Upload screen (Step 1 of Data Upload process), you will be directed to the Configure Data Mapping screen which is step 2 of the Data Upload process. However, in certain cases instead of being directed to the Configure Data Mapping Screen, users have reported getting the error shown below on the screen.

In this instance the EwareSystem.log would show below error


Whereas, when trying to export a report to excel or CSV you will get below error in EwareSystem.log

Examine the value for the "Report generator maximum memory (MB):" parameter under Administration -> E-mail and Documents -> Documents & Reports Configuration. This parameter might have been set to 1024 MB by default on a new install or higher in certain cases by admin users as part of troubleshooting above issue. Setting this to 512 or 256 will fix this issue.

Whether you are then trying to export to excel or CSV and trying to perform a Data upload — both issues will be fixed. In case this doesn't get fixed after changing above parameter value restart Tomcat but restart is not needed on Sage CRM 2017 installs.

The cause of the issue is that every export to excel or data upload request that is received by Sage CRM, Sage CRM then tries to reserve an amount of memory in this parameter on top of the Sage CRM Tomcat service start up memory for the JVM heap. But the server may run out of space or a defragmented JVM heap cannot get contiguous memory locations - This may be common where application server is hosting other applications as well as Sage CRM. Or there could also be an issue where the SQL server is consuming more memory. This is discussed in more details in this article. Hence this issue would only appear when exporting reports to excel/CSV or Data upload.

Parents

  • OK so after doing some more investigation I figured out the issue and the solution. The problem was caused by having a Http to https rule enabled to force all http traffic to be redirected to https automatically. After switching this off I noticed in the log files that when doing an export a http://localhost call was being made which most likely would have been blocked when using the https url. So using the "Custom server name for internal reqs" found in System Behaviour, I changed this to be my fully qualified https dns name, switched on my http to https rule and everthing worked.

    I hope this helps someone.

Comment

  • OK so after doing some more investigation I figured out the issue and the solution. The problem was caused by having a Http to https rule enabled to force all http traffic to be redirected to https automatically. After switching this off I noticed in the log files that when doing an export a http://localhost call was being made which most likely would have been blocked when using the https url. So using the "Custom server name for internal reqs" found in System Behaviour, I changed this to be my fully qualified https dns name, switched on my http to https rule and everthing worked.

    I hope this helps someone.

Children
No Data
Generic Content
Generic Content

*Community Hub is the new name for Sage City