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:
Image description
Image description
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>)