SAP error validating source XML against schema – Invalid child element

Symptom

At task runtime, the step fails with error:

Error validating source XML against schema - The element 'ELEMENT_NAME' has invalid child element ‘ELEMENT_NAME'

Cause

The error is caused by an invalid schema from the input data source, i.e. the Database Query step will be the input data source.

Solution

To resolve the error, open the Database Query step and make a minor change, for example, key in a line break or a space character. When you click OK to save the change you will get a prompt to “execute this new query to read the new schematics?” Click yes to accept the prompt.