Siebel Customer-Centric Enterprise Warehouse Installation and Configuration Guide > Initializing and Populating the Siebel Customer-Centric Enterprise Warehouse >

Restarting the Extract, Transform, and Load Process

This section provides guidelines on what to do in the event of an Extract, Transform, and Load (ETL) failure. For example, the ETL process fails if a required file is missing or the PowerCenter Server is shut down because of memory problems. You can restart the ETL process in various workflows and worklets—Initialize, Prepare, Extract Facts, Extract Dimensions, Load Dimensions, Load Facts, and Post-Load Processing.

NOTE:  This section assumes that your data warehouse is already in production and you have taken care of any possible data issues.

Scenario for a Workflow in Suspended Mode After a Task Fails

You can resume a workflow after investigating and resolving the issue that causes the suspended workflow. For example, a workflow fails because of a missing source file. In this scenario, you can provide the missing file and resume the workflow.

However, some workflow failures require changes to the session properties. You need to make the required changes to the session properties, save the changes in the repository, and resume the suspended workflow. If the workflow fails with your new changes, abort the workflow, and restart the workflow from the task.

Scenario for a Workflow In Failed Mode and the Shut Down of the PowerCenter Server

You can restart the PowerCenter Server, and restart the workflow from the task, after investigating and resolving the issue that causes the workflow to fail. For example, a workflow fails and the PowerCenter Server is shut down because of memory problems.

To resume a workflow

1. Start the Workflow Monitor.
2. Connect to your repository.
3. Right-click on the suspended workflow, and click Resume Workflow.

To restart a workflow from a task

1. Start the Workflow Monitor.
2. Connect to your repository.
3. Expand the failed workflow, and select the failed task.
4. Right-click on the task, and click Restart Workflow From Task.

   If you have multiple session failures in the same level, you need to click Restart Task for each session. Click Restart Workflow From Task for the last session.