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

Last updated on NOVEMBER 14, 2016

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

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 hundreds of Community platforms