ORA-01013: user requested cancel of current operation

ORA-01013: user requested cancel of current operation

  

Hi Team,

Am getting below error on my Aggregate, error is "ORA-01013: user requested cancel of current operation"

Thanks in advance.

Hi Deepak,

There are 3 cause to this error.

- caused by the user (pressing CTRL-C or a different method like front-end application),
- caused by a response to congruent errors OR
- the result of timeouts

Here it seems timeout issue. Check if your aggregate is heavy and try to increase its timeout and run again.

Thanks and Regards,

Suraj Borade


Suraj Borade wrote:

Hi Deepak,

There are 3 cause to this error.

- caused by the user (pressing CTRL-C or a different method like front-end application),
- caused by a response to congruent errors OR
- the result of timeouts

Here it seems timeout issue. Check if your aggregate is heavy and try to increase its timeout and run again.

Thanks and Regards,

Suraj Borade


Thanks Suraj for your swift response. I have tired this option, but am getting same error.


Hi Deepak,

Can u share sample eSpace so that we can have a look?

Solution

Hi Deepak,

Do you have filters in your aggregate?

Solution

Hi João Heleno & Suraj,

Yes, I have used aggregate & I fond the issue. Issue is with wrong filter.

Thanks for your time.