SM Messages

Explanation:	The filter condition you specified in Filter transformation does not evaluate to a numeric value.
User Response:	Verify that the filter condition evaluates to a numeric value.

SM_7027 Transformation evaluation error; current row skipped. trying to delete a non-existing row.

Explanation:	The Integration Service failed to evaluate an expression with a particular row, forcing it to skip that row.
User Response:	Check the session log for information about the skipped row.

SM_7038 Aggregate 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.

Explanation:	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.
User Response:	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_7051 Aggregate error: index file timestamp is earlier than the timestamp of the Aggregator transformation or mapping.

Explanation:	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.
User Response:	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_7072 Aggregate Error: Expecting keys to be descending.

Explanation:	You selected the Sorted Input option in an Aggregator transformation, but the data entering the Aggregator transformation is not sorted.
User Response:	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.

SM_7073 Aggregate Error: Expecting keys to be ascending.

Explanation:	You selected the Sorted Input option in an Aggregator transformation, but the data entering the Aggregator transformation is not sorted.
User Response:	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.

SM_7087 Aggregate Error: code page <code page> and cached code page <code page> are not two-way compatible.

Explanation:	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.
User Response:	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_7088 Aggregate Error: sort order <sort order> and cached sort order <sort order> mismatch.

Explanation:	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.
User Response:	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_7089 Aggregate error: Unknown code page <code page> in the aggregation cache.

Explanation:	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.
User Response:	Reinitialize the cache or manually delete the cache file.

SM_7091 Transformation Parse Fatal Error: Update Strategy Expression did not evaluate to a numeric value.

Explanation:	The update strategy expression you specified in the Update Strategy transformation does not evaluate to a numeric value.
User Response:	Verify that the update strategy expression evaluates to a numeric value.

SM_7096 Aggregate Error: Unable to execute cache upgrade utility <utility name>.

Explanation:	The Integration Service failed to upgrade the incremental aggregation files because it could not locate the specified cache upgrade utility.
User Response:	Verify that the cache upgrade utility, pmcacheupgr on UNIX or pmcacheupgr.exe on Windows, exists in the PowerCenter Services installation directory.

SM_7099 Fatal Error: Header from incremental aggregation files for Aggregator transformation <transformation name> has invalid data.

Explanation:	The Integration Service failed to upgrade the incremental aggregation files because the files contain corrupt data.
User Response:	If you have a backup of the incremental aggregation files, replace the corrupted files with the backup files and run the session again. Otherwise, delete the existing incremental aggregation files or configure the session to reinitialize the aggregate cache.

SM_7200 Error reading from incremental aggregation files for Aggregator transformation <transformation name>.

Explanation:	The Integration Service failed to upgrade the incremental aggregation files because the Integration Service does not have read permission on the cache directory.
User Response:	Verify that the user configured to start Informatica Services has read permission on the cache directory.

SM_7202 The upgrade of the incremental aggregation files for Aggregator transformation <transformation name> failed. Unable to write data to new cache file. Check if enough disk space is available.

Explanation:	The Integration Service failed to upgrade the incremental aggregation files because the cache directory has inadequate disk space or the Integration Service does not have write permission on the cache directory.
User Response:	Check the disk for free space. Or, verify that the user configured to start Informatica Services has write permission on the cache directory.

SM_7203 Key length for transformation <transformation name> has changed.

Explanation:	The Integration Service failed to upgrade the incremental aggregation files because you changed the precision for one or more of the group by ports in the Aggregator transformation.
User Response:	To reuse the data in the cache, revert to the last version of the mapping. Otherwise, delete the existing incremental aggregation files or configure the session to reinitialize the aggregate cache.

SM_7204 Row size for transformation <transformation name> has changed.

Explanation:	The Integration Service failed to upgrade the incremental aggregation files because you changed the precision for one or more of the ports in the Aggregator transformation that are not defined as group by ports.
User Response:	To reuse the data in the cache, revert to the last version of the mapping. Otherwise, delete the existing incremental aggregation files or configure the session to reinitialize the aggregate cache.

SM_7207 Incremental aggregation upgrade error.

Explanation:	The Integration Service failed to upgrade the incremental aggregation files.
User Response:	See additional error messages for more information.

SM_7208 Mapping has been modified since the incremental aggregation files for transformation <transformation name> were last saved.

Explanation:	The Integration Service failed to upgrade the incremental aggregation files because 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.
User Response:	To reuse the data in the cache, revert to the last version of the mapping. Otherwise, delete the existing incremental aggregation files or configure the session to reinitialize the aggregate cache.

SM_7209 Cache for transformation <transformation name> was created in a precision mode different from the one specified by the session.

Explanation:	The Integration Service failed to upgrade the incremental aggregation files because the Enable High Precision session option used for the incremental aggregation files differs from the option used for the current session.
User Response:	If the Enable High Precision session option was changed in error, change the option back to its original setting. Otherwise, delete the existing incremental aggregation files or configure the session to reinitialize the aggregate cache.

SM_7210 Number of partitions has changed since cache creation.

Explanation:	The Integration Service failed to upgrade the incremental aggregation files because you changed the number of partitions in the session.
User Response:	To reuse the data in the cache, change the number of partitions back to the original value. Otherwise, delete the existing incremental aggregation files or configure the session to reinitialize the aggregate cache.

SM_7211 The Integration Service data movement mode differs from the data movement mode used when the cache was created.

Explanation:	The Integration Service failed to upgrade the incremental aggregation files because 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.
User Response:	If the Integration Service data movement mode was changed in error, change the data movement mode back to its original setting. Otherwise, delete the existing incremental aggregation files or configure the session to reinitialize the aggregate cache.

SM_7217 Error: Failed to expand update override <text> for target instance <target name>.

Explanation:	The Integration Service cannot expand a parameter or variable in the target update override.
User Response:	Verify that the parameter or variable is defined properly in the parameter file and that its value in the parameter file matches the parameter or variable datatype. For example, you cannot set an integer mapping variable to a text string in the parameter file.
Explanation:	The Integration Service cannot expand the parameter or variable in the target update override due to an internal error.
User Response:	Contact Informatica Global Customer Support.

SM_7218 Aggregate functions are allowed in Aggregator transformations only.

Explanation:	A transformation that is not an Aggregator transformation contains an expression with an aggregate function. Since aggregate functions may be used in Aggregator transformations only, the expression is invalid. The aggregate function might have been passed into the transformation expression using a mapping parameter or variable.
User Response:	Check the transformation expression to see if it uses an aggregate function. If the transformation expression contains mapping parameters or variables, make sure that their values do not contain aggregate functions.

SM_7219 Fatal error parsing the Lookup transformation. Verify that the update dynamic cache condition of the Lookup transformation <transformation name> evaluates to a numeric value.

Explanation:	The expression to update the dynamic cache for the Lookup transformation does not evaluate to a numeric value.
User Response:	Verify that the update dynamic cache condition of Lookup transformation evaluates to a numeric value.