MSUEDW - ODBC Error: "ORA-01013 User Requested Cancel of Current Operation."( ODBC --Call Failed.)

Problem

When running a query on a MSUEDW View in Access/Excel using a Data Source ODBC, you receive an ODBC error: "ORA-01013 User Requested Cancel of Current Operation."( ODBC --Call Failed.) when the user did not cancel the query.

To fix this problem, the ODBC Driver settings need to be adjusted.

Environment

MSUEDW

Resolution

  1. Click Start > Settings >Control Panel > Administrative Tools > Data Sources (ODBC).
  2. Click the System DSN tab in the ODBC Data Source Administrator Window.
  3. Select the name of the Banner/Oracle data source from the list.
  4. Click the Configure button.
  5. On the Application tab of the Oracle ODBC Driver Configuration window, un-check all checkboxes with the exception of Read-Only Connection.
    Screenshot

  6. On the Oracle tab of the Oracle ODBC Driver Configuration window, un-check the checkbox for Enable Failover.
    Screenshot

  7. Click OK to Save changes.
  8. Reboot the PC.
  9. You're done!

Cause

Bad ODBC driver settings can cause connection issues to the data source.

 

Print Article

Related Services / Offerings (1)

Enterprise Data Warehouse
Enterprise Data Warehouse provides access to a central data repository used for the collection and sharing of university related data. MSU’s enterprise data warehouse is commonly known as the MSUEDW and resides on an Oracle database.  It provides data that can be used to support the reporting, data analysis and general data needs of the university. The MSUEDW collects data from the university’s business systems (HR, Payroll, Finance, Organizational, IPF), student systems (Campus Solutions, D2L), research systems (KCRA, Contract Grants) and various other supporting applications and data sources.