Restricted characters in Admin Console's SQL Console

Certain characters in Assure's, Insight's, Perceive's and ER's SQL Console, located within their Admin Consoles, will throw the error below:

#UUIP002: An invalid HTTP request parameter value was detected for parameter sqlStatement in the incoming request.

This error is thrown then an invalid character is present within the SQL query. The most common characters causing this issue is a tab, < and >. While used for less than and greater than operators, these symbols are restricted to prevent code injection.

With the exception of null (x00) and new line characters (x0A and x0D), all other control characters, including tabs (x09), will throw this error.

This error can be bypassed by removing the problematic control characters from the SQL query. 

Note: older versions of Assure, such as version 8.3, do not have these security checks.