RR Messages

Explanation:	The source tables specified in the mapping do not contain primary keys.
User Response:	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_4006 ERROR: Failed sanity check. No key in node.

Explanation:	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.
User Response:	Use source tables that contain the appropriate primary key-foreign key relationships, or edit the source tables appropriately.

RR_4025 Error executing stored procedure.

Explanation:	You have requested a stored procedure that does not exist in the source databases.
User Response:	Check the source database for the stored procedure you have specified.
Explanation:	The Integration Service encountered an error while trying to run a stored procedure.
User Response:	Check the session log for related error messages.

RR_4032 Warning: # of sorted ports <number of ports> must be less than # of projected fields <number of connected output ports>. Ignoring sort request.

Explanation:	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.
User Response:	Change the sort count to less than or equal to connected ports in the Designer.

RR_4033 Error parsing stored procedure call text <call text>.

Explanation:	The specified stored procedure call text is incorrect.
User Response:	Correct the call text before running the session again.

RR_4034 Projected column metadata fetch failed.

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

RR_4035 SQL error.

Explanation:	An error occurred while executing the SQL query against the source.
User Response:	Ensure that the source database supports the SQL query or the SQL query override that you entered. If you are running a PowerCenter mapping, verify that the source definition name matches the table name in the source database. If you are running a Developer tool mapping, verify that the data object name in the Read transformation matches the table name in the source database.

RR_4036 Error connecting to database <database name>.

Explanation:	The Integration Service failed to connect to the database. You may have logged in incorrectly.
User Response:	Enter the correct login information. User names and passwords may be case sensitive.

RR_4038 Error setting stored procedures. Session-> m_pMapping corrupt.

Explanation:	Internal error. The repository might be out of memory or have inconsistencies.
User Response:	Contact Informatica Global Customer Support.

RR_4039 User defined query <query> contains character(s) that is (are) not valid in the code page of the source database connection. The invalid character starts at position <number> of the query.

Explanation:	You entered a query containing characters that are invalid in the source database connection code page.
User Response:	Change the query to contain characters included in the source database connection code page only.

RR_4040 User defined join condition and/or source filter condition <string> contains character(s) that is(are) not valid in the code page of the source database connection. The invalid character starts at position <number> in the above condition.

Explanation:	The join condition or the source filter condition or the combination of both join and filter conditions contain characters that are invalid in the source database connection code page only.
User Response:	Change either the join, filter, or both conditions to contain characters included in the source database connection code page.

RR_4041 User defined source filter condition <string> contains character(s) that is (are) not valid in the code page of the source database connection. The invalid character starts at position <number> of the filter condition.

Explanation:	You entered a filter condition containing characters that are invalid in the source database connection code page.
User Response:	Change the filter condition to contain characters included in the source database connection code page.

RR_4043 ERROR: One or more fields used to partition source(s) of Source Qualifier <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 source qualifier that you deleted.
User Response:	Edit the session to remove the partition key from the Source Qualifier. Then save the new partition information in the session and run it again.