|Applies To||RSA Product Set: RSA Via Lifecycle and Governance (RSA Via L&G)|
RSA Version/Condition: 6.9.1 P14, 7.0 P03, 7.0.1
|Issue||When attempting to edit the WHERE clause of a Membership Rule for a Role in RSA Via Lifecycle and Governance the error message is displayed and the SQL statement cannot be saved:|
|Cause||This issue was introduced in RSA Via Lifecycle and Governance in the following patches/versions:|
|Resolution||This issue is resolved in:|
|Workaround||The issue does not occur for simple queries, or advanced queries that only contain a single SQL element. Try and simplify the SQL so that it does not use SQL OR or AND in the statement.|
The issue only prevents editing and saving the SQL statement. Existing complex SQL statements are still valid as long as they are not edited. Avoid making edits to membership rules, or edit the rules in an earlier (or later) patch level of RSA Via Lifecycle and Governance and use the Import/Export function to import a working rule into the problem version.