This discussion is archived
4 Replies Latest reply: Sep 17, 2013 3:49 AM by 972017 RSS

Issue in Soa Server

972017 Newbie
Currently Being Moderated

Hi all ,

 

    I start soaserver but i get below error please help on this issue ....

 

 

[2013-09-16T11:13:41.088+00:00] [soa_server1] [ERROR] [] [oracle.integration.platform.blocks.scheduler.FabricJobStoreCMT] [tid: QuartzScheduler_FabricScheduler-EPGCRMITG11379278343828_ClusterManager] [userId: <anonymous>] [ecid: 0000K4ZOR2WE^M4pzSXBiW1IDXoI000002,0] [APP: soa-infra] ClusterManager: Error managing cluster: Failed to obtain DB connection from data source 'soaNonManagedDS': java.sql.SQLException: Could not retrieve datasource via JNDI url 'jdbc/SOALocalTxDataSource' weblogic.jdbc.extensions.PoolDisabledSQLException: weblogic.common.resourcepool.ResourceDisabledException: Pool SOALocalTxDataSource is Suspended, cannot allocate resources to applications..[[

org.quartz.JobPersistenceException: Failed to obtain DB connection from data source 'soaNonManagedDS': java.sql.SQLException: Could not retrieve datasource via JNDI url 'jdbc/SOALocalTxDataSource' weblogic.jdbc.extensions.PoolDisabledSQLException: weblogic.common.resourcepool.ResourceDisabledException: Pool SOALocalTxDataSource is Suspended, cannot allocate resources to applications.. [See nested exception: java.sql.SQLException: Could not retrieve datasource via JNDI url 'jdbc/SOALocalTxDataSource' weblogic.jdbc.extensions.PoolDisabledSQLException: weblogic.common.resourcepool.ResourceDisabledException: Pool SOALocalTxDataSource is Suspended, cannot allocate resources to applications..]

    at org.quartz.impl.jdbcjobstore.JobStoreCMT.getNonManagedTXConnection(JobStoreCMT.java:167)

    at org.quartz.impl.jdbcjobstore.JobStoreSupport.doCheckin(JobStoreSupport.java:3167)

    at org.quartz.impl.jdbcjobstore.JobStoreSupport$ClusterManager.manage(JobStoreSupport.java:3811)

    at org.quartz.impl.jdbcjobstore.JobStoreSupport$ClusterManager.run(JobStoreSupport.java:3847)

Caused by: java.sql.SQLException: Could not retrieve datasource via JNDI url 'jdbc/SOALocalTxDataSource' weblogic.jdbc.extensions.PoolDisabledSQLException: weblogic.common.resourcepool.ResourceDisabledException: Pool SOALocalTxDataSource is Suspended, cannot allocate resources to applications..

    at org.quartz.utils.JNDIConnectionProvider.getConnection(JNDIConnectionProvider.java:166)

    at org.quartz.utils.DBConnectionManager.getConnection(DBConnectionManager.java:112)

    at org.quartz.impl.jdbcjobstore.JobStoreCMT.getNonManagedTXConnection(JobStoreCMT.java:164)

    ... 3 more

 

Thank you,

Ramesh

  • 1. Re: Issue in Soa Server
    PuneetRekhade Journeyer
    Currently Being Moderated

    It clearly says about "SOALocalTxDataSource". Login to Admin Console and check if the data-source configuration is ok.

    Check, if you are able to connect the schema using the username/password as given in the weblogic admin console.

    This might help.

  • 2. Re: Issue in Soa Server
    972017 Newbie
    Currently Being Moderated

    hi Puneet,

     

    Thanks for your reply. still same problam Actually we are working for Banking Project. We are using WebLogic Server 10.3.6 .we are getting an error in the production Server saying that " pool is suspended, can not allocate resources to the applications". we are getting this error 5 to 10 times per a day.

     

     

    [2013-09-16T14:03:09.497+00:00] [soa_server1] [ERROR] [] [oracle.soa.bpel.engine] [tid: [ACTIVE].ExecuteThread: '9' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: <anonymous>] [ecid: 6a64a370db9cb4a0:529f4aed:14126e5325a:-8000-00000000000075da,0:11] [WEBSERVICE_PORT.name: ProcessEcoContactReqABCSImpl_pt] [APP: soa-infra] [composite_name: ProcessEcoContactReqABCSImpl] [component_name: EcoContactReadAdpter] [component_instance_id: AADFA6C01ED811E3BF070FAC4AF8BE7D] [J2EE_MODULE.name: fabric] [WEBSERVICE.name: ProcessEcoContactReqABCSImpl] [J2EE_APP.name: soa-infra] [composite_instance_id: 247325] Got a FatalConnectionException[[

    java.sql.SQLException: Internal error: Cannot obtain XAConnection weblogic.common.resourcepool.ResourceDisabledException: Pool SOADataSource is Suspended, cannot allocate resources to applications..

        at weblogic.common.resourcepool.ResourcePoolImpl.reserveResourceInternal(ResourcePoolImpl.java:378)

        at weblogic.common.resourcepool.ResourcePoolImpl.reserveResource(ResourcePoolImpl.java:343)

        at weblogic.jdbc.common.internal.ConnectionPool.reserve(ConnectionPool.java:471)

        at weblogic.jdbc.common.internal.ConnectionPool.reserve(ConnectionPool.java:363)

        at weblogic.jdbc.common.internal.ConnectionPoolManager.reserve(ConnectionPoolManager.java:125)

        at weblogic.jdbc.common.internal.ConnectionPoolManager.reserve(ConnectionPoolManager.java:77)

        at weblogic.jdbc.jta.DataSource.getXAConnectionFromPool(DataSource.java:1751)

        at weblogic.jdbc.jta.DataSource.refreshXAConnAndEnlist(DataSource.java:1515)

        at weblogic.jdbc.jta.DataSource.getConnectionInternal(DataSource.java:478)

        at weblogic.jdbc.jta.DataSource.getConnection(DataSource.java:462)

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

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

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

        at org.eclipse.persistence.sessions.JNDIConnector.connect(JNDIConnector.java:123)

        at org.eclipse.persistence.sessions.DatasourceLogin.connectToDatasource(DatasourceLogin.java:162)

        at org.eclipse.persistence.internal.databaseaccess.DatasourceAccessor.connectInternal(DatasourceAccessor.java:330)

        at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.connectInternal(DatabaseAccessor.java:293)

        at org.eclipse.persistence.internal.databaseaccess.DatasourceAccessor.reconnect(DatasourceAccessor.java:565)

        at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.reconnect(DatabaseAccessor.java:1508)

        at org.eclipse.persistence.internal.databaseaccess.DatasourceAccessor.incrementCallCount(DatasourceAccessor.java:305)

        at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:579)

        at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:535)

        at org.eclipse.persistence.internal.sessions.AbstractSession.basicExecuteCall(AbstractSession.java:1717)

     

     

    Could you please suggest me How to solve this issue ?  please assist me sir.please give me an idea how to solve this one.

     

    Thank you,

    Ram

  • 3. Re: Issue in Soa Server
    PuneetRekhade Journeyer
    Currently Being Moderated

    Try increasing the database pool quota from admin console, and see, if still you are getting the same error.

  • 4. Re: Issue in Soa Server
    972017 Newbie
    Currently Being Moderated

    HI ,

     

    here  still fails below error. Do you have a view on what is wrong? I am mentioning some of the data source properties currently set and when i go to check the adminconsole >Summary of JDBC Data Sources >EDNDataSource >SOALocalTxDataSource>Monitoring>testing state is "Suspended" mode. how can we do  runing mode

     

     

    <Sep 17, 2013 9:05:47 AM GMT> <Error> <oracle.integration.platform.blocks.scheduler.FabricJobStoreCMT> <EPGCRMITG1> <soa_server1> <QuartzScheduler_FabricScheduler-EPGCRMITG11379355699844_ClusterManager> <<anonymous>> <> <0000K4bzW18E^M4pzSXBiW1IDogw000002> <1379408747717> <BEA-000000> <ClusterManager: Error managing cluster: Failed to obtain DB connection from data source 'soaNonManagedDS': java.sql.SQLException: Could not retrieve datasource via JNDI url 'jdbc/SOALocalTxDataSource' weblogic.jdbc.extensions.PoolDisabledSQLException: weblogic.common.resourcepool.ResourceDisabledException: Pool SOALocalTxDataSource is Suspended, cannot allocate resources to applications..

    org.quartz.JobPersistenceException: Failed to obtain DB connection from data source 'soaNonManagedDS': java.sql.SQLException: Could not retrieve datasource via JNDI url 'jdbc/SOALocalTxDataSource' weblogic.jdbc.extensions.PoolDisabledSQLException: weblogic.common.resourcepool.ResourceDisabledException: Pool SOALocalTxDataSource is Suspended, cannot allocate resources to applications.. [See nested exception: java.sql.SQLException: Could not retrieve datasource via JNDI url 'jdbc/SOALocalTxDataSource' weblogic.jdbc.extensions.PoolDisabledSQLException: weblogic.common.resourcepool.ResourceDisabledException: Pool SOALocalTxDataSource is Suspended, cannot allocate resources to applications..]

        at org.quartz.impl.jdbcjobstore.JobStoreCMT.getNonManagedTXConnection(JobStoreCMT.java:167)

        at org.quartz.impl.jdbcjobstore.JobStoreSupport.doCheckin(JobStoreSupport.java:3167)

        at org.quartz.impl.jdbcjobstore.JobStoreSupport$ClusterManager.manage(JobStoreSupport.java:3811)

        at org.quartz.impl.jdbcjobstore.JobStoreSupport$ClusterManager.run(JobStoreSupport.java:3847)

    Caused By: java.sql.SQLException: Could not retrieve datasource via JNDI url 'jdbc/SOALocalTxDataSource' weblogic.jdbc.extensions.PoolDisabledSQLException: weblogic.common.resourcepool.ResourceDisabledException: Pool SOALocalTxDataSource is Suspended, cannot allocate resources to applications..

        at org.quartz.utils.JNDIConnectionProvider.getConnection(JNDIConnectionProvider.java:166)

        at org.quartz.utils.DBConnectionManager.getConnection(DBConnectionManager.java:112)

        at org.quartz.impl.jdbcjobstore.JobStoreCMT.getNonManagedTXConnection(JobStoreCMT.java:164)

        at org.quartz.impl.jdbcjobstore.JobStoreSupport.doCheckin(JobStoreSupport.java:3167)

        at org.quartz.impl.jdbcjobstore.JobStoreSupport$ClusterManager.manage(JobStoreSupport.java:3811)

        at org.quartz.impl.jdbcjobstore.JobStoreSupport$ClusterManager.run(JobStoreSupport.java:3847)

     

    /SOALocalTxDataSource Datasource Properties set:



    Initial Capacity: 0

    Maximum Capacity: 100

    Minimum Capacity: 0

    Connection Creation Retry: 10

    Login Delay: 0

    Test Connections on Reserve: Checked

    Test Frequency: 300

    Seconds to Trust Idle pool connection: 0

    Shrink Frequency:900


    Is there a solution for this problem? please ....


    Thnk you,

    ram

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points