XML Messages

Explanation:	You tried to pivot a column designated as a primary key.
User Response:	Select another column to pivot. You cannot pivot a column that is designated as a primary key.

Cannot change cardinality! The selected cardinality will cause groups <group names> to be invalid.

Explanation:	You tried to change the cardinality of an element that invalidates the group.
User Response:	You cannot change the cardinality of an element if it violates the structure defined in the associated DTD or XML schema.

Denormalized group cannot be created since XML Element/Attribute <column name> has a many to many relationship with XML Element/Attribute <column name>.

Explanation:	You have at least two multiple-occurring element in the group with a many-to-many relationship.
User Response:	You cannot put more than one multiple-occurring element 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.

Element/Attribute <element or attribute name> occurs only once and cannot be pivoted.

Explanation:	You tried to pivot an element that occurs only once.
User Response:	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> cannot be related to group <group>. Related groups should be under the same XML tree branch.

Explanation:	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.
User Response:	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>.

Explanation:	You tried to add a key to a hierarchy level that already has a key.
User Response:	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.

Explanation:	You tried to pivot a column that points to an element that is not a leaf element.
User Response:	Select another column to pivot. You can pivot only attributes and leaf elements.

Only one reference port can reference a pass-through port in an XML Generator transformation.

Explanation:	More than one reference port is referencing the same pass-through port.
User Response:	Remove the duplicate reference ports.

A reference port can be created only in the XML root group.

Explanation:	A non-root group in an XML Generator transformation contains a reference port.
User Response:	Remove the invalid reference port.

Source: <source> is not part of the Source Join Order.

Explanation:	The Designer does not recognize the sources for the source join order.
User Response:	Verify that all the sources in the join order override are valid sources in the Application Source Qualifier. If you entered a join order override and join condition override, verify that you have placed a semi-colon between the order override and the condition override.

The XML file has fewer elements than the pivot value specified. Element <element name> appears only <number> times in the XML file.

Explanation:	The pivot value you set is larger than the number of times the element appears in the XML file you are importing from.
User Response:	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.

The XML metadata is invalid.

Explanation:	The XML definition contains inconsistencies.
User Response:	The XML definition is unusable. You must recreate it.

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.

Explanation:	You have a pivoted and an unpivoted column in one group pointing to the same element.
User Response:	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.