Varies, generally displays an error message about incorrect statement or column name.
Line breaks are removed from the query.
This issue is fixed in Workflow 8.5 RU1 and ServiceDesk 8.5 RU1.
To work around the issue, please make sure every line in the query has a space in the end. This way, when line breaks get removed there is still a space there.
Note that once you have run into this issue, IIS may need to be restarted to get the report out of non-working state even after report has the spaces added. This is because parameters state for a report is cached.
Modifying parameters in runtime for 'Sql Query with Paramaters' will remove line breaks from query.
Subscribing will provide email updates when this Article is updated. Login is required.