DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Tuesday, August 2, 2016

Oracle Reports taking more time to load when huge number of users are using at a time

ERROR:

Oracle Reports taking more time to load when huge number of users are using at a time

Error in log file
2016-07-22T14:50:04.163+05:30] [WLS_REPORTS] [INCIDENT_ERROR] [REP-56048] [oracle.reports.servlet] [tid: 108] [userId: <anonymous>] [ecid: 0000LOHts1mFw0G6yzFg6G1N^U5j00001h,0:1] [APP: reports] [partition-name: DOMAIN] [tenant-name: GLOBAL] REP-56048 : Engine rwEng-0 crashed., job Id: 15710 [[ 
oracle.reports.RWException: IDL:oracle/reports/RWException:1.0 
at oracle.reports.RWExceptionHelper.read(RWExceptionHelper.java:67)  

SOLUTION:

1. Take a backup and edit the rwserver.conf file from: DOMAIN_HOME/config/fmwconfig/servers/WLS_REPORTS/applications/reports_12.2.1/configuration 


2. Change 

<property name="cacheSize" value="50"/> 

To 

<property name="cacheSize" value=999"/> 

3. Change 

" initEngine="1" maxEngine="1" minEngine="0" engLife="50" maxIdle="30"> 

To 

" initEngine="2" maxEngine="4" minEngine="2" engLife="5" maxIdle="30" callbackTimeOut="180000" jvmOptions="-Xmx1024M -Xms128M -Xss512k"> 


4. <connection maxConnect="200" idleTimeOut="120"> 

Save, restart WLS_FORMS and WLS_REPORTS and test again. 

1 comment:

Sridevi K said...

Regards
Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, SQL, PL/SQL, D2K at training@oracleappstechnical.com | +91 - 9581017828.