Email Report - Not Working

[laurin1]

This seems to work for some reports, and not for others. I have a report that I can run right now that returns 48 results, but if I click Mail selected reports now, the report is not sent.

[Hemoco]

laurin1 wrote:
This seems to work for some reports, and not for others. I have a report that I can run right now that returns 48 results, but if I click Mail selected reports now, the report is not sent.

One calculated field in the report syntax didn’t have an alias.

The e-mail wraps some extra sql code around the report to calculate the total records
commandText = "select count(*) as total from (" + originalquery + ") tmptable";

This is why the report did run, but was not sent using e-mail alerts.

[laurin1]

I am sending that now. I looked at the log and I can see an error for the problem report. However, that report runs from the UI - why does it only fail when run as an email alert.

[Hemoco]

Could you do the following to help us troubleshoot:
• Stop the Lansweeper service.
• Delete the Errorlog.txt found in Program Files\Lansweeper\Service.
• In the Lansweeperservice.exe.config file set debug to “1”. You can find this file in Program Files\Lansweeper\Service.
• Restart the Lansweeper service.
• Let the Lansweeper service run for a while, click on "mail now" and then e-mail us (support@lansweeper.com) the new Errorlog.txt that was generated.