IBM Support

Unable to connect to datasource defds using a pooled database connection

News


Abstract

The error message "Unable to connect to datasource defds using a pooled database connection" appear very frequently on the as-server.log and as-summary.log.

What can I do?

Content

Whenever you faced with the above problem, the usual step is to check on your java setting whether is it too low.

You may want to run the check the memory capacity of the Java by running the following command:-


/usr/jdk/latest/bin/jstat -gccapacity <PID ID of AS server>

Sample output

NGCMN NGCMX NGC S0C S1C EC OGCMN OGCMX OGC OC PGCMN PGCMX PGC PC YGC FGC


393216,0 393216,0 393216,0 62400,0 46144,0 270464,0 655360,0 655360,0 655360,0 655360,0 16384,0 98304,0 61440,0 61440,0 1411 2459

If the OGCMN setting is too low, you may want to consider increase it by the instructions below -


Jave Virtual Machine Memory settings for the application server can be adjusted using the following steps
1) Go to the $WMCROOT/conf/as directory and edit the jvm-default.ini file if the current value is set as :
-Xms1024m -Xmx1024m -XX:+AggressiveHeap -XX:MaxPermSize=96m
To
-Xms2048m -Xmx2048m -XX:+AggressiveHeap -XX:MaxPermSize=96m

where the following parameters indicate the required memory settings:
-Xms<start memory size in MB>m -Xmx<max memory size in MB>m
It is still highly recommended to set the start and maximum memory size to the same value for optimal performance.

2) Stop the AS server
Sap Stop AS
3) Restart the AS serving
Sap Start AS

4) Check the memory capacity of the Java again by running the following command:-
/usr/jdk/latest/bin/jstat -gccapacity <PID ID of AS server>

And you will notice that the Old Capacity(OGCMN) value had been increase to
1310720KB

NGCMN NGCMX NGC S0C S1C EC OGCMN OGCMX
OGC OC PGCMN PGCMX PGC PC YGC FGC
786432,0 786432,0 786432,0 99712,0 98176,0 588544,0 1310720,0 1310720,0
1310720,0 1310720,0 16384,0 98304,0 61440,0 61440,0 1556 1094

5) Lastly monitor the as-server.log and there should be no error related to the following error message:-
foracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)

After increase the java setting and yet you still get the same error OR your setting of java is already too high and error still persist, then

1. Bounce the Application server ( sap stop AS ; sap start AS )

2. Contact IBM support.

[{"Product":{"code":"SSKGHX","label":"Tivoli Netcool Performance Manager for Wireless"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Not Applicable","Platform":[{"code":"PF027","label":"Solaris"},{"code":"PF016","label":"Linux"},{"code":"PF002","label":"AIX"}],"Version":"1.3","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]

Document Information

Modified date:
23 June 2018

UID

swg21568310