Basic Troubleshooting Guide

This guide summarizes various issues that may arise during the day to day running of the ETL batch jobs. For each issue, there is a list of possible remedy or cause:

Note

What are the services that depend on service account. Note that this account is yet to be provided

  • Oracle Linked Server to the EDW that has been created under ETL SQL Server database to retrieve data from EDW

  • The credential and proxy linked to the service account which has been created under ETL SQL Server instance inorder to run the SSIS packages

Common issues

  1. When service account user password expires and is reset, what are the services and accounts that need remapping

    • Oracle Linked Server to the EDW that has been created under ETL SQL Server database to retrieve data from EDW

      SQL Developer login

    • Update the credential and proxy linked to the service account which has been created under ETL SQL Server instance

      • SQL server credential

        SQL Server credential

      • SSIS package execution proxy

        SQL Server proxy

  2. ETL process cannot load data from EDW

    • Check that the password for the service account has not expired

      • Try login into Oracle EDW database

        All SSIS executions

    • Confirm from EDW that there is valid data

    • Check the SSIS Execution logs. See Execute Package

      • Load SSIS All Executions Report

        All SSIS executions

      • SSIS executions summary

        All SSIS summary