Troubleshooting Informatica Error Messages and Resolution – Part 451

SQLServerF1_Header_Small

XMLW_31079Error: Unknown On Commit attribute value in target <target name>. Check repository for possible corruption.
Cause:You are using an upgraded XML session that uses the Output XML on Flush/Commit attribute. PowerCenter no longer supports this option.
Action:Open the mapping. Edit the XML target instance. Clear the Output XML on Flush/Commit option. Choose the Create New Document option for the On Commit property.
XMLW_31080Error: Orphans were encountered.
Cause:The Integration Service encountered child rows that have no parents in the XML Generator transformation.
Action:To avoid failing a session with orphan rows, set the Orphan Row Handling session property to “Ignore.” The Integration Service ignores the orphan rows during the session.
XMLW_31086Row <row number> in XML group <group name> has more than one non-NULL hierarchical foreign key value. This row will be dropped.
Cause:When a row has two possible parents, one of the foreign keys in the row must be NULL.
Action:None.

XMLW_31089Error: The cache size <cache size> specified for XML target <target name> exceeds the 32-bit address space. It cannot be more than <cache size> on a 32-bit server.
Cause:The Integration Service uses a data cache to store XML row data while it generates an XML document. The cache size is the sum of all the groups in the XML target instance. The XML target cache is too large.
Action:Reduce the target cache size in the XML target properties.
XMLW_31090Unable to create index file <file name>.
Cause:The Integration Service failed to create the cache index for the XML cache.
Action:Check the file write permissions, the directory path, disk space. Check previous error messages for more information.

XMLW_31091Error: Index file operation error <error number>.
Cause:The Integration Service failed to write the cache index for the XML cache.
Action:Check the file write permissions, the directory path, disk space. Check previous error messages for more information.
XMLW_31092Error: Encountered an error while generating the XML document.
Cause:The XML Writer failed to write data to a target file.
Action:Check file write permissions, disk space, and that the path to the file exists. Check other error messages for more information.

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 *