000031749 - 'ORA-31011: XML parsing failed and ORA-19202: Error occurred in XML processing' errors running Collections after upgrading to 6.9 or higher of RSA Identity Governance & Lifecycle

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

Article Content

Article Number000031749
Applies ToRSA Product Set:  RSA Identity Governance & Lifecycle 
RSA Version/Condition: 6.9.x, 7.x
IssuePreviously 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

CauseHTML 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.
ResolutionModify 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.
User-added image

See the RSA Identity Governance & Lifecycle Administrator's Guide for your version for more information on these settings.