Create Document with large number of rows will cause high CPU usage and stop user from logging into EBS

(Doc ID 2330098.1)

Last updated on DECEMBER 04, 2017

Applies to:

Oracle Web Applications Desktop Integrator - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

Create a Custom Integrator which downloads data from a custom table that contains 250000 records (with 10 columns).
When creating a document from Desktop Integration -> Create Document -> select this custom integrator, 
Excel opens but downloading the data takes very long time and end up showing below error message.

Your document could not be created.
Please contact your support representative.

When trying to re-login to this EBS env with another browser session, it takes around 10 minutes to show the login page,
and after entering user/password, it takes another 25minutes to show the page with responsibility.

Executing 'top' command on the server, it shows java process has high CPU usage as below:

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
28122 r122 20 0 5552m 3.4g 3352 S 193.0 45.8 14:26.09 java

bne.log shows below error message:

9/6/17 7:18 PM [ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)' ERROR BneFileDownloadPage1%3A%3AcreatePage()++Exceeded+maximum+wait+time+for+bootstrap+download+to+occur.++This+may+have+been+caused+by+high+load+on+the+server+or+some+other+network+error.+

9/6/17 7:19 PM [ACTIVE] ExecuteThread: '18' for queue: 'weblogic.kernel.Default (self-tuning)' ERROR BneFileDownloadPage1%3A%3AcreatePage()++Exceeded+maximum+wait+time+for+bootstrap+download+to+occur.++This+may+have+been+caused+by+high+load+on+the+server+or+some+other+network+error.+

 

Changes

 Upgraded from R12.1.3 to R12.2.4 with R12.ATG_PF.C.delta.5 (19245366) or higher applied.

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