Resuming or Halting Operations in Oracle Data Loader On Demand

This topic describes how to halt or resume operations in Oracle Data Loader On Demand.

You can halt Oracle Data Loader On Demand by pressing CTRL+C. This halts the process of submission of the remaining records in the data file. All records that have been submitted continue to be processed by the server. To resume processing, create a properties file using the parameters specified in the following table. To stop requests on the server, log in to Oracle CRM On Demand, navigate to the Import Queue and cancel the request.

To halt operations in Oracle Data Loader On Demand

  • Press CTRL+C.

This halts the process of submission of the remaining records in the data file. All records that have been submitted continue to be processed by the server.

The following procedure describes how to obtain the request ID of a previously interrupted request.

To obtain a request ID

  1. Navigate to the folder where the log files were stored.

    The log files are saved at the location specified with the –clientlogfiledir parameter.

  2. Open the last log file and navigate to the bottom of the file.

    A message displays the request ID similar to the following:

    To resubmit  ... please re-execute ... using the RESUME option while providing the 
    following Request ID
    

The following procedure describes how to resume operations in Oracle Data Loader On Demand.

To resume operations in Oracle Data Loader On Demand

  • Create a properties file using the required or optional parameters.

    For more information on the required or optional parameters, see the following table.

The following table lists the Resume parameters for Oracle Data Loader On Demand.

Table Resume Parameters for Oracle Data Loader On Demand

Parameter Required or Optional Description

-resumerequest value

Required

Request ID of the import request that you want to resume.

-waitforcompletion

Optional

When specified, you get a prompt if:

  • The processing of the request is complete with a status of Completed.

  • You press CTRL+C.