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



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


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.



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: 

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