Troubleshooting Informatica Error Messages and Resolution – Part 268

SQLServerF1

PR_18036Application Source Qualifier <Application Source Qualifier name> has a tree instance <created tree source definition name>, whose Set Control Value through a mapping variable cannot be expanded or resolved correctly.
Cause:You entered a mapping parameter or variable for the Set Control Value option that does not exist in the mapping parameter file for the session.
Action:Specify the correct mapping parameter file for the session. Verify that the parameter file contains a value for the mapping parameter or variable that you entered for the Set Control Value option.
or
Cause:You entered an invalid value in the parameter file for the Set Control Value option mapping parameter or variable.
Action:Verify that the value you entered in the mapping parameter file for the Set Control Value option mapping parameter or variable is in the correct datatype format.
PR_18037Application Source Qualifier <Application Source Qualifier name> has a tree instance <created tree source definition name>, with an invalid effective date.
Cause:You entered an invalid value in the Effective Date option in the created tree source definition in the Mapping Designer or in the session properties.
Action:Verify that the date you entered for the Effective Date is in the Informatica default date format: MM/DD/YYYY HH24:MI:SS.

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

REGEX_34010Failed to validate the subject.
Cause:The Integration Service could not validate the value for the subject argument, because there was a perl compatible regular expression syntax error. There might not be enough system memory. Or, the value of the subject argument may contain invalid syntax.
Action:Verify that the system contains enough memory.
or
Action:Verify the syntax of the expression. Use perl compatible regular expression syntax.
REGEX_34011Failed to extract the sub-pattern.
Cause:The Integration Service could not extract the subpattern, because there was a perl compatible regular expression syntax error. There might not be enough system memory. Or, the subpattern may contain invalid syntax.
Action:Verify that the system contains enough memory.
or
Action:Verify the syntax of the expression. Use perl compatible regular expression syntax.

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 *