Data validation errors

PerformancePoint Server 2007

更新: 2009-04-30

Error messages will appear if validation fails in one or more of the following situations:

  • You are performing data integration in 规划业务建模器

  • You are using the 规划命令实用工具 for Scriptable data integration

  • You are validaing stored procedures in the staging database

An error message will provide a brief description of what failed, an error code, and in 规划业务建模器, advise the user to contact the PerformancePoint Data Administrator. See the following example:

Staging Area operation failed. (Error Code: PerformancePoint_225000050)
Unexpected error occurred. Please contact your PerformancePoint Data Administrator.

Data Validation Error Messages

By using the information in the following table, the data administrator can match the error code to the description of the failure and begin troubleshooting.

Error code in staging database Related stored procedure SQL Server 2005 error Error message in Planning Business Modeler

60900

bsp_DI_ValidateDimension

Module<dimension>SP<stored_procedure_name>ErrSeq#(%d): Message while processing object: Dimension Name cannot be empty. An invalid Dimension Name will prevent the FK validation from happening

No message

60901

bsp_DI_ValidateDimension

Module<dimension>SP<stored_procedure_name>ErrSeq#(%d): Error while processing object: %s. The ModelSiteId %I64d does not exists or is invalid.

No message

61001

bsp_DI_ValidateHierarchy

Module<hierarchy>SP<stored_procedure_name>ErrSeq#(%d): The ModelSiteId %I64d does not exists or is invalid.

Load from Staging Area failed for dimension: <x>. The Application and Staging Area are not synchronized. Please synchronize the Staging Area and try again.

61002

bsp_DI_ValidateHierarchy

Module<hierarchy>SP<stored_procedure_name>ErrSeq#(%d): Could not find the dimension table information for hierarchy table %s.

Load from Staging Area failed for dimension: <x>. The Application and Staging Area are not synchronized. Please synchronize the Staging Area and try again.

61003

bsp_DI_ValidateHierarchy

Module<hierarchy>SP<stored_procedure_name>ErrSeq#(%d): Missing foreign key relationship for hierarchy table %s.

Load from Staging Area failed for dimension: <x>. Please contact your PerformancePoint Data Administrator.

61004

bsp_DI_ValidateHierarchy

Module<hierarchy>SP<stored_procedure_name>ErrSeq#(%d): Missing parent child relationship for hierarchy table %s.

Load from Staging Area failed for dimension: <x>.

61005

bsp_DI_ValidateHierarchy

Module<hierarchy>SP<stored_procedure_name>ErrSeq#(%d): The final hierarchy table %s does not have a root node.

Load from Staging Area failed for dimension: <x>.

61101

bsp_DI_ValidateMeasureGroup

Module<measure_group>SP<stored_procedure_name>ErrSeq#(%d): The table %s does not exist.

Specified table does not exist in StagingDB.

61301

bsp_ValidateLabelTable

Module<label_table>SP<stored_procedure_name>ErrSeq#(%d): The table name (%s) must end with "Label".',

No message

61500

bsp_CreateHierarchyTableForLabelColumnInput

Module<hierarchy>SP<stored_procedure_name>ErrSeq#(%d): Dimension or Table name cannot be empty!

No message

62300

bsp_CreateHierarchyFromDimension

Module<hierarchy>SP<stored_procedure_name>ErrSeq#(%d): No dimension table provided.

No message

62301

bsp_CreateHierarchyFromDimension

Module<hierarchy>SP<stored_procedure_name>ErrSeq#(%d): No level columns provided for dimension %s.

No message

62302

bsp_CreateHierarchyFromDimension

Module<hierarchy>SP<stored_procedure_name>ErrSeq#(%d): No hierarchy name provided to save changes for dimension %s

No message

62400

bsp_ValidateDimForHierarchyCreation

Module<dimension>SP<stored_procedure_name>ErrSeq#(%d): The dimension table %s does not exist.

Memberset creation failed. Unexpected database error occurred. Please refresh model site and try again.

62401

bsp_ValidateDimForHierarchyCreation

Module<hierarchy>SP<stored_procedure_name>ErrSeq#(%d) :Error while processing dimension with table name %s. Column(s) have been used multiple times for the levels.

No message

62402

bsp_ValidateDimForHierarchyCreation

Module<hierarchy>SP<stored_procedure_name>ErrSeq#(%d): Error while processing dimension with table name %s. The columns do not exist in the dimension.

Memberset creation failed. Please save this dimension and try again.

62403

bsp_ValidateDimForHierarchyCreation

Module<hierarchy>SP<stored_procedure_name>ErrSeq#(%d): Error while processing dimension with table name %s. Error in data - Member has multiple parents

Memberset creation failed. The specified properties indicate that one or more members have multiple parents.

62404 (Use 62405)

bsp_ValidateDimForHierarchyCreation

Module<hierarchy>SP<stored_procedure_name>ErrSeq#(%d): Error while processing dimension with table name %s. Error in data - Column refers itself as parent.

If this is obsolete, then remove.

62405

bsp_ValidateDimForHierarchyCreation

Module<hierarchy>SP<stored_procedure_name>ErrSeq#(%d): Error while processing dimension with table name %s. Error in data - Parent Column=%s and Child Column=%s have the same data.

Memberset creation failed for dimension <d>. The specified properties indicate that a member refers to itself as its parent.

60901

bsp_DI_ValidateDimension

Module<hierarchy>SP<stored_procedure_name>ErrSeq#(%d): Error while processing object: %s. The ModelSiteId %I64d does not exists or is invalid.

No message

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.

另请参阅

显示: