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:
- Open "Data Sources (ODBC); Start->Control Panel->Administrative Tools->Data Sources (ODBC)
- On the system or user tab, look for the Data Source the data extractor uses to connect to your Database.
- Select it, and click "Configure..."
- Make sure that: "Enable Query Timeout" is unchecked
- Click OK
- Click OK
You will now need to run the Data Extraction again.
This should rectify the problem.