Condividi tramite


Synchronization and load errors

Aggiornato: 2009-04-30

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

  • You are performing data integration in Planning Business Modeler

  • You are using the Utilità da riga di comando di Planning for Scriptable data integration

  • You are validating stored procedures in the staging database

An error message will provide a brief description of what failed, an error code, and in Planning Business Modeler, 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.

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.

Synchronizing and Data Loading Error Messages

The following can errors occur during synchronization or data loading in Planning Business Modeler.

Error code Stored procedure SQL Server 2005 errors Error message in Planning Business Modeler

60002

N/A

N/A

Synchronization of Staging Area failed for dimension: <x>.

Synchronization of Staging Area failed for model: <x>.

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

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

60003

N/A

Module<object>SP<stored_procedure_name>ErrSeq#(%d): Insert to table(%s) failed.

Synchronization of Staging Area failed for dimension: <x>.

Synchronization of Staging Area failed for model: <x>.

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

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

60005

N/A

Module<object>SP<stored_procedure_name>ErrSeq#(%d): Error when executing drop statement for table(%s).

Synchronization of Staging Area failed for dimension: <x>.

Synchronization of Staging Area failed for model: <x>.

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

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

60007

N/A

Module<object>SP<stored_procedure_name>ErrSeq#(%d): Error when executing SELECT statement for table(%s).

Synchronization of Staging Area failed for dimension: <x>.

Synchronization of Staging Area failed for model: <x>.

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

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

60008

N/A

Module<object>SP<stored_procedure_name>ErrSeq#(%d): Error when executing sql statement for table(%s).

Synchronization of Staging Area failed for dimension: <x>.

Synchronization of Staging Area failed for model: <x>. (60008)
Load from Staging Area failed for dim: <x>.

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

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>. Please contact your PerformancePoint Data administrator.

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

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.

Vedere anche