Refresh Failed: Oracle: ORA-01013: user requested cancel of current operation

[ptphuy]

Hello Power BI Community, I have trouble with my dataset on Power BI service. Everytime, I tried to refresh data, it showed the error below. I cant identify where this issue comes from. It happended because of oracle database, on-premise gateways, or server? I really dont what exactly issue is to troubleshoot this issue. Please help me! Thank you so much.

P.s All I know that this problem may be caused by database timeouts.

Last refresh failed: Sat Jun 03 2017 15:37:15 GMT+0700 (SE Asia Standard Time)

Underlying error code:	-2147467259
Underlying error message:	Oracle: ORA-01013: user requested cancel of current operation
DM_ErrorDetailNameCode_UnderlyingHResult:	-2147467259
Microsoft.Data.Mashup.ValueError.DataSourceKind:	Oracle
Microsoft.Data.Mashup.ValueError.DataSourcePath:	10.xxx.x.xx/pdbbiaprod.domain.vn
Microsoft.Data.Mashup.ValueError.ErrorCode:	-2147467259
Microsoft.Data.Mashup.ValueError.Message:	ORA-01013: user requested cancel of current operation
Microsoft.Data.Mashup.ValueError.Reason:	DataSource.Error
Cluster URI:	WABI-SOUTH-EAST-ASIA-redirect.analysis.windows.net
Activity ID:	937ac922-5292-9084-8b04-edfc1f7a440b
Request ID:	43eee97a-af72-a18f-484d-24476110e7ca
Time:	2017-06-03 08:37:15Z

[Ayush_tiwari08]

Hi Try this 

If you are using open database connectivity (ODBC) in Oracle, you have the option of enabling timeouts so that you do not face this error message again. To enable timeouts, go to your Control Panel and click on Administrative Tools. In the Administrative Tools dialog box, clock data sources (ODBC). Select your ODBC connection. On the configuration page, look for the box next to “Enable ODBC Timeout” and make sure that is box is unchecked. This will prevent further timeouts from occurring.

[Romain_FOURNIER]

The Oracle error message may be caused by timeouts.

To lengthen the timeout, simply enter the duration (e.g. 180) in the 'Command timeout in minutes (optional)' box, in 'Advanced options' of Data source settings : 

 

[ChanguiGo]

Funcionó para mi! Increíble!!!!, tanto renegar y era tan sencillo!

[v-ljerr-msft]

Hi @ptphuy,

Have you checked this article to troubleshoot this issue?

In addition, if the issue persists, I would suggest you create a support ticket on Power BI Support for better assistance on this issue. 

Regards

[ptphuy]

Thank you @v-ljerr-msft, I will check this article and try to fix this issue 🙂

[Anonymous]

Hi @ptphuy ,

Did you found any solution for this issue?

Regards,

Abhijeet