Summary:

When a user tries to export a report to Excel or CSV the following message is displayed:

Description 

Symptoms:

The following can be seen in the ewaresystem.log:

Oct 16 2014 10:21:10.343 2060 3356 5 doEndpointPost time-taken: 32ms. HTTP status code: 401
Oct 16 2014 10:21:10.359 2060 3356 1 ERROR generating excel file. Message - Error generating report. .

Cause:

The cause of this issue was that in the database the user's password was in plain text in this case 'Admin'. It should be a hashed value.

Description 

Resolution:

To resolve this you need to re-encrypt the SQL database password from plain text. There is already on an article how to do this here:

https://community.sagecrm.com/knowledgebase/w/onpremisekba/1196.632-17538-how-to-re-encrypt-the-sql-database-password-from-plain-text.aspx 

Once this is done restart tomcat and you should be able to export reports to Excel and CSV.