000033073 - A "Caught SQLException: ORA-00904: "STATE": invalid identifier" error in RSA Via Lifecycle and Governance occurs when a report is run

Document created by RSA Customer Support Employee on Jun 14, 2016Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 3Show Document
  • View in full screen mode

Article Content

Article Number000033073
Applies ToRSA Product Set: Via Lifecycle and Governance
RSA Version/Condition: 7.0, 6.9, 6.8
Platform: Wildfly
, WebSphere, Weblogic
IssueWhen 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:
User-added image
User-added image
ResolutionThis issue has been reproduced in house and currently being investigated by the Engineering team in order to resolve in a future release.
WorkaroundIn 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>)

Outcomes