ProcessingKeyErrorLogFileName (MDStore Interface)


  This feature will be removed in the next version of Microsoft SQL Server. Do not use this feature in new development work, and modify applications that currently use this feature as soon as possible.

The ProcessingKeyErrorLogFileName property of MDStore interface stores a directory path to a file for logging dimension key errors encountered during processing.

Applies To: clsCube, clsPartition



Dimension key errors occurring during processing will result in a row being appended to the error log file if specified in this property. This file is in comma-separated values format (.csv) with the following fields:

  • Date and time of the error

  • The name of the database object containing the cube being processed

  • The name of the cube being processed

  • The name of the partition of the cube being processed

  • The name of the dimension with the key error

  • The name of the level with the key error (empty for parent-child dimensions)

  • The key value from the cube's fact table that failed to match to the dimension

A key value that fails during processing may be written more than once. Thus, it is possible for this value to fail multiple times during an operation.

This error log file can be used to find rows in the fact table that do not correspond to rows in the dimension source table. For example, you can import the log file into a table within Microsoft® SQL Server™ 2005 and construct a query with an inner join between the fact table to the error log table to find the distinct rows that will not match.

By default, this property applies to the entire cube. However, it can be overridden by the value for this property for the individual partitions of the cube.