Number of connections in pool ... exceeds limit of 3'

[lakshmikanthaiah_s]

Hello Friends,

We are facing problem in the Java application deployed on SAP J2EE server.

If the user repeat a transaction for contineousely for 3 times, it raises '<i>Number of connections in pool XEBIZUSER_EKAGHOFER exceeds limit of 3'</i> error on the web page. In the application web.xml file we are maintaining Connection Pool size as 20. The EKAGHOFER is login name of the user.

The transaction updates R/3 by calling BAPIs (multiple).

The problem we are facing is on Production system.

But we haven't encountered such problem on Testing system, where same application is running.

We found below messages on the log files:

<u>From console error log file</u>

com.sap.mw.jco.JCO$Exception: (104) RFC_ERROR_SYSTEM_FAILURE: CPIC-CALL: 'CMRCV'

no data received

.

.

.

com.sap.mw.jco.JCO$Exception: (106) JCO_ERROR_RESOURCE: Number of connections in pool XEBIZUSER_EKAGHOFER exceeds limit of 3

<u>From Console output log file</u>

2007-04-25 11:48:23,437 ERROR (EditQueryAction.java:175) - EditQueryAction: com.sap.mw.jco.JCO$Exception: (106) JCO_ERROR_RESOURCE: Number of connections in pool XEBIZUSER_EWUERTH exceeds limit of 3

2007-04-25 11:49:04,421 WARN (RequestProcessor.java:538) - Unhandled Exception thrown: class com.sap.mw.jco.JCO$Exception

<u>From dev_rfc_trace log file</u>

T:4392 ======> No authorization for graphic access (BDS)

T:4392 Error RFCIO_ERROR_MESSAGE in abrfcio.c : 1420

T:4392 <* RfcReceive [2] : returns 3:RFC_SYS_EXCEPTION

T:4392 <* RfcCallReceive [2] : returns 3:RFC_SYS_EXCEPTION

• ERROR file opened at 20070417 133620 GMT Daylight Ti, SAP-REL 620,0,1450 RFC-VER 3 652809 MT-SL

T:6268 Error RFCIO_ERROR_NO_DATA in rfccpix.c : 1220

T:6268 ======> CPIC-CALL: 'CMRCV'

no data received

What would be the root-cause of the issue?

Any solution?

Early reply appreciated.

Thanks and regards,

Lakshmikanthaiah

[Former Member]

We need to set the pool size for JCO's

Go to http://hostname:portname/webdynpro/dispatcher/sap.com/tc_wdtools/Explorer

go to maintain JCo's and u can change the number of connection there ..do let me know if u want more info on this

[lakshmikanthaiah_s]

Hi Krishna,

The application is custom specific and Struts framework based.

We are already maintaining Connection Pool size as 20, we really do not have idea about number 3.

The exceed limit error message is following another message, where we are doubting,

Any hope.

Thanks and regards,

Lakshmikanthaiah