Troubleshooting Informatica Error Messages and Resolution – Part 452

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.

 

Troubleshooting Informatica Error Messages and Resolution – Part 451

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.

 

Troubleshooting Informatica Error Messages and Resolution – Part 450

XMLW_31061Fatal error <error number> occurred while closing XML document <target name>.
Cause:The XML Writer could not close the XML target file. The file might not have write permissions or the path to the file is incorrect.
Action:Check previous error messages for more information.
XMLW_31063Fatal error <error number> occurred while opening file list <target>.
Cause:The XML Writer failed to open the file list. The file might not have write permissions or the path to the file is incorrect.
Action:Check the file write permissions, the directory path, disk space, or if the file exists.

XMLW_31064Fatal error transferring local file <file name> into remote location <path> using FTP. The file list will not be produced.
Cause:The Integration Service could not transfer the XML file by FTP to produce a file list at the remote location.
Action:Verify FTP permissions, the directory path, network connections, and that the FTP server is running.
XMLW_31065Fatal error <error number> opening an FTP connection for a file list <file name>.
Cause:The Integration Service failed to open an FTP connection for a source using a file list.
Action:Verify FTP permissions, the directory path, network connections, and that the FTP server is running. Check other error messages for more information.

XMLW_31066Fatal error <error number> while generating file list.
Cause:The Integration Service failed to generate a file list. The file might not have write permissions or the path to the file is incorrect.
Action:Check the file write permissions, the directory path, disk space, or if the file exists. Check previous error messages for more information.
XMLW_31078Error: ‘Output XML on Flush/Commit’ option for the MQ session is no longer supported. Open this mapping in the designer and edit the XML target instance. Change the value of ‘On Commit’ property to ‘Create New Document’.
Cause:You are using an upgraded MQ 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.

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.

 

Troubleshooting Informatica Error Messages and Resolution – Part 449

XMLW_31041FK of the group <group name> and PK of the parent group <group name> should both either have an input field or not.
Cause:Internal error. If you connect the Primary Key of the root group, then the Foreign Key of all the immediate child groups must be connected, unless the child group fields do not have input values. If the Primary Key is not connected, none of the fields may be connected.
Action:Validate the mapping and run the session again. Or contact Informatica Technical Support.

XMLW_31043FK is the only projected field from group <group name>.
Cause:You are running a session against a mapping with an XML target. The foreign key in the named group is the only projected field in that group.
Action:Edit the mapping to project additional fields into the named group.
XMLW_31047MQ error occurred while flushing XML output.
Cause:The Integration Service could process XML data from the MQSeries queue.
Action:Verify that the MQSeries environment settings are correct, that the queue you specified in the queue connection properties exists, and that the connection properties are valid.
XMLW_31056Fatal error opening MQ Series queue <queue> for XML output.
Cause:The Integration Service could not open the MQSeries queue.
Action:Verify that the MQSeries environment settings are correct, that the queue you specified in the queue connection properties exists, and that the connection properties are valid.

XMLW_31059 Fatal error returned while closing XML document <target name> after incremental flush/commit.
Cause:The Integration Server could not close the XML target file. The file might not have write permissions or the path to the file is incorrect.
Action:Check previous error messages for more information.
XMLW_31060Fatal error <error number> occurred while flushing XML output <target name>.
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.

 

Troubleshooting Informatica Error Messages and Resolution – Part 448

SQLServerF1

XMLW_31023Error initializing XML DOM object.
Cause:Internal error.
Action:Contact Informatica Technical Support.
XMLW_31024Error FTP-ing staged file for XML target <target instance>.
Cause:The Integration Service could not transfer the XML file by FTP.
Action:Verify FTP permissions, directory path, network connection, and that the FTP server is running. Run the session again.

XMLW_31026Fatal error opening file <file name> for XML output.
Cause:The XML Writer failed to open the file. Some reasons could be that the file did not have write permissions. The path to the file is incorrect.
Action:Check file write permissions, directory path, disk space, and that the file exists.
XMLW_31027Fatal error closing XML output file <file name>. System error message is <message>.
Cause:The XML Writer could not close the XML output file. Some reasons could be that the file did not have write permissions. The path to the file is incorrect.
Action:Check the operating system message for more information.
XMLW_31029Cannot locate XML init/deinit functions in the DLL <.dll file name>.
Cause:The XML .dll file does not contain the initialization and deinitialization functions.
Action:Verify that the .dll file is the correct file shipped with the product. If it is incorrect, contact Informatica Technical Support.

