Skip to end of metadata
Go to start of metadata

Is the value defined in JDBC connection bigger then 0?

 

Yes:  Do you get the message "out of connections" in the log viewer?

No: Increase the number fo JDBC connections.

 

(grey lightbulb) Hints

To check the status of the connection pool

in the Visual Administrator tool choose server<instance_no> > services > JDBC Connector > DataSources > SAP<SYSTEM_ID>DB > Monitoring tab.

If the number of used connections is the same as the number of free connections, then there are no more free connections for new requests. You must increase the number of connections in the connection pool, as described in step 2.1 Resizing the connection pool.

If the number of used connections (number in red) is the less than the number of free connections (number in green), then check the log file for the following error messages.

Service unavailable, cannot serve request. Database connection pool is out of connections. Check connection pool and database settings.
Service unavailable, running background task {0} failed. 
Database connection pool is out of connections. 
Check connection pool and database settings.


To increase the number fo JDBC connections

To resize the connection pool, select server<instance_no> > services > JDBC Connector > DataSources > SAP<SYSTEM_ID>DB > Properties. Change the parameter sysDS.maximumConnections to an appropriate value.

make sure that the value is less than the number of database sessions as defined by the database. To launch the database administrator, using a browser, connect to http://<m/c name>:9999/webdbm and log on.

For Windows platform only, alternatively, you can also use the SAPMMC:

  1. Connect to the required SAP Web AS system and launch the management console (Start > Programs > SAP Management Console) and select the database node.
  2. Select Configuration > Parameters > MAXUSERTASKS. This value gives you the maximum number of simultaneous database sessions.