Troubleshoot data integration

Each time that you synchronize from the application database, new structures and data that contain additional columns are copied to the staging database. These columns help you troubleshoot the populating and loading of data. Additionally, error codes and descriptions in the user interface help you troubleshoot the data integration process. The following are topics that list these error codes and error messages.

In This Section

• BizSystemFlag errors
  The BizSystemFlag column sets an error code that indicates failure to load or validate before loading. The corresponding BizSystemErrorDetailscolumn indicates the columns to which the 900+ error code applies.

• BizValidationStatus errors
  The BizValidationStatus column values that indicate validation failures on business rules.

• Synchronization and load errors
  Planning Business Modeler error messages that occur during synchronization.

• Data validation errors
  Planning Business Modeler error messages that occur during the load process.

Related Sections

• Data integration overview
  Provides an overview of the architecture of the Planning Server data-integration system and of the data-load processes.

• Data integration configurations
  Describes different configurations that you can use for security and performance.

• Step 1: Creating the staging database
  Provides background information about the organization of the staging database, and describes the steps that you must follow to create it.

• Step 2: Synchronizing the staging database
  Provides background information about how Planning Server synchronizes the structures and data of each database, and describes the steps that you must follow to perform synchronization.

• Step 3: Populating the staging database
  Describes how to prepare data and structures for data loading.

• Step 4: Validating data in the staging database
  Describes how to validate dimensions, hierarchies, and measure groups.

• Step 5: Loading data from staging to application database
  Provides background information about dimensions and models, and describes the steps that you must follow to load data

• Scriptable data integration
  Describes the commands in the PPSCmd utility that you can use to write a script that performs data integration steps.