XMLW_31030FK field <field name> for group <group name> has to be projected, i.e. there has to be an input field for it.
Cause:The foreign key must be connected in the mapping.
Action:Check that the mapping and that the foreign key are connected. Contact Informatica Technical Support.
or
Cause:The target is not defined as a flat file or XML target. It is an undefined object.
Action:Contact Informatica Technical Support.
XMLW_31040Field <field name> of the *ROOT* XML group <group name> is projected while the PK field is not.
Cause:Internal error. If the Primary Key is not connected, none of the fields must be connected. If the Primary Key is connected, other fields may be connected.
Action:Validate the mapping and run the session again. Or contact Informatica Technical Support.

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.

 

Troubleshooting Informatica Error Messages and Resolution – Part 447

SQLServerF1

XMLW_31016Unknown error generating the output XML text.
Cause:The Integration Service encountered an error while trying to generate XML output.
Action:Run the Debugger to check the data. Contact Informatica Technical Support.
XMLW_31017The mapping text <mapping text> for field <field name> of the XML target <target instance> is not valid for target’s code page <code page>. Failed character code is <character number in Unicode>.
Cause:At initialization time, the Integration Service found that the text in the mapping is not in the target code page.
Action:Check that the XML mapping is compatible with the target code page.

XMLW_31018Unexpected error occurred while initializing the XML output generator.
Cause:Internal error.
Action:Contact Informatica Technical Support.
XMLW_31019Error initializing output file for XML target <target name>.
Cause:The XML Writer failed to create an output file.
Action:Check that the path to the output file exists and is accurate. Verify the disk space is sufficient. Verify write permissions to the output file.
XMLW_31020Cannot find an XML group for the incoming block of rows. Fatal error.
Cause:The XML Writer cannot find the appropriate group corresponding to the block of data.
Action:Run the session again. If it fails, contact Informatica Technical Support.

XMLW_31021Error occurred while processing EOF for the XML target <target instance> group <group name>.
Cause:The XML Writer encountered errors when processing the end of file (EOF) for the group.
Action:Contact Informatica Technical Support.
XMLW_31022Fatal error while flushing to file <file name>. System error message is <message>.
Cause:When writing to file, the XML Writer failed with the operating system message.
Action:Check file write permissions, disk space, and that the path to the file exists. Check the operating system error message and contact your system administrator.

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.

 

Troubleshooting Informatica Error Messages and Resolution – Part 446

SQLServerF1

XMLW_31008Row# <row number> has a NULL FK value for NOT TOPMOST XML group <group name>.
Cause:The foreign key is null and cannot find the parent row. The child group rows must attach to the parent group by primary-foreign key relationships.
Action:Check the data and the mapping for inconsistencies. Run the Debugger.
XMLW_31009Unexpected error processing schema definition <schema definition>.
Cause:When the Integration Service attempted to recreate the XML target definition structure from the metadata, it encountered an error while parsing.
Action:Contact Informatica Technical Support.

XMLW_31010Unexpected error occurred while trying to set the value of the element <XML element> with XML mapping <XML Map> to <value>.
Cause:Internal error. You tried to set a value for the element. Some reasons might be that the value is incorrect or the process ran out of memory.
Action:Contact Informatica Technical Support.
XMLW_31011An error occurred while trying to convert the data for field <field name> repository ID <ID number> of the row <row number> to text.
Cause:The XML Writer failed to convert the data into text.
Action:Check previous messages in the log for more information. Then contact Informatica Technical Support.
XMLW_31012Cannot register XML group <group name> for target <target instance> – no corresponding group definition found in the target.
Cause:Internal error. The target requested a group that does not exist.
Action:Contact Informatica Technical Support.

XMLW_31013Unknown (or illegal) attribute value <value> for attribute <attribute name>. Check repository for possible data corruption.
Cause:Neither the first nor the last values were saved in the repository due to repository inconsistencies.
Action:Contact Informatica Technical Support.
XMLW_31014Unexpected error while generating XML text for the row being removed from the DOM tree. Row’s PK value is <value>.
Cause:The XML writer encountered errors while generating code for values.
Action:Run the Debugger to check the data for inconsistencies. Contact Informatica Technical Support.

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.

 

