Synchronization and load errors
Updated: 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 Planning Command Utility 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.