Troubleshooting Informatica Error Messages and Resolution – Part 452

SQLServerF1_Header_Small

XMLW_31093Error: Encountered an error while establishing type hierarchical relationship.
Cause:The session could not process XML data for a child view because there is no data for the parent view.
Action:Check the data for inconsistencies, or change the mapping.
XMLW_31108Error: An appropriate start row was not found for XML root group <group name> with circular reference. No output was generated.
Cause:If the data has multiple root rows with circular references, but none of the root rows has a null foreign key, the Integration Service cannot find a start row.
Action:Verify the source data has one row going to the root that is not a child of another group.

XMLW_31110Error: Duplicate row detected for single occurring group <group>, with parent group <parent group>.
Cause:The Integration Service detected a duplicate row in a group during the session.
Action:To avoid failing the session for duplicate rows, set the Duplicate Row Handling session property to First Row or Last Row for the target.
XMLW_31118 Error: The FK field <foreign key> for the XML derived group <group name> in XML Target <target name> is not projected. No output rows for the group can be generated due to missing base type information.
Cause:The session failed because the foreign key in a derived XML group has no data.
Action:Add a link to the foreign key in the mapping.

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

<strong>What are Informatica Error Messages?</strong>

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,
<strong>SQLServerF1 Team</strong>
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 *