ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Cube processing failures on XML parsing errors

book

Article ID: 227948

calendar_today

Updated On:

Products

IT Analytics

Issue/Introduction

Cube processing fails and returns either of the the following errors:
Error: OLE DB error: OLE DB or ODBC error: XML parsing: line 1, character 26, illegal xml character; 42000. Errors in the OLAP storage engine: An error occurred while the dimension with the ID of 'DLP Condition Change Audit', Name of 'DLP Condition Change Audit' was being processed.
<Error ErrorCode="3238395904" Description="OLE DB error: OLE DB or ODBC error: XML parsing: line 111, character 348, undeclared prefix; 42000." Source="Microsoft Analysis Services" HelpFile="" />
Additional errors may follow:
Server: The current operation was cancelled because another operation in the transaction failed. OLE DB error: OLE DB or ODBC error: Operation canceled; HY008.

Cause

The first error is caused by SQL Server failing to parse a vertical tab character that is present in the XML of one or more policy condition keywords in the Symantec DLP database.

The second error is caused by the presence of the following string in one or more policy condition keywords in the Symantec DLP database:

' xsi:nil="true"'

Environment

Release : 2.9.1

Component : Cubes

Resolution

Please contact Broadcom support for assistance with these errors.

Attachments