Error Running a Report: "Database error due to invalid SQL statement"

Issue Symptoms

Running a report returns: Let's try that again. Database error due to invalid SQL statement. (RequestID: 579a37f700207ab260c64504746550d3)


Using filters in the report that have special characters, such as a % sign.
This can also happen in a Task view that has a filter selected also using special characters.

Cause & Resolution

Edit the Report > Filters tab.

Look for any filters that may have special characters.

For example:

Task>>Percent Complete --Less Than-- 100% remove the % sign from the filter Task>>Percent Complete --Less Than-- 100 Save + Close the report.

This has been fixed and deployed.

This article last updated on 2017-11-10 20:21:03 UTC