Common Data Loading Issues

When you load data into an OTBI-Enterprise data warehouse, you might encounter these data loading issues.

Use the list below to identify issues and find out how to diagnose them.

Loading Issues and resolutions

Example 6-1 ETL failed due to healthcheck

Description: a data load was not completed (that is, a load plan execution fails), and a Health Check notification email is sent to the Administrator.

Resolution: Use the error information in the Health Check notification email to diagnose the issue in Configuration Manager, and then correct the issue.

Example 6-2 ETL failed due to other issue

Description: A data load was not completed (that is, a load plan execution fails). A Health Check email notification is not sent to the Administrator.

Resolution: Use Configuration Manager to diagnose the data loading issue, and then correct the issue.

Example 6-3 ETL completed but with auto-corrections

Description: Data was loaded but the ETL process auto-corrected data in the OTBI-Enterprise data warehouse, and a Health Check notification email is sent to the Administrator.

Resolution: Use Configuration Manager to view an auto-corrections report and verify the corrections.