Troubleshooting Informatica Error Messages and Resolution – Part 445

SQLServerF1

XMLW_31001An error occurred while trying to initialize XML environment.
Cause:The function that initializes the XML environment returned a failure code.
Action:Verify the XML environment is set up correctly, such as the environment variables are set properly, the .dll files are in the correct location on Windows or the shared libraries on UNIX, and the supporting .dat files are present.

XMLW_31002An error occurred while trying to initialize XML manager.
Cause:The Integration Service failed to create and initialize objects.
Action:See the previous error message for the reasons for the failure.
XMLW_31003An error occurred while trying to uninitialize XML environment.
Cause:The Integration Service failed to deinitialize the XML environment.
Action:See the previous error message for the reasons for the failure.
XMLW_31004The field <field name> with repository ID <ID number> should not belong to XML group <group number> named <group name>.
Cause:The set of fields that belong to the XML group in the message is in an incorrect group.
Action:Check the target definition in the Designer to verify the position of the fields belonging to the group. Or contact Informatica Technical Support.
XMLW_31005XML group <group name> does not have any fields.
Cause:Every XML group must have at least one field. The repository has inconsistencies.
Action:Import the target in the Warehouse Designer again. Or, contact Informatica Technical Support.

XMLW_31006There already was a row inserted into output for the topmost group. Rejecting the row# <row number>.
Cause:The topmost group must have only one row of data since the XML file can have only one root.
Action:Make sure that the data to this group is limited to one row.
XMLW_31007Row# <row number> has a NULL PK value for XML group <group name>.
Cause:The XML Writer received data for a primary key that is null.
Action:The primary key cannot be null. Check the data and the mapping for inconsistencies. Run the Debugger.

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.

 

Troubleshooting Informatica Error Messages and Resolution – Part 444

SQLServerF1

WSP_36006Writer target <target name> group <target group> partition <partition number> failed to process end of file.
Cause:The Web Services Provider Writer for XML encountered an error processing the end of file (EOF) for the target group.
Action:Check the session log for additional messages.

WSP_36007Writer target <target name> group <target group> partition <partition number> failed to process end of XML.
Cause:The Web Services Provider Writer for XML failed to send the XML message to the Web Services Hub.
Action:Check the session log for additional messages.

WSP_36008Invalid cache folder in writer target partition <target name> partition <partition number>.
Cause:The XML target cache folder specified in the session properties is either invalid or it does not exist.
Action:Verify the XML cache folder name.
WSP_36010Get message key <key> failed.
Cause:Internal error.
Action:Contact Informatica Technical Support.

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.

 

Troubleshooting Informatica Error Messages and Resolution – Part 443

SQLServerF1

WSP_35019XML parser <partition ID> deinitialization failed.
Cause:The Integration Service encountered an error deinitializing the XML parser.
Action:Check the session log for additional messages.
WSP_35020Error in populating message fields.
Cause:Internal error.
Action:Contact Informatica Technical Support.

WSP_35021MsgCount cannot be greater than 1 for two-way Non-WS Aware service.
Cause:The request-response session contains a flat file or XML source with the reader type changed to Web Services Provider reader. The Web Services Hub can process one message for each session. If the message count is greater than 1 for this type of session, the session fails.
Action:Configure the message count to 1 in the reader properties.
WSP_36002Writer target <target name> partition <partition number> failed to initialize flat file generator.
Cause:The Web Services Provider Writer for flat files could not create the target flat file.
Action:Check the session log for additional messages.
WSP_36003Writer target <target name> partition <partition number> failed to initialize XML generator.
Cause:The Web Services Provider Writer for XML could not create the XML target file.
Action:Check the session log for additional messages.

WSP_36004Writer target <target name> group <target group> partition <partition number> failed to process flat file messages.
Cause:The Web Services Provider Writer for flat files failed to process the flat file message.
Action:Check the session log for additional messages.
WSP_36005Writer target <target name> group <target group> partition <partition number> failed to process XML messages.
Cause:The Web Services Provider Writer for XML failed to process the XML message.
Action:Check the session log for additional messages.

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.

 
1 2 3 46