Error: User requested cancel of current operation

When running an extraction that is taking a long time, the data extractor may fail with a message box and the error may say "user requested cancel of current operation".

This error indicates that Oracle (or your database server) returned a query timeout because the current query was taking too long.

The fix for this is as follows:

  1. Open "Data Sources (ODBC); Start->Control Panel->Administrative Tools->Data Sources (ODBC)
  2. On the system or user tab, look for the Data Source the data extractor uses to connect to your Database.
  3. Select it, and click "Configure..."
  4. Make sure that: "Enable Query Timeout" is unchecked
  5. Click OK
  6. Click OK

You will now need to run the Data Extraction again.

This should rectify the problem.