Error while exporting Request Monitoring Policies in RSA Identity Governance & Lifecycle
2 years ago
Originally Published: 2018-05-23
Article Number
000041864
Applies To
RSA Product Set: RSA Identity Governance and Lifecycle
RSA Version/Condition: 7.0.2 P02

 
Issue
While Exporting Request Monitoring policies getting error "Expression is too complex for simple mode"

Below error can be seen in aveksaServer.log

 
(default task-127) [com.aveksa.server.export.ExportImportConverter] marshal
com.aveksa.server.runtime.ServerException: ExportedMonitoringPolicyConfiguration: error
at com.aveksa.server.export.proxy.ProxyObject.toServerException(ProxyObject.java:154)
at com.aveksa.server.export.proxy.ProxyObject.toServerException(ProxyObject.java:162)
at com.aveksa.server.export.proxy.ExportedMonitoringPolicyConfiguration.deNormalizeActivityFilter(ExportedMonitoringPolicyConfiguration.java:159)
at com.aveksa.server.export.proxy.ExportedMonitoringPolicyConfiguration.deNormalize(ExportedMonitoringPolicyConfiguration.java:41)
at com.aveksa.server.export.proxy.ProxyObject.marshall(ProxyObject.java:58)
at com.aveksa.server.export.ExportImportConverter.marshal(ExportImportConverter.java:74)
at com.thoughtworks.xstream.core.TreeMarshaller.convert(TreeMarshaller.java:70)
at com.thoughtworks.xstream.core.TreeMarshaller.convertAnother(TreeMarshaller.java:58)
at com.thoughtworks.xstream.core.TreeMarshaller.convertAnother(TreeMarshaller.java:43)
at com.thoughtworks.xstream.core.TreeMarshaller.start(TreeMarshaller.java:82)
at com.thoughtworks.xstream.core.AbstractTreeMarshallingStrategy.marshal(AbstractTreeMarshallingStrategy.java:37)
at com.thoughtworks.xstream.XStream.marshal(XStream.java:895)
at com.thoughtworks.xstream.XStream.marshal(XStream.java:884)

 
Cause
The above error is caused due to incorrect syntaxt in the query
 
WI."Assignee User Id" NOT IN (SELECT DISTINCT U.USER_ID FROM PV_USERS U WHERE U.USER_ID <> 'AveksaAdmin') OR WI."Assignee User Id" IS NULL

 
Resolution
Update the syntax as shown below
WI."Assignee User Id" not in ('SELECT DISTINCT USER_ID FROM PV_USERS WHERE USER_ID <> "AveksaAdmin"') OR WI."Assignee User Id" IS NULL
Or other option would be query using in ID (Note that AveksaAdmin always has an ID of zero)
WI."Assignee User Id" not in ('SELECT DISTINCT USER_ID FROM PV_USERS WHERE ID > 0') OR WI."Assignee User Id" IS NULL