Troubleshooting XML Masking Failures with Error XML-20100 in Test Data Manager (TDM)

Products

• CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

When running a masking job (FDM) in Test Data Manager, the process fails with an XML parsing error, typically reported in the logs as XML-20100: (Fatal Error) Expected 'EOF'.

This indicates that the XML parser encountered invalid or malformed XML data within the database column, preventing successful masking.

Environment

• Product: CA Test Data Manager (TDM / FDM)
• Database: DB2 (applicable to other databases)

Cause

The XML content being masked is malformed or invalid (e.g., incomplete tags, invalid syntax). By default, TDM logging levels may not provide sufficient visibility into which specific record or row contains the invalid data.

Resolution

To identify the specific rows causing the failure, increase the diagnostic detail in your masking configuration:

1. Enable Diagnostic Logging:

   • Update your masking configuration file.
   • Set the property DIAGLEVEL=2.

2. Analyze the Logs:

   • Rerun the masking job.
   • Check the FDM masking logs (e.g., masking.log).
   • Search for XML-20100. The log will now provide additional context to identify the specific table and column containing the malformed data.

3. Data Remediation:

   • Once the specific row/record is identified:
     • Option A: Correct the XML data directly in the source database.
     • Option B: Exclude the identified problematic rows from the masking scope using a filter.

4. Verification:

   • Rerun the masking job after the data or filter has been applied to confirm successful completion.