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. 
  • August 2, 2016 | 20 views