Hi All,

We have webMethods IS7 version, and its frequently (every 15days) going to unavailable state with below error as per logs.

Error:
2014-11-11 01:12:01 EST [ISS.0014.0020I] Available Thread Pool Warning Threshold Exceeded: 14% available
2014-11-11 01:16:51 EST [ISS.0014.0020I] Available Thread Pool Warning Threshold Exceeded: 4% available
2014-11-11 01:16:54 EST [ISS.0014.0020I] Available Thread Pool Warning Threshold Exceeded: 5% available
2014-11-11 01:17:00 EST [ISS.0014.0020I] Available Thread Pool Warning Threshold Exceeded: 0% available
2014-11-11 01:19:19 EST [ISS.0137.0010E] Scheduler: Resources unavailable: [9119] Unable to allocate a new thread in the time specified
2014-11-11 01:19:20 EST [ISS.0137.0010E] Scheduler: Resources unavailable: [9119] Unable to allocate a new thread in the time specified
2014-11-11 01:19:20 EST [ISS.0137.0010E] Scheduler: Resources unavailable: [9119] Unable to allocate a new thread in the time specified

Below are the our IS version & applied fixes:

Version 7.1.2.0
Updates IS_7.1.2_Core_Fix38
TNS_7-1-2_DB_Fix4
TNS_7-1-2_Partner_Fix3

Please let us know If there is any fix or any change required in the server level configuration

Thanks in Advance!

Regards,
Raghu

What is your Server Thread Pool settings on IS and maximum number of connections available in the JDBC pool that is assigned to the ISInternal functional alias.

Hi Mahesh,

we have maximum pool size is 10

JDBC Connection Pool Alias
Alias Name: Embedded Database Pool
Alias Description:
Associated Driver Alias None DataDirect Connect JDBC DB2 Driver DataDirect Connect JDBC Oracle Driver DataDirect Connect JDBC SQL Server Driver Embedded Database Driver
Database URL
User Id
Password
Minimum Connections 1
Maximum Connections 10
Idle Timeout (blank) milliseconds

What is your Server Thread Pool settings on IS and maximum number of connections available in the JDBC pool that is assigned to the ISInternal functional alias?

Screen shots please?

Please check the screenshot as an attachment.
ConnPool.doc (123 KB)

What is your Server Thread Pool settings on IS?

I have attached the screenshot in the doc. below is the same information.
Server Thread Pool
Available Threads 66 % (332 Threads)
Maximum Threads 500
Minimum Threads 50
Available Threads Warning Threshold 15 % (75 Threads)
Scheduler Thread Throttle 75 % (375 Threads)

You have mentioned that you see these messages every 15 days, does this happen on Production server?

How often do you restart the IS? When you see these messages on logs what is the used memory at that point of time?

Are you using the Embedded pool that comes default and assigned to the differrent aliases?

I would say raise the connection max connections to 50 or 100 and tune the Settings–>Resources page the min and max threads for better performance needs.

HTH,
RMG

Yes, Its in production servers.
Embedded dB pool connection is used for ISinternal and Xref.
and we have already server thread pool connection size as below.
Maximum Threads 500
Minimum Threads 50
we are not sure up to what extent we can increase this connection pool size.

What is the db maximum pool? Do you have any external DB connection which you can’t use or depend on rather than using default embedded and this is a production env?

HTH,
RMG