'Where Used' Function Times Out with error, "ORA-01013: user requested cancel of current operation"
Last updated on MAY 10, 2018
Applies to:Oracle Agile Product Lifecycle Management for Process - Version 5.0.0 and later
Information in this document applies to any platform.
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.
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.
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