Troubleshooting Informatica Error Messages and Resolution – Part 151

SQLServerF1

HIER_28004XML Reader Error: <error text>.
Cause:This is a generic error.
Action:Check the session log for related error messages.

HIER_28020DTM buffer block is filled, and we can’t send the block yet. Need to use heap memory to hold data.
Cause:In the XML file, leaf elements appear after multiple-occurring enclosure elements of a parent element. The memory block for the multiple-occurring enclosure elements is filled.
Action:Restructure the file so that all of the leaf elements of a parent element appear before the multiple-occurring enclosure elements.
HIER_28028Fatal Error: Could not allocate memory from heap.
Cause:In the XML file, leaf elements appear after multiple-occurring enclosure elements of a parent element. The Integration Service has now run out of heap memory.
Action:Restructure the file so that all of the leaf elements of a parent element appear before the multiple-occurring enclosure elements.
HIER_28031There are two fields pointing to the same XML node, but the datatypes and lengths do not match.
Cause:The Source Qualifier transformation contains different ports based on the same XML element. The datatypes or lengths for these ports are different.
Action:Check the Source Qualifier transformation and make sure the datatypes and lengths for all occurrences of the element match.

HIER_28032Error: There are no fields in any of the groups defined that have a reference to a node in the XML tree.
Cause:The XML map for an element in the XML file is blank.
Action:Contact Informatica Technical Support.
HIER_28034Could not retrieve a block from the DTM.
Cause:The reader thread could not retrieve a block of memory from the DTM buffer pool.
Action:Contact Informatica Technical Support.
HIER_28041Couldn’t open indirect file <file name>.
Cause:You set up the session to read from a file list. The Integration Service could not open the specified file list.
Action:Make sure the file exists in the specified directory, check the permissions on the file and directory, and then rerun the session.

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 *