cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
beiker10
Frequent Visitor

Error randomly when Refresh Data to Oracle (Oracle: ORA-01013)

Hey All,

 

Randomly I get the following error when going to refresh data using oracle database.

 

    Oracle: ORA-01013: el usuario ha solicitado la cancelación de la operación actual

 

This error occurs randomly and each time is more frequent.

What could be the problem?

  • Concurrency in the database?
  • Gateway problem?
  • Any configuration parameter in the database?

 

2 REPLIES 2
Super User IV
Super User IV

Re: Error randomly when Refresh Data to Oracle (Oracle: ORA-01013)

Hi there

If this is happening from time to time I would ask the DBA to see if there were any issues on the Oracle DB at that time?

Also then look at the Gateway at that time, and if you have got logging to see what is happening on the Power BI Gateway

here is a blog post for logging on the Power BI Gateway: https://docs.microsoft.com/en-us/data-integration/gateway/service-gateway-performance




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!






Power BI Blog
Community Support
Community Support

Re: Error randomly when Refresh Data to Oracle (Oracle: ORA-01013)

hi  @beiker10 

The most common cause of ORA-01013 is timeouts. 

Just please refer to these post:

https://community.powerbi.com/t5/Desktop/Oracle-ORA-01013-how-to-change-the-timeout-setting-for-orac...

https://community.powerbi.com/t5/Desktop/ORA-01013-I-want-to-change-the-query-timeout-setting/m-p/45...

and 

https://www.tekstream.com/resource-center/ora-01013-error-message/

 

Regards,

Lin

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

April 2020 Community Highlights

April 2020 Community Highlights

Info on our Super Users, MBAS content and badges, and updates to our support articles. - Read the full Community Highlights.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.