The Load Data Warehouse job, full load, fails after exceeding the timeout setting specified in the NSA / CSA. It is set to 700 minutes, which is more than the default value.
DB latency issues. It was noticed that one or more table took inordinate amount of time to process.
Run the following query to fetch details about data load times against each table in the Data Warehouse. Note that the query is for an Oracle DB. It will need modification to execute against SQL Server and Postgres. The query is to be executed against the DWH DB.
CAST(dgmv.dw_load_start_date AS TIMESTAMP) dw_load_start_date,
CAST(dgmv.dw_load_end_date AS TIMESTAMP) dw_load_end_date,
CAST(dgmv.dw_updated_date AS TIMESTAMP) dw_updated_date
ORDER BY dw_load_start_date DESC
Engage a DBA to analyze the high load times.