A "Caught SQLException: ORA-00904: "STATE": invalid identifier" error in RSA Via Lifecycle and Governance occurs when a report is run
RSA Product Set: Via Lifecycle and Governance RSA Version/Condition: 7.0, 6.9, 6.8 Platform: Wildfly, WebSphere, Weblogic
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:
This issue has been reproduced in house and currently being investigated by the Engineering team in order to resolve in a future release.
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.