Troubleshooting Informatica Error Messages and Resolution – Part 340

SM_7073Aggregate Error: Expecting keys to be ascending.
Same as SM_7072.
SM_7087Aggregate Error: code page <code page> and cached code page <code page> are not two-way compatible.
Cause:You changed the session code page using incremental aggregation. The new code page is not compatible with the previous code page. Therefore, the data in the existing aggregate cache is not compatible with the new session code page.
Action:To reuse the data in the cache, set the code page of the current session to a compatible code page. Otherwise, reinitialize the cache or manually delete the cache file.

SM_7088Aggregate Error: sort order <sort order> and cached sort order <sort order> mismatch.
Cause:You changed the session sort order. The new sort order is not compatible with the previous code page sort order. Therefore, the data in the existing aggregate cache is not compatible with the new session code page.
Action:If you want to reuse the data in the cache, set the sort order of the current session to a compatible code page sort order. Otherwise, reinitialize the cache or manually delete the cache file.
SM_7089Aggregate error: Unknown code page <code page> in the aggregation cache.
Cause:The Integration Service cannot identify the code page used to create the incremental aggregate cache because the cache was generated in a different server environment with a different code page.
Action:Reinitialize the cache or manually delete the cache file.

SM_7091Transformation Parse Fatal Error: Update Strategy Expression did not evaluate to a numeric value.
Cause:The update strategy expression you specified in the Update Strategy transformation does not evaluate to a numeric value.
Action:Verify that the update strategy expression evaluates to a numeric value.
SM_7096Aggregate Error: Unable to execute cache upgrade utility <utility name>.
Cause:The Integration Service failed to upgrade the incremental aggregation files because it could not locate the specified cache upgrade utility.
Action:Verify that the cache upgrade utility, pmcacheupgr on UNIX or pmcacheupgr.exe on Windows, exists in the PowerCenter Services installation directory.

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 *