Error while performing Risk Analysis at user level for a cross system user

[former_member771067]

Dear All,

I am getting the below error, while performing the risk analysis at user level for a cross system (Oracle) user.

The error is as follows:

"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 "SAPJ2EDB" 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.RC:1

Can anyone please help.

Regards,

Gurugobinda

[Former Member]

Hi..

Check the note # SAP Note 1121978

SAP Note 1121978 - Recommended settings to improve peformance risk analysis.

Check for the following...

CONFIGTOOL>SERVER>MANAGERS>THREADMANAGER

ChangeThreadCountStep =50

InitialThreadCount= 100

MaxThreadCount =200

MinThreadCount =50

Regards

Gangadhar