Troubleshooting Informatica Error Messages and Resolution – Part 262

SQLServerF1

PR_18001Application Source Qualifier instance <Application Source Qualifier name> has tree source <tree source definition name> and an Extract Override. Extract override will be ignored.
Cause:The listed Application Source Qualifier is connected to an imported PeopleSoft tree source definition and has an extract override. You cannot use extract overrides for imported tree sources.
Action:During the session, the Integration Service ignores the extract override. If you want to perform an extract override on records connected to the Application Source Qualifier, connect the tree source definition to a different Application Source Qualifier.
or
Action:To keep this message from appearing again, remove the extract override from the session properties.

PR_18003Tree <tree name> with SetId <tree setid> and Effective Date <date> was not created.
Cause:The listed tree does not exist in the PeopleSoft source system or has unexpected conditions.
Action:Check the tree in the PeopleSoft source system for problems. If necessary, contact PeopleSoft technical support.
or
Cause:The listed tree has no ports connected to an Application Source Qualifier.
Action:If you do not need the tree in the mapping, delete the tree source definition. Otherwise, connect the necessary ports to an Application Source Qualifier.

PR_18004Application Source Qualifier instance <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.
or
Action:To use more than one imported tree source in a single mapping, create an Application Source Qualifier for each imported tree source you want to use. Use a Joiner transformation to join two related tree sources.

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 *