Error Table Reports Page

Use the Error Table Reports page to provide summarized error detail information—including error and source table for each job, for a given time period.

Navigation

select Dashboards, then select Data Load Analysis, then select Error Table Reports, then select Error Table

Image: Error Table Reports Page

This example illustrates the fields and controls on the Error Table Reports Page. You can find definitions for the fields and controls later on this page.

Usage	Reports	Dashboard Prompt
Provides summarized error detail information—including error and source table—for each job, for a given time period. This information enables you to easily identify and correct invalid data. Note: Each error report enables you to drill down from summary level information to the detailed level. This is discussed in detail in the previous section of , 'Understanding the Data Load Analysis Dashboard.'	This page is comprised of the following reports: Error Table Error Table - Last Run Error Table with Job Info Error Table with Job Info - Last Run Error Table with Batch ID Info	Use the Error Table Reports page prompt to filter page results by: Warehouse Data Mart Category Error Table Last Update Time

Usage

Reports

Dashboard Prompt

Provides summarized error detail information—including error and source table—for each job, for a given time period. This information enables you to easily identify and correct invalid data.

Note: Each error report enables you to drill down from summary level information to the detailed level. This is discussed in detail in the previous section of , 'Understanding the Data Load Analysis Dashboard.'

This page is comprised of the following reports:

Error Table
Error Table - Last Run
Error Table with Job Info
Error Table with Job Info - Last Run
Error Table with Batch ID Info

Use the Error Table Reports page prompt to filter page results by:

Warehouse
Data Mart
Category
Error Table
Last Update Time

Error Table Report

Use the Error Table report, which provides summarized error detail information for each batch run.

Image: Error Table report

This example illustrates the fields and controls on the Error Table report. You can find definitions for the fields and controls later on this page.

Column	Description
Error Table	Displays the error table name associated with the job.
Source Table	Displays the source table name that corresponds to the error table, for the job.
Target Table	Displays the target table name that corresponds to the error table, for the job.
Batch Run ID	Displays the batch run ID for the corresponding job.
Last Update Time	Displays the last update time associated with the job run.
Error Count	Displays the total count of rows loaded into the specified error table for a corresponding job.

Error Table - Last Run Report

The Error Table – Last Run report is identical to the Error Table report in format, but displays only information associated with the most recent job run.

Error Table with Job Info Report

Use the Error Table with Job Info report, which provides summarized error detail information for each job.

Image: Error Table with Job Info report

This example illustrates the fields and controls on the Error Table with Job Info report. You can find definitions for the fields and controls later on this page.

Column	Description
Error Table	Displays the error table name associated with the job.
Source Table	Displays the source table name that corresponds to the error table, for the job.
Target Table	Displays the target table name that corresponds to the error table, for the job.
Job Name	Displays the name of the job associated with the error data.
Batch Run ID	Displays the batch run ID for the corresponding job.
Last Update Time	Displays the last update time associated with the job run.
Error Count	Displays the total count of rows loaded into the specified error table for a corresponding job.

Error Table with Job Info - Last Run Report

The Error Table with Job Info – Last Run report is identical to the Error Table with Job Info report in format, but displays only information associated with the most recent job run.

Error Table with Batch ID Info Report

Use the Error Table with Batch ID Info report, which displays summarized error count information for each Batch Run ID.

Image: Error Table with Batch ID Info report

This example illustrates the fields and controls on the Error Table with Batch ID Info report. You can find definitions for the fields and controls later on this page.

Column	Description
Error Table	Displays the error table name associated with the job.
Source Table	Displays the source table name that corresponds to the error table, for the job.
Target Table	Displays the target table name that corresponds to the error table, for the job.
Job Name	Displays the name of the job associated with the error data.
Batch Run ID	Displays the batch run ID for the corresponding job.
Last Update Time	Displays the last update time associated with the job run.
Error Count	Displays the total count of rows loaded into the specified error table for a corresponding job.