Troubleshooting Informatica Error Messages and Resolution – Part 6

SQLServerF1_Header_Small

Regular expression validation failed at character position <position>: <error message>.
Cause:The Designer could not validate the regular expression.
Action:Check the additional error message for more information.
Some fields in source <source file name> group <group name> cannot be found. The source might be corrupt.
Cause:The source has been modified since you last edited the data profile.
Action:Create a new data profile for the modified source.

Source <source name> cannot be chosen as a lookup source in column lookup domain validation functions as it has already been chosen as a non lookup source in other profiling function(s).
Cause:The specified source in a column lookup function was used as a non-lookup source. The same source was also used in another column lookup function as a lookup source.
Action:A source cannot be used as both a non-lookup and lookup source within the same function. Edit the data profile to use the indicated source as either a lookup or a non-lookup.

Source <source name> has to be chosen as a lookup source in column lookup domain validation functions as it has already been chosen as a lookup source in other profiling function(s).
Cause:The specified source in a column lookup function was used as a lookup source. The same source was also used in another column lookup function as a non-lookup source.
Action:A source cannot be used as both a non-lookup and lookup source within the same function. Edit the data profile to use the indicated source as only a lookup source as already defined.
Target warehouse does not exist.
Cause:The Data Profiling warehouse connection that you specified for viewing reports does not match the relational database connection that you specified for the session target.
Action:In the Profile Manager, modify the connection for viewing reports to match the relational database connection that you specified for the session target.
or
Cause:The database does not contain Data Profiling warehouse tables.
Action:Rerun the Data Profiling warehouse script in the PowerCenter Client directory. Commit the SQL script after you run it. Rerun the profile session and try to view the report 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 *