BizSystemFlag errors
更新： 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.
.gif "注意") 注意： |
|---|
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.