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.