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)
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.
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.
Recommended Posts
