Article Number | 000033073 |
Applies To | RSA Product Set: Via Lifecycle and Governance RSA Version/Condition: 7.0, 6.9, 6.8 Platform: Wildfly, WebSphere, Weblogic |
Issue | When editing the Optional Filters on the Filter Criteria tab of a report, if a filter is created that is not valid, an Oracle error is thrown when trying to run the report. An example of an invalid filter would be a single line filter that includes either an AND or an OR operator on the end, as in the example below:

 |
Resolution | This issue has been reproduced in house and currently being investigated by the Engineering team in order to resolve in a future release. |
Workaround | In most scenarios altering the query shown below resolves the error and allows the report to run, but it is not consistent in every use case.
SELECT * FROM (<original query>) |