Troubleshooting Informatica Error Messages and Resolution – Part 152

HIER_28043Reader failure: The node <element name> occurs multiple times. This node was marked in the schema as occurring one or less times.
Cause:You imported a source in the Designer based on an XML file. In the source qualifier, the Designer marked one of the elements as a single-occurring element. When you used this source in a mapping, the imported XML file contained the element multiple times.
Action:Recreate the XML Source Qualifier transformation using a more accurate XML file.

HIER_28044Reader failure: The root node for the given XML does not match the root node in the repository.
Cause:You imported a source in the Designer based on an XML file. The Designer determined the root element based on this file and stored it in the repository. When you used this source in a mapping, the imported XML file contained a different root element.
Action:Check the XML file and then import it again.
HIER_28045Out of range error: <element name>.
Cause:The element stored in the repository is a decimal number with a specific precision and range. The precision for the element in the XML file does not match the precision stored in the repository.
Action:Check the precision for the element, and then import the XML file again.

HIER_28051Read invalid number <value> for XML path <path name>.
Cause:The Integration Service failed to read a value from an XML file because the datatype defined in the XML source definition does not match the datatype in the XML file.
Action:Verify that the datatype defined in the XML source definition matches the datatype in the XML file.

Above are list of Informatica Error Messages or Warnings received while performing certain operation against Informatica related products.

What are Informatica Error Messages?

Informatica error codes are a set of error codes for use by all Informatica products. Every Informatica error message returned by Informatica, is self explanatory and contains the object name in cases where required.

Hope this was helpful.

Thanks,
SQLServerF1 Team
Information about Informatica Error Code Messages or Warning Messages on Windows and Linux Operating Systems.

 

Leave a Reply

Your email address will not be published. Required fields are marked *