Troubleshooting Informatica Error Messages and Resolution – Part 328

SQLServerF1

RR_4004ERROR: Failed sanity check. No primary key in source tables.
Cause:The source tables specified in the mapping do not contain primary keys.
Action:Use source tables that contain primary keys or edit the source tables appropriately. When using multiple sources, you must create the appropriate primary-foreign key relationships.
RR_4006ERROR: Failed sanity check. No key in node…
Cause:The source tables specified in the mapping do not contain the appropriate primary key-foreign key relationships. When using multiple source tables with a Source Qualifier, each table must have a primary key-foreign key relationship.
Action:Use source tables that contain the appropriate primary key-foreign key relationships, or edit the source tables appropriately.

RR_4025Error executing stored procedure…
Cause:You have requested a stored procedure that does not exist in the source databases.
Action:Check the source database for the stored procedure you have specified.
or
Cause:The Integration Service encountered an error while trying to run a stored procedure.
Action:Check the session log for related error messages.
RR_4032Warning: # of sorted ports <number of ports> must be less than # of projected fields <number of connected output ports>. Ignoring sort request.
Cause:The number of output ports connected from the Source Qualifier transformation to another transformation is less than the number entered in the Source Qualifier number of sorted ports option.
Action:Change the sort count to less than or equal to connected ports in the Designer.
RR_4033Error parsing stored procedure call text <call text>.
Cause:The specified stored procedure call text is incorrect.
Action:Correct the call text before running the session again.

RR_4034Projected column metadata fetch failed.
Cause:Internal error.
Action:Contact Informatica Technical Support

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 *