Data Integration steps have failed in ICA

Products

• Information Centric Analytics
• Data Loss Prevention Core Package

Issue/Introduction

Errors are seen in the Run Loading Procedures step of the Processing Job, data not updated in ICA, data not available in ICA.

Cause

Several. Could be due to the following.

• Connectivity between ICA and target data source
• Data type error/mismatch
• Credentials used to connect to target data source incorrect

Resolution

To begin, run the following query:

 

SELECT * 

FROM Log_DataTransformation

WHERE StatusFlag = 'F'

ORDER BY StartDate ASC

 

This query will return all data integration steps that have failed across all time, with the latest failures at the top.

Scroll to the right to find the following columns:

• ErrorCode
• ErrorDesc (Error Description)
• ErrorSource

These three columns provide detail on what the issue is and will give direction where to look next.

 

The column [StoredProcedureName] will show what stored procedure the failure is related to. This may require looking into the stored procedure. Please use caution when reviewing these. It is recommended a backup or copy of the Stored Procedure be done before making any changes.

 

The [SourceTableName] details where the data is coming from and the [DestinationTableName] column describes where the data is being inserted in to.