Troubleshooting Informatica Error Messages and Resolution – Part 237


OPT_63170ERROR: Pushdown optimization stops at the transformation <transformation name> because it contains an invalid expression.
Cause:Internal error.
Action:Contact Informatica Technical Support.
OPT_63175ERROR: Pushdown optimization stops at the transformation <transformation name> because the mapping parameter <mapping parameter name> cannot be expanded.
Cause:The transformation contains a mapping parameter that cannot be expanded. The parameter file may be corrupt, the path to the parameter file may be incorrect, or the parameter file name may be incorrect.
Action:Modify the parameter file, the path to the parameter file, or the parameter file name.

OPT_63177Pushdown optimization stops at the transformation <transformation name> because expression <expression name> with < parameter name> parameters cannot be pushed to the database.
Cause:The expression uses a parameter that represents a datatype that is unsupported on the database.
OPT_63193Pushdown optimization to target stops at the transformation <transformation name> because the expression <expression name> uses a boolean expression for parameter <parameter name>.
Cause:The numeric expression contains a boolean subexpression. Numeric and boolean values are not compatible in SQL. To covert a boolean expression to a numeric expression, the database requires a case statement, which cannot be performed with target-side pushdown optimization.

OPT_63205 Error encountered while attempting to partition session at runtime.
Cause:The Integration Service could not dynamically partition the session.
Action:Review previous messages in the session log to determine the cause.
OPT_63206 Invalid Partition Count <count>.
Cause:You set dynamic partitioning based on the number of partitions but the attribute does not contain a valid value.
Action:Set the Number of Partitions to the $DynamicPartitionCount session parameter or enter a number greater than 1.

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.

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 *