My Oracle Support Banner

Siebel Java Data Bean Connection Pooling (Doc ID 1555432.1)

Last updated on JUNE 30, 2023

Applies to:

Siebel CRM - Version 8.0.0.5 SIA [20420] and later
Information in this document applies to any platform.

Symptoms

Using Self Care Application's built-in JAVA and all the services from Siebel are integrated via JDB Mechanism to perform Stateless and Stateful operations.

Following are the Properties in Siebel Properties File

siebel.conmgr.poolsize = 27
siebel.conmgr.txtimeout= 1800000 Milli Sec
siebel.conmgr.sesstimeout = 3600 Sec



Example: When Stateless transaction is getting called to fetch the Account data, in random occasion, the following errors are Returned to U.I From Siebel:
Yhteysvaranto on tyhjä eikä yhteyttä voitu muodostaa.(SBL-JCA-00310). SBL-JCA-00310-The connection pool is empty and no connection could be created.


Question 1: Why does this below error occurs? Is the Connection Pool Size in Siebel full?

Object Manger is Enabled in 2 Servers below are the details

MinSharedDbConns 199, MinTrxDbConns 10
MinUpTime 60
MinWorkQThreads 0
MaxSharedDbConns 199
MaxMTServers 2
MaxMTTasks - 200


Note: All Siebel Server up and running, and Max task not reached for the Siebel Component.


Question 2:The same transaction working again

For example, if QueryAccount initiated again it works. Is this happening due to Timeout Issues?


Question 3: Per Bookshelf siebel.conmgr.poolsize can be set between 2 to 500.

What is the thumb rule to Calculate this Property?

Is this Parameter setting causing this issue?

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.