PR Messages

Explanation:	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.
User Response:	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. To keep this message from appearing again, remove the extract override from the session properties.

PR_18003 Tree <tree name> with SetId <tree setid> and Effective Date <date> was not created.

Explanation:	The listed tree does not exist in the PeopleSoft source system or has unexpected conditions.
User Response:	Check the tree in the PeopleSoft source system for problems. If necessary, contact PeopleSoft technical support.
Explanation:	The listed tree has no ports connected to an Application Source Qualifier.
User Response:	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_18004 Application Source Qualifier instance <Application Source Qualifier name> has more than one tree attached.

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

PR_18005 Tree may only be joined with Detail record: <PeopleSoft record name>.

Explanation:

You connected or associated an imported tree and a record in an Application Source Qualifier, and the record is not the detail record for the tree.

User Response:

You can connect or associate an imported tree with a non-detail record if the non-detail record is related to the detail record and you connect or associate the detail record with the Application Source Qualifier.

You can connect the tree and non-detail record to separate Application Source Qualifiers and join them with a Joiner transformation.

To determine which record provides detail data for a tree, open the tree source definition in the Mapping Designer and click the Attributes tab.

PR_18006 Not all sources are related in Application Source Qualifier <Application Source Qualifier name>.

Explanation:	You tried to connect or associate two unrelated sources in the listed Application Source Qualifier. You can only connect or associate related sources in an Application Source Qualifier.
User Response:	Disconnect one of the unrelated sources. Remove one of the associated source definitions.

PR_18007 Unknown error occurred in Application Source Qualifier <Application Source Qualifier name>.

Explanation:	Internal error.
User Response:	Contact Informatica Global Customer Support.

PR_18009 Error in converting <string> to Date. Internal Error.

Explanation:	Internal error.
User Response:	Contact Informatica Global Customer Support.

PR_18010 Tree <tree name> was changed after session run was started.

Explanation:	The listed tree changed in the PeopleSoft system after the Integration Service started the session.
User Response:	The Integration Service completes the session with version of the tree as it was at the beginning of the session. If this is not the version you want, correct the session targets and run the session again.

PR_18011 Application Source Qualifier <Application Source Qualifier name> has projected port with no inbound link.

Explanation:	The listed Application Source Qualifier has a connected output port, and the corresponding input port is not connected.
User Response:	Connect the necessary input port, or disconnect the connected output port.

PR_18012 SQL Error <SQL statement>.

Explanation:	Internal error. The Integration Service encountered an error in the listed SQL statement.
User Response:	Contact Informatica Global Customer Support.

PR_18013 Warning: Application Source Qualifier transformation <Application Source Qualifier name> has a larger number of sorted ports than projected output ports.

Explanation:	In an Application Source Qualifier, the number of sorted ports option on the Properties tab has a higher value than the number of connected output ports.
User Response:	Either lower the Number of Sorted Ports value or increase the number of connected output ports in the Application Source Qualifier.

PR_18020 The language table <language table name>, for the base table <base table name>, does not have rows for the language <language code>.

Explanation:	The application connection for the session specifies a PeopleSoft language code, and the source table listed in the error message does not have related data for the language you specified. When there is no data for the specified language, the Integration Service returns data from the base source table.
User Response:	If you require data in the specified language, that data must be entered into the PeopleSoft system. If you want data in a different language, you can edit the application connection or create a connection for a different language code.

PR_18021 The Application Source Qualifier <Application Source Qualifier> has invalid user defined query <query> with character error at <number> location.

Explanation:	You entered a query containing characters that are not valid in the source application connection code page.
User Response:	Edit the query so all characters are valid in the source database connection code page.

PR_18022 The Application Source Qualifier <Application Source Qualifier> has invalid filter clause <filter> with character error at <number> location.

Explanation:	You entered a filter condition containing characters that are not valid in the application connection code page.
User Response:	Edit the filter condition so all characters are valid in the application connection code page.

PR_18023 The Application Source Qualifier <Application Source Qualifier> has invalid join and/or filter override <join override> with character error at <number> location.

Explanation:	You entered a join condition and/or a source filter condition that contains characters that are not valid in the application connection code page.
User Response:	Edit the join and/or filter conditions so all characters are valid in the application connection code page.

PR_18026 The session failed because Application Source Qualifier <Application Source Qualifier name> contains a vertical tree source definition with no PeopleSoft tree attributes assigned. (At least provide Tree Name and Effective Date.)

Explanation:	You did not import PeopleSoft tree attributes into the created tree source definition.
User Response:	Import tree attributes in the created tree source definition. You can import the tree attributes in either the source definition in the Mapping Designer or in the session properties. You must enter at least the PeopleSoft tree name and its effective date.

PR_18027 Application Source Qualifier <Application Source Qualifier name>: Error in preparing the query for effective date data extraction.

Explanation:	You have defined this Application Source Qualifier to extract current rows from an effective dated record that has no primary keys or PeopleSoft keys defined.
User Response:	Either reimport and replace the PeopleSoft record or define a primary or PeopleSoft key in the Source Analyzer.
Explanation:	You have specified an effective date join order in this Application Source Qualifier, and at least one of the effective dated records has no primary keys or PeopleSoft keys defined.
User Response:	Either reimport and replace the PeopleSoft record or define a primary or PeopleSoft key in the Source Analyzer.

PR_18028 Application Source Qualifier <Application Source Qualifier name> has Effective Date Extract Join Order with invalid source names.

Explanation:	In the Effective Date Join Order field, you typed a PeopleSoft record name that is not connected to the Application Source Qualifier.
User Response:	Edit the Effective Date Join Order field so that each PeopleSoft record name is spelled correctly. The record names you enter in the Effective Date Join Order field must match the records associated with the Application Source Qualifier. Separate each record name with a comma.

