Error Configuration (Partition Properties Dialog Box) (Analysis Services - Multidimensional Data)
Use the Error Configuration page of the Partition Properties dialog box in SQL Server Management Studio to set the error configuration properties of a partition in a measure group for a cube in an Microsoft SQL Server Analysis Services database.
Options
Use default error configuration
Select to use the default error configuration for objects in the processing operation.Key error action
Select the action that occurs if processing finds a new key that cannot be looked up. The following table lists the available actions.Action
Description
Convert to unknown
Aggregates the information for the record into the unknown member.
Discard record
Excludes the information for the record from being processed with the object.
Ignore errors count
Select to ignore any errors that occur when the partition is processed.Stop on error
Select to stop processing when errors occur. This option makes the Number of errors and the On error action options available.Number of errors
Type the number of errors that are ignored before processing stops.On error action
Select the action to be taken when the number of errors exceeds the value in Number of errors. The following table lists the available actions.Action
Description
Stop processing
Ends the processing operation.
Stop logging
Stops logging errors, but continues the processing operation.
Key not found
Specify the actions to be taken when a key is not found when an object is processed. The following table lists the available actions.Action
Description
Ignore error
Ignores the error.
Report and continue
Reports the error and continues the processing operation.
Report and stop
Reports the error and stops the processing operation.
Duplicate key
Specify the action to be taken if a duplicate key is found when an object is processed. The following table lists the available actions.Action
Description
Ignore error
Ignores the error.
Report and continue
Reports the error and continues the processing operation.
Report and stop
Reports the error and stops the processing operation.
Null key converted to unknown
Specify the action to be taken when a null member key is added to the unknown member when an object is processed. The following table lists the available actions.Action
Description
Ignore error
Ignores the error.
Report and continue
Reports the error and continues the processing operation.
Report and stop
Reports the error and stops the processing operation.
Null key not allowed
Specify the action to be taken when a null key is found, but not allowed, when an object is processed. The following table lists the available actions.Action
Description
Ignore error
Ignores the error,
Report and continue
Reports the error and continues the processing operation.
Report and stop
Reports the error and stops the processing operation.
Error log path
Type the full path and file name for the error log file.