Troubleshooting Informatica Error Messages and Resolution – Part 17

SQLServerF1

Application source qualifier <application source qualifier name> has more than one tree attached.
Cause:The listed application source qualifier is associated or connected to more than one imported PeopleSoft tree source definition. You can associate or connect only one imported tree source definition to a single application source qualifier.
Action:Disconnect one of the tree source definitions from the application source qualifier. Or, remove one of the associated tree source definitions. To use more than one tree in a single mapping, create an application source qualifier for each tree you want to use. Use a Joiner transformation to join two related trees.

Application source qualifier <application source qualifier name> has projected port with no inbound link.
Cause:The listed application source qualifier has a connected output port, and the corresponding input port is not connected.
Action:Connect the necessary input port or disconnect the connected output port.
Application Source Qualifier <application source qualifier name> has tree and Extract Override.
Cause:The listed application source qualifier uses a user-defined extract override for a PeopleSoft tree source definition. You cannot use extract overrides for tree sources.
Action:Edit the application source qualifier to remove the extract override and save the mapping.

Application source qualifier <application source qualifier name> has tree source definition with no PeopleSoft tree attributes assigned. The session will fail if you do not provide values for tree name and effective date at session level.
Cause:This message is a warning. You used a created tree source definition in the mapping, but you did not import tree attributes into the source definition in the Mapping Designer.
Action:Before you run a session using this mapping, you must import tree attributes into this created tree source definition. You can import the tree attributes in either the source definition in the Mapping Designer in the session properties.
Application source qualifier <application source qualifier name> has vertical tree source definition <created tree source definition name> and other sources. For vertical tree flattening, tree cannot be joined with any source.
Cause:You have connected a created tree source definition and other sources to this application source qualifier. You cannot connect other sources to an application source qualifier of a created tree source definition.

Action:Use separate application source qualifiers for PeopleSoft sources and separate Source Qualifiers for relational sources. If you need to join a created tree source definition with other sources, use a Joiner transformation.

 

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.

 

Leave a Reply

Your email address will not be published. Required fields are marked *