Troubleshooting Informatica Error Messages and Resolution – Part 48

Element/Attribute <element or attribute name> occurs only once and cannot be pivoted.
Cause:You tried to pivot an element that occurs only once.
Action:This is a warning. It is not necessary to pivot a column that occurs only once. You can proceed with the action if you are sure you want to pivot the column.

Group <group name> cannot be related to group <group name>. Related groups should be under the same XML tree branch.
Cause:You tried to set a foreign key to relate to the primary key of a group that is lower on the parent chain than the current group.
Action:Relate to another primary key. You can only set a foreign key to relate to the primary key of a group that is higher in the parent chain than the current group.
A key <column name> already exists at this level. <column name> has a one-one correspondence with <column name>.
Cause:You tried to add a key to a hierarchy level that already has a key.
Action:You cannot have more than one key for one hierarchy level.
Only leaf elements can be pivoted. <column name> refers to a non-leaf element <element name> and cannot be pivoted.
Cause:You tried to pivot a column that points to an element that is not a leaf element.
Action:Select another column to pivot. You can pivot only attributes and leaf elements.
Source file name has to be less than 80 characters long for DBD <file name>.
Cause:You changed the XML file so that the DBD FILENAME attribute is greater or equal to 80 characters.
Action:Make sure the FILENAME attribute is less than 80 characters.

The XML file has fewer elements than the pivot value specified. Element <element name> appears only <number> times in the XML file.
Cause:The pivot value you set is larger than the number of times the element appears in the XML file you are importing from.
Action:This is a warning. You can proceed with the action if you know that the pivot value will match the number of times the element appears in the source XML file when you run the session.
You cannot have a pivoted column and an unpivoted column referring to the same element. Column <column name> is pivoted while column <column name> is not.
Cause:You have a pivoted and an unpivoted column in one group pointing to the same element.
Action:This is a warning. You may get this warning if you are pivoting the same element into several columns in a group. You can proceed with the action if you are sure you want to pivot the column.
You cannot have two multiple occurring elements in the same group. XML Element/Attribute <column name> has a many to many relationship with XML Element/Attribute <column name>.
Cause:You have at least two multiple-occurring elements in the group with a many-to-many relationship.
Action:You cannot put more than one multiple-occurring elements with a many-to-many relationship in the same group. The multiple-occurring elements in a denormalized group must have a one-to-many relationship.
A reference port can be created only in the XML root group.
Cause:A non-root group in an XML Generator transformation contains a reference port.
Action:Remove the invalid reference port.
Only one reference port can reference a pass-through port in an XML Generator transformation.
Cause:More than one reference port is referencing the same pass-through port.
Action:Remove the duplicate reference ports.
The XML metadata is invalid.
Cause:The XML definition contains inconsistencies.
Action:The XML definition is unusable. You must recreate it.

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 *