weblogic.jdbc.extensions.PoolDisabledSQLException

We have come across content pool suspended issue in WebLogic as pool got exhausted. All new connections failings and existing connections are running very slow. Which intern created issue in Agile PLM as it is using WebLogic.

weblogic.jdbc.extensions.PoolDisabledSQLException: weblogic.common.resourcepool.ResourceDisabledException: Pool AgileContentPool is Suspended, cannot allocate resources to applications..

        at weblogic.jdbc.common.internal.JDBCUtil.wrapAndThrowResourceException(JDBCUtil.java:265)

        at weblogic.jdbc.jts.Driver.newConnection(Driver.java:900)

        at weblogic.jdbc.jts.Driver.createLocalConnection(Driver.java:220)

        at weblogic.jdbc.jts.Driver.connect(Driver.java:170)

        at weblogic.jdbc.common.internal.RmiDataSource.getConnectionInternal(RmiDataSource.java:523)

        at weblogic.jdbc.common.internal.RmiDataSource.getConnection(RmiDataSource.java:516)

        at weblogic.jdbc.common.internal.RmiDataSource.getConnection(RmiDataSource.java:512)

<2019-09-10 10:38:56,366> <PCMHelperSessionBean_9xz6y2_Impl:ERROR> Session terminated...

To find the root causes examine the thread dumps while the error is occurring and pay attention to stuck thread.

If there are long running queries find out what it is running and users may see ORA-00020: Maximum number of processes reached.

Possible reasons :

1. Database running some custom or un-optimized long running queries
2. Application forgot to release the connection back to pool due to recent config changes, which can result connection leak.
3. Inactive connection timeout value may need to change to support system growth/load.

We have verified at DB level and everything working fine except more connections hanging around and not releasing. After investigation we found that most of the connections going though one server due to recent patch and didn’t update the Pcclient.jnlp, Jndiurl.properties..etc

After updating the config we see that user connections going trough all servers and connection load balance happening as expected and issue has been resolved.

Hope this post helps to resolve Agile Content pool suspended issue.

Thanks,
Satishbabu Gunukula, Oracle ACE

http://www.oracleracexpert.com

Unable to Connect to Published Data Sources When Opening a Downloaded Workbook from Tableau Server

I recently upgraded Tableau server from 9.1.2 to 9.1.3 to fix an issue with Data Server Data source. After upgrade we found below issue during the testing.

While opening a downloaded workbook from tableau server we received “Tableau Server Sign In” but URL greyed out and also URL is not correct as it is replaced by host name.

Normally you should receive a prompt to log in to the Tableau server, instead the server name field default to http://localhost and is unavailable for edit.

When we try to connect we got following error and not able to connect to published data source.

Cannot connect to Tableau Server. Please check the server name and port and try again. Internet communication error: SSL peer certificate or SSH remote key was not OK (analysis-server1)

It looks like the tableau server is not configured to recognize all the alias host names used to connect to the server. I have followed below steps to update the URL and port and able to resolve the issue.


1. Open command prompt as an administrator and go to the Tableau Server bin folder.
cd C:\Program Files\Tableau\Tableau Server\9.1\bin

2. Run the following command:
tabadmin set gateway.public.host "name"

where name is the URL used to connect to Tableau Server. For example:
tabadmin set gateway.public.host "analysis.oracleracexpert.com" 

3. If Tableau Server is configured for SSL, you must also run the following command:
tabadmin set gateway.public.port 443

4. Apply the configuration changes, and restart Tableau Server using following commands
tabadmin config
tabadmin restart

If a load balancer or proxy is in front of Tableau Server, the headers are not set.  Please refer to the following Knowledge Base article for information on the required headers

Reverse Proxy Server URL Reverts to Internal URL

http://kb.tableau.com/articles/issue/reverse-proxy-server-url-reverts-to-internal-url

Regards,

Satishbabu Gunukula, Oracle ACE

http://www.oracleracexpert.com