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. |
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. |
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. |
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. |
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. |
Explanation: | Internal error. |
User Response: | Contact Informatica Global Customer Support. |
Explanation: | Internal error. |
User Response: | Contact Informatica Global Customer Support. |
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. |
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. |
Explanation: | Internal error. The Integration Service encountered an error in the listed SQL statement. |
User Response: | Contact Informatica Global Customer Support. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |