Troubleshooting Informatica Error Messages and Resolution – Part 266

SQLServerF1

PR_18029Application Source Qualifier 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.
Cause:In the Effective Date Join Order field, you entered too few or too many PeopleSoft record names.
Action: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_18030Application Source Qualifier cannot have Effective Date Extract Join Order when number of Effective Dated sources is one.
Cause: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.
Action:Delete the text from the Effective Date Join Order field in the session properties.
PR_18031Application Source Qualifier has invalid Extract Date.
Cause:You entered the Extract Date in the wrong date format.
Action:Enter the Extract Date in the following format: MM/DD/YYYY HH24:MI:SS.

PR_18032Application Source Qualifier has extract date mapping variable which cannot be expanded or Parameter File has invalid value for extract date mapping variable.
Cause: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.
Action: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.
or
Cause:You entered an invalid value in the parameter file for the extract date mapping parameter or variable.
Action: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.

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 *