Unable to import data using Oracle connector Error ORA-01013: user requested cancel of current operation

Unable to import data using Oracle connector Error ORA-01013: user requested cancel of current operation

book

Article ID: KB0075674

calendar_today

Updated On:

Products Versions
Spotfire Analyst 7.6 and higher

Description

While accessing/creating the Oracle connector connection, it is failed to import data. Below error returned 

============

Error message: Unable to import data. See the details for more information.

ImportException at Spotfire.Dxp.Data:
An error occurred when executing a query in the external data source.
External error:
ORA-01013: user requested cancel of current operation

Data connection:
Connection

Authentication method:
Oracle authentication
===============


 

Issue/Introduction

Unable to import data using Oracle connector Error ORA-01013: user requested cancel of current operation

Environment

All Supported OS

Resolution

The most common cause of ORA-01013 is timeouts.
Increase the timeout values in the Oracle Connection Advanced tab
User-added image

Additional Information

http://www.dba-oracle.com/t_ora_01013_user_requested_cancel_of_current_operation.htm
https://docs.oracle.com/cd/E85694_01/ODPNT/CommandCommandTimeout.htm

Attachments

Unable to import data using Oracle connector Error ORA-01013: user requested cancel of current operation get_app