Skip to Content
0
Former Member
Mar 02, 2010 at 11:35 PM

Performance & communication issues after applying GRC 5.3 SP09 on Oracle10G

22 Views

Hello,

After applying the SP9 on GRC 5.3, RAR slowed down badly while doing user risk analysis and it is giving the following log:

Mar 2, 2010 5:34:59 PM com.virsa.cc.xsys.meng.ObjAuthMatcher <init>

FINEST: ObjAuthMatcher constructed: 175ms, #singles=13903, #ranges=4, #super=1

Mar 2, 2010 5:35:00 PM com.virsa.cc.xsys.util.RiskLoader loadAuthMapCache

INFO: Auth Map cache reloaded successfully

Mar 2, 2010 5:35:01 PM com.virsa.cc.dataextractor.bo.DataExtractorSAP getObjPermissions

FINEST: getObjPermissions: elapsed time=2263ms

Mar 2, 2010 6:02:10 PM com.virsa.cc.common.util.ConnectionUtil getConnection

FINEST: Data Source not ready, will wait 30 seconds and try again: ResourceException in method ConnectionFactoryImpl.getConnection(): com.sap.engine.services.connector.exceptions.BaseResourceException: Cannot get connection for 120 seconds. Possible reasons: 1) Connections are cached within SystemThread(can be any server service or any code invoked within SystemThread in the SAP J2EE Engine), 2) The pool size of adapter "SAPSR3DB" is not enough according to the current load of the system or 3) The specified time to wait for connection is not enough according to the pool size and current load of the system. In case 1) the solution is to check for cached connections using the Connector Service list-conns command, in case 2) to increase the size of the pool and in case 3) to increase the time to wait for connection property. In case of application thread, there is an automatic mechanism which detects unclosed connections and unfinished transactions.

The JCOs have the following pool configuration:

Maximum Pool Size 50

Maximum connections 100

Connection Time out 10,000

Maximum Waiting time 60,000

It is also giving this log on the second server node:

Mar 1, 2010 5:48:02 AM com.virsa.cc.common.util.ConnectionUtil getConnection

FINEST: retry: 10ResourceException in method ConnectionFactoryImpl.getConnection(): com.sap.engine.services.dbpool.exceptions.BaseResourceException: SQLException thrown by the physical connection: java.sql.SQLException: Io exception: Got minus one from a read call

com.sap.engine.services.dbpool.exceptions.BaseSQLException: ResourceException in method ConnectionFactoryImpl.getConnection(): com.sap.engine.services.dbpool.exceptions.BaseResourceException: SQLException thrown by the physical connection: java.sql.SQLException: Io exception: Got minus one from a read call

at com.sap.engine.services.dbpool.cci.ConnectionFactoryImpl.getConnection(ConnectionFactoryImpl.java:59)

at com.virsa.cc.common.util.ConnectionUtil.getConnection(ConnectionUtil.java:33)

at com.virsa.cc.xsys.riskanalysis.AnalysisDaemon.getServerCount(AnalysisDaemon.java:296)

Caused by: com.sap.engine.services.dbpool.exceptions.BaseResourceException: SQLException thrown by the physical connection: java.sql.SQLException: Io exception: Got minus one from a read call

Filesystems and DB have plenty of space available.

Your thoughts will be appreciated!

GM