Troubleshooting Informatica Error Messages and Resolution – Part 329

SQLServerF1

RR_4035SQL error.
Cause:Error executing SQL query.
Action:Make sure the query can run using SQL Override in the Source Qualifier. Otherwise, contact Informatica Technical Support.
RR_4036Error connecting to database <database name>.
Cause:The Integration Service failed to connect to the database. You may have logged in incorrectly.
Action:Enter the correct login information. user names and passwords may be case-sensitive.

RR_4038Error setting stored procedures. Session-> m_pMapping corrupt.
Cause:Internal error. The repository might be out of memory or have inconsistencies.
Action:Contact Informatica Technical Support.
RR_4039User 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.
Cause:You entered a query containing characters that are invalid in the source database connection code page.
Action:Change the query to contain characters included in the source database connection code page only.
RR_4040User 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.
Cause: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.
Action:Change either the join, filter, or both conditions to contain characters included in the source database connection code page.

RR_4041User 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.
Cause:You entered a filter condition containing characters that are invalid in the source database connection code page.
Action:Change the filter condition to contain characters included in the source database connection code page.
RR_4043ERROR: 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.
Cause:You defined a partition key for a port in the source qualifier that you deleted.
Action: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.

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 *