BizSystemFlag errors

PerformancePoint Server 2007

更新: 2009-04-30

When dimensions, hierarchies, and measure groups are synchronized to the staging database, the BizSystemFlag and BizSystemErrorDetails columns are added to tables to track error codes and error messages for troubleshooting. During Step 4: Validating data in the staging database, the BizSystemFlag column is set to a 900+ value for each row that is not valid and the corresponding BizSystemErrorDetails value indicates the error columns to which the 900+ error code applies.

To view error messages that correspond to the BizSystemFlag, you must view the SystemErrorDetails table in the staging database. You can open the tables in the staging database after you run the validation stored procedures to identify the problems that appear for each row that is not valid.

注意注意:

These error codes might change in future releases of the product.

Validation Status Codes

The following are error codes and accompanying error text for dimension, hierarchy, and measure-group errors.

Dimension BizSystemFlag Errors

The following BizSystemFlag values are set when you validate dimensions.

BizSystemFlag Error code description from the SystemErrorDetails table

921

Duplicate Label found across New Row(200) and Existing Row(100)

922

Duplicate Label found within New Row(200)

926

MemberId must be NULL for New Row(200)

927

Label and Name must not have NULL values for New or Update Rows

930

Invalid Foreign Key

933

Update Row(300) must have MemberId in the Current Site's Existing Rows(100) and cannot be NULL

934

Delete Row(400) must have MemberId in the Current Site's Existing Rows(100) and cannot be NULL

935

Updates(300) to system Rows are not allowed

936

Deletes(400) to system Rows are not allowed

Hierarchy BizSystemFlag Errors

The following BizSystemFlag values are set when you validate hierarchies.

BizSystemFlag Error code text

941

Duplicate MemberId found across New Row(200) and Existing Row(100)

942

New Row(200) has duplicate MemberId within itself

944

New Row(200) contains a Foreign Key in parent dimension that is not valid

945

Delete Row(400) is a parent of Existing Rows(100)

946

New Row(200) contains a parent MemberId that is not valid

947

Update Row(300) contains a parent MemberId that is not valid

948

RowId must be NULL for new Row(200)

949

Update Row(300) must have RowId and MemberId in the current site's Existing Rows(100) and cannot be NULL

950

Delete Row(400) must have RowId and MemberId in the current site's Existing Rows(100) and cannot be NULL

954

Updates to NONE member(MemberId = -1) are not allowed

955

NONE member (MemberId = -1) cannot have a parent or child element

Measure Group BizSystemFlag Errors

The following BizSystemFlag values are set when you validate measure groups.

BizSystemFlag Error code text

930

Invalid Foreign Key

963

Update Row(300) contains a RowId or MemberId that is not valid

964

Delete Row(400) contains a RowId or MemberId that is not valid

965

Annotation Description column cannot be NULL

966

RowId must be NULL for NEW Rows

967

Update operation(300) not supported for annotations

968

Delete operation(400) not supported for annotations

972

At least one Measure column must have NOT NULL value

Download this book

This topic is included in the following downloadable book for easier reading and printing:

See the full list of available books at Downloadable content for PerformancePoint Planning Server.

另请参阅

显示: