My Oracle Support Banner

Error: Could Not Create Pool Connection For Datasource 'TMBISrvConn' (Doc ID 2391233.1)

Last updated on MAY 05, 2018

Applies to:

Oracle Fusion Sales Cloud Service - Version 11.12.1.0.0 and later
Information in this document applies to any platform.

Goal

On : 11.12.1.0.0 version, Opportunities

Error: Could not create pool connection for datasource 'TMBISrvConn'

Users are getting the below error when they do SAVE and RUN opportunity.
To avoid this problem, customer updated the profile option MOT_UNSYNCMEMBER_QUERY_BI value to NO now.


JBO-29000: Unexpected exception caught: oracle.jbo.JboException, msg=JBO-29000: Unexpected exception caught: weblogic.jdbc.extensions.PoolDisabledSQLException, msg=weblogic.common.resourcepool.ResourceDisabledException: Pool TMBISrvConn is suspended. Cannot allocate resources to applications. It was suspended at Fri Dec 22 14:07:32 UTC 2017 because of 2 consecutive connect failures. Last connect attempt failed at Fri Dec 22 15:36:31 UTC 2017 because of weblogic.common.ResourceException: weblogic.common.ResourceException: Could not create pool connection for datasource 'TMBISrvConn'. The DBMS driver exception was: java.io.IOException: Cluster Error: No active server node found.. Last connection created successfully at Thu Dec 21 21:55:19 UTC 2017.JBO-29000: Unexpected exception caught: weblogic.jdbc.extensions.PoolDisabledSQLException, msg=weblogic.common.resourcepool.ResourceDisabledException: Pool TMBISrvConn is suspended. Cannot allocate resources to applications. It was suspended at Fri Dec 22 14:07:32 UTC 2017 because of 2 consecutive connect failures. Last connect attempt failed at Fri Dec 22 15:36:31 UTC 2017 because of weblogic.common.ResourceException: weblogic.common.ResourceException: Could not create pool connection for datasource 'TMBISrvConn'. The DBMS driver exception was: java.io.IOException: Cluster Error: No active server node found.. Last connection created successfully at Thu Dec 21 21:55:19 UTC 2017.: weblogic.common.resourcepool.ResourceDisabledException: Pool TMBISrvConn is suspended. Cannot allocate resources to applications. It was suspended at Fri Dec 22 14:07:32 UTC 2017 because of 2 consecutive connect failures. Last connect attempt failed at Fri Dec 22 15:36:31 UTC 2017 because of weblogic.common.ResourceException: weblogic.common.ResourceExcept

Why does profile option MOT_UNSYNCMEMBER_QUERY_BI need to be set to NO ?
 

Solution

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

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


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