Troubleshooting Informatica Error Messages and Resolution – Part 402

SQLServerF1

VAR_27000Error <mapping variable or parameter name>: Data Conversion Exception <unknown exception error>.
Cause:The Integration Service encountered a data overflow while attempting to resolve the initial value.
Action:If the initial value is defined in a parameter file, edit the parameter file associated with the session. Verify that datatype and corresponding data are compatible.
or
Action:If the initial value is not defined in the parameter file, go to the mapping and edit the initial value specified in the variable/parameter dialog box.

VAR_27001Error: There is a recursive reference from <session parameter/mapping parameter type>: <name> back to itself. Error detected when resolving initial value for <session parameter/mapping parameter type>: <name>.
Cause:The initial value of the mapping variable you specified in the Designer has a circular dependency when referencing another variable.
Action:If the initial value is defined in a parameter file, edit the parameter file associated with the session. Verify that datatype and corresponding data are compatible.
or
Action:If the initial value is not defined in the parameter file, go to the mapping and edit the initial value specified in the variable/parameter dialog box.

VAR_27002Error occurred in expanding reference for <string to expand>.
Cause:The Integration Service encountered an error when attempting to expand source files, such as for pre- and post-session shell commands.
Action:Check the previous message in the session log for details.
VAR_27003Error occurred in expanding references for initial value of <variable name>.
Cause:The Integration Service encountered an error when attempting to expand initial values for source files, such as for pre- and post-session shell commands.
Action:Check the previous message in the session log for details.
VAR_27004Internal error: aggregation operation requested for data with different datatypes.
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 *