Errors are seen in the Run Loading Procedures step of the Processing Job, data not updated in ICA, data not available in ICA.
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
To begin, run the following query:
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:
ErrorDesc (Error Description)
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.