My Oracle Support Banner

'Where Used' Function Times Out with error, "ORA-01013: user requested cancel of current operation" (Doc ID 2194409.1)

Last updated on JUNE 21, 2018

Applies to:

Oracle Agile Product Lifecycle Management for Process - Version 5.0.0 and later
Information in this document applies to any platform.

Symptoms

The 'Where Used' Function is not working correctly on specifications with a large amount of Where Used data.
After clicking the 'Where Used' button on an affected specification, the pop window displays blank for almost a minute before presenting an unhandled error message.


ERROR
-----------------------
Exception: System.Web.HttpUnhandledException: Exception of type 'System.Web.HttpUnhandledException' was thrown. ---> Xeno.Data.DataAccessException: ORA-01013: user requested cancel of current operation


STEPS TO REPRODUCE

The issue can be reproduced at will with the following steps:
1. Navigate to a specification with a large number of Where Used objects.
2. Navigate to the References Tab.
3. Click 'Where Used' under Specification Dependencies.
4. Pop up window presents blank screen for almost a minute before displaying error.



Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.