ProcessingKeyErrorLogFileName (MDStore Interface)
[!참고] 이 기능은 다음 버전의 Microsoft SQL Server에서 제거됩니다. 새 개발 작업에서는 이 기능을 사용하지 말고, 현재 이 기능을 사용하는 응용 프로그램은 가능한 한 빨리 수정하십시오.
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
Data Type
String
Access
Read/write
주의
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.