Troubleshooting Informatica Error Messages and Resolution – Part 339

SM_7024Transformation Parse Fatal Error: Filter clause did not evaluate to a numeric value.
Cause:The filter condition you specified in Filter transformation does not evaluate to a numeric value.
Action:Verify that the filter condition evaluates to a numeric value.
SM_7027Transformation evaluation error; current row skipped… trying to delete a non-existing row.
Cause:The Integration Service failed to evaluate an expression with a particular row, forcing it to skip that row.
Action:Check the session log for information about the skipped row.

SM_7038Aggregate Error: The data movement mode <data movement mode for Integration Service> for the Integration Service does not match the data movement mode <data movement mode in cache> in cache.
Cause:You started a session using incremental aggregation after changing the Integration Service data movement mode. The Integration Service cannot access incremental aggregation files created in a different data movement mode.
Action:Delete the existing incremental aggregation files. Or, configure the session to reinitialize the aggregate cache. Or, if the Integration Service data movement mode was changed in error, change the data movement mode back to its original setting.
SM_7051Aggregate error: index file timestamp is earlier than the timestamp of the Aggregator transformation or mapping.
Cause:You modified a mapping containing an Aggregator transformation or modified the Aggregator transformation. Then, when you ran the incremental aggregation session, the Integration Service tried to reuse the existing cache file that was invalid with the Aggregator modifications.
Action:The mapping and Aggregator transformation timestamp must be earlier than the cache file. Either reinitialize the aggregate cache or delete the cache file manually.

SM_7072Aggregate Error: Expecting keys to be descending.
Cause:You selected the Sorted Input option in an Aggregator transformation, but the data entering the Aggregator transformation is not sorted.
Action:Sort the data before the Aggregator transformation, or clear the Sorted Input option. You can sort the data using the Sorted Ports option in the Source Qualifier transformation, or you can use a Sorter transformation.

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 *