PR_18029 Application Source Qualifier <Application Source Qualifier name> has Effective Date Extract Join Order with invalid number of source names. This should be equal to the number of effective dated records in the DSQ.

Explanation:	In the Effective Date Join Order field, you entered too few or too many PeopleSoft record names.
User Response:	Edit the Effective Date Join Order field so the number of records you enter equals the number of records associated with the Application Source Qualifier. Verify that you separated each PeopleSoft record name with a comma.

PR_18030 Application Source Qualifier <Application Source Qualifier name> cannot have Effective Date Extract Join Order when number of Effective Dated sources is one.

Explanation:	You entered an effective date join order in the session properties, but there is only one effective dated record connected to the Application Source Qualifier.
User Response:	Delete the text from the Effective Date Join Order field in the session properties.

PR_18031 Application Source Qualifier <Application Source Qualifier name> has invalid Extract Date.

Explanation:	You entered the Extract Date in the wrong date format.
User Response:	Enter the Extract Date in the following format: MM/DD/YYYY HH24:MI:SS.

PR_18032 Application Source Qualifier <Application Source Qualifier name> has extract date mapping variable which cannot be expanded or Parameter File has invalid value for extract date mapping variable.

Explanation:	You entered a mapping parameter or variable for the Extract Date transformation option that does not exist in the mapping parameter file for the session.
User Response:	Specify the correct mapping parameter file for the session. Make sure the parameter file contains a value for the mapping parameter or variable that you entered for the extract date.
Explanation:	You entered an invalid value in the parameter file for the extract date mapping parameter or variable.
User Response:	Verify that the value you entered in the mapping parameter file for the extract date mapping parameter or variable is in the correct datatype format. Enter the value in Informatica default date format: MM/DD/YYYY HH24:MI:SS.

PR_18033 Application Source Qualifier <Application Source Qualifier name> has a tree instance <created tree source definition name>, whose source name through a mapping variable cannot be expanded or resolved correctly.

Explanation:	You entered a mapping parameter or variable for the PeopleSoft tree name that does not exist in the mapping parameter file for the session.
User Response:	Specify the correct mapping parameter file for the session. Verify that the parameter file contains a value for the mapping parameter or variable that you entered for the PeopleSoft tree name.
Explanation:	You entered an invalid value in the parameter file for the PeopleSoft tree name mapping parameter or variable.
User Response:	Verify that the value you entered in the mapping parameter file for the PeopleSoft tree name mapping parameter or variable is in the correct datatype format.

PR_18034 Application Source Qualifier <Application Source Qualifier name> has a tree instance <created tree source definition name>, whose effective date through a mapping variable cannot be expanded or resolved correctly.

Explanation:	You entered a mapping parameter or variable for the Effective Date option that does not exist in the mapping parameter file for the session.
User Response:	Specify the correct mapping parameter file for the session. Verify that the parameter file contains a value for the mapping parameter or variable that you entered for the Effective Date option.
Explanation:	You entered an invalid value in the parameter file for the Effective Date option mapping parameter or variable.
User Response:	Verify that the value you entered in the mapping parameter file for the Effective Date option mapping parameter or variable is in the correct datatype format.

PR_18035 Application Source Qualifier <Application Source Qualifier name> has a tree instance <created tree source definition name>, whose Set Id through a mapping variable cannot be expanded or resolved correctly.

Explanation:	You entered a mapping parameter or variable for the Set ID option that does not exist in the mapping parameter file for the session.
User Response:	Specify the correct mapping parameter file for the session. Verify that the parameter file contains a value for the mapping parameter or variable that you entered for the Set ID option.
Explanation:	You entered an invalid value in the parameter file for the Set ID option mapping parameter or variable.
User Response:	Verify that the value you entered in the mapping parameter file for the Set ID option mapping parameter or variable is in the correct datatype format.

PR_18036 Application Source Qualifier <Application Source Qualifier name> has a tree instance <created tree source definition name>, whose Set Control Value through a mapping variable cannot be expanded or resolved correctly.

Explanation:	You entered a mapping parameter or variable for the Set Control Value option that does not exist in the mapping parameter file for the session.
User Response:	Specify the correct mapping parameter file for the session. Verify that the parameter file contains a value for the mapping parameter or variable that you entered for the Set Control Value option.
Explanation:	You entered an invalid value in the parameter file for the Set Control Value option mapping parameter or variable.
User Response:	Verify that the value you entered in the mapping parameter file for the Set Control Value option mapping parameter or variable is in the correct datatype format.

PR_18037 Application Source Qualifier <Application Source Qualifier name> has a tree instance <created tree source definition name>, with an invalid effective date.

Explanation:	You entered an invalid value in the Effective Date option in the created tree source definition in the Mapping Designer or in the session properties.
User Response:	Verify that the date you entered for the Effective Date is in the Informatica default date format: MM/DD/YYYY HH24:MI:SS.

PR_18038 ERROR: One or more fields used to partition source(s) of Source Qualifier <Application Source Qualifier name> have been deleted. Please edit and save the session to correct the partitioning information.

Explanation:	You defined a partition key for a port in the Application Source Qualifier that you deleted.
User Response:	Edit the session to remove the partition key from the Application Source Qualifier. Then save the new partition information in the session and run it again.

PR_18040 Application Source Qualifier <Application Source Qualifier name>: Error! The TO_EFFDT field cannot be projected if there is no primary or PeopleSoft key in the source.

Explanation:	You have defined this Application Source Qualifier to connect a TO_EFFDT field from a source that has no primary keys or PeopleSoft keys defined.
User Response:	Disconnect the link between the TO_EFFDT field in the source and the Application Source Qualifier.