SAP Knowledge Base Article - Public

3303827 - Canvas advance report validation error - Failed to deserialize the xml for the query

Symptom

Canvas advance report run Validation is giving below error.
Error: Failed to deserialize the xml for the query

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

Environment

  • SAP SuccessFactors HXM Suite
    • Analytics & Reporting (Ad Hoc, YouCalc, ORD)
      • Advanced Reporting (ODS)

Reproducing the Issue

1. Run the Canvas Advance report.
2. Report gives below error.

3. Check for Validation error for the report. Locating Validation Errors in a Canvas Report | SAP Help Portal 
4. The Validation error will be as below.
"Failed to deserialize the xml for the query"

Cause

Advanced Reporting Metadata out of sync is causing the reported issue.

Resolution

Run the reporting metadata sync to resolve the issue.

2776882 - EC Advanced Reporting Metadata Sync/Reload (View Based Metadata) - SAP for Me

Keywords

failed, deserialize, xml, query, advance, report, reporting, metadata, sync, reload, validation, error, , KBA , LOD-SF-ANA-ADV , Advanced Reporting (ODS) , LOD-SF-ANA , Analytics & Reporting (Ad Hoc, YouCalc, ORD) , How To

Product

SAP SuccessFactors HXM Suite 2211

Attachments

Pasted image.png