Troubleshooting Informatica Error Messages and Resolution – Part 16

SQLServerF1

Application source qualifier : Error! The TO_EFFDT field cannot be projected if there is no primary or PeopleSoft key in the source.
Cause: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.
Action:Disconnect the link between the TO_EFFDT field in the source and the application source qualifier.

Application source qualifier : Error in preparing the query for effective date data extraction.
Cause: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.
Action:Either reimport and replace the PeopleSoft record or define a primary or PeopleSoft key in the Source Analyzer.
or
Cause: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.
Action:Either reimport and replace the PeopleSoft record or define a primary or PeopleSoft key in the Source Analyzer.
Application 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.

Application source qualifier has Effective Date Extract Join Order with invalid source names.
Cause:In the Effective Date Join Order field, you typed a PeopleSoft record name that is not connected to the application source qualifier.
Action: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.
Application 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.

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 *