Previously working collectors fail after upgrading to 6.9 or higher of RSA Identity Governance & Lifecycle. The Oracle alert log (/u01/app/oracle/diag/rdbms/avdb/AVDB/trace/alert_AVDB.log) reports the following error:
ORA-31011: XML parsing failed
ORA-19202: Error occurred in XML processing
LPX-00210: expected '<' instead of 'M'
Error at line 1
ORA-06512: at "SYS.XMLTYPE", line 0
ORA-06512: at line 1 Caused By Stack com.aveksa.sdk.collector.CollectionException
HTML or XML text used in a collector query is being deleted, truncated, or otherwise changed.
Due to a new security enhancement in 6.9, a query from a version before 6.9.1 that contains markup or scripting language may have that language stripped during the migration or when a collector is subsequently edited or modified. The new security feature limits the allowable markup and scripting that can be used in collector queries.
Modify the collector query to conform with the Security definitions for XSS/Scripting defined under Admin > System > Security. Although these settings are configurable, due to security enhancements, they are more restrictive than was previously allowed.