Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Connection for Pool "data source" has been closed

Received Response
2263
Views
3
Comments
3167974
3167974 Rank 4 - Community Specialist
edited Aug 13, 2024 5:57PM in Oracle Analytics Cloud and Server

hi,

please do find adminserver log as below:-

####<Aug 17, 2017, 11:01:23,201 AM EDT> <Info> <Common> <192.168.1.32> <192.168.1.32> <[ACTIVE] ExecuteThread: '16' for queue: 'weblogic.kernel.Default (self-tuning)'> <<anonymous>> <> <005LjH4FSvU6uH65vNl3iX000OCT00DLf6> <1502982083201> <[severity-value: 64] [rid: 0:3:1] [partition-id: 0] [partition-name: DOMAIN] > <BEA-000628> <Created "1" resources for pool "DWH", out of which "1" are available and "0" are unavailable.>

####<Aug 17, 2017, 11:01:23,271 AM EDT> <Info> <Common> <192.168.1.32> <192.168.1.32> <[ACTIVE] ExecuteThread: '17' for queue: 'weblogic.kernel.Default (self-tuning)'> <<anonymous>> <> <005LjH4FSsr6uH65vNl3iX000OCT00DLf3> <1502982083271> <[severity-value: 64] [rid: 0:3:1] [partition-id: 0] [partition-name: DOMAIN] > <BEA-000628> <Created "1" resources for pool "DWH", out of which "1" are available and "0" are unavailable.>

####<Aug 17, 2017, 11:01:23,271 AM EDT> <Info> <Common> <192.168.1.32> <192.168.1.32> <[ACTIVE] ExecuteThread: '12' for queue: 'weblogic.kernel.Default (self-tuning)'> <<anonymous>> <> <005LjH4FStE6uH65vNl3iX000OCT00DLf5> <1502982083271> <[severity-value: 64] [rid: 0:3:1] [partition-id: 0] [partition-name: DOMAIN] > <BEA-000628> <Created "1" resources for pool "DWH", out of which "1" are available and "0" are unavailable.>

####<Aug 17, 2017, 11:01:23,274 AM EDT> <Info> <Common> <192.168.1.32> <192.168.1.32> <[ACTIVE] ExecuteThread: '11' for queue: 'weblogic.kernel.Default (self-tuning)'> <<anonymous>> <> <005LjH4FSso6uH65vNl3iX000OCT00DLf2> <1502982083274> <[severity-value: 64] [rid: 0:3:1] [partition-id: 0] [partition-name: DOMAIN] > <BEA-000628> <Created "1" resources for pool "DWH", out of which "1" are available and "0" are unavailable.>

####<Aug 17, 2017, 11:01:26,302 AM EDT> <Info> <JDBC> <192.168.1.32> <192.168.1.32> <[ACTIVE] ExecuteThread: '14' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <c7735a36-45e4-4d93-b51b-8009a297f810-00001fb7> <1502982086302> <[severity-value: 64] [rid: 0] [partition-id: 0] [partition-name: DOMAIN] > <BEA-001128> <Connection for pool "DWH" has been closed.>

####<Aug 17, 2017, 11:01:26,322 AM EDT> <Info> <JDBC> <192.168.1.32> <192.168.1.32> <[ACTIVE] ExecuteThrAead: '14' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <c7735a36-45e4-4d93-b51b-8009a297f810-00001fb7> <1502982086322> <[severity-value: 64] [rid: 0] [partition-id: 0] [partition-name: DOMAIN] > <BEA-001128> <Connection for pool "DWH" has been closed.>

####<Aug 17, 2017, 11:01:26,341 AM EDT> <Info> <JDBC> <192.168.1.32> <192.168.1.32> <[ACTIVE] ExecuteThread: '14' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <c7735a36-45e4-4d93-b51b-8009a297f810-00001fb7> <1502982086341> <[severity-value: 64] [rid: 0] [partition-id: 0] [partition-name: DOMAIN] > <BEA-001128> <Connection for pool "DWH" has been closed.>

####<Aug 17, 2017, 11:01:26,362 AM EDT> <Info> <JDBC> <192.168.1.32> <192.168.1.32> <[ACTIVE] ExecuteThread: '14' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <c7735a36-45e4-4d93-b51b-8009a297f810-00001fb7> <1502982086362> <[severity-value: 64] [rid: 0] [partition-id: 0] [partition-name: DOMAIN] > <BEA-001128> <Connection for pool "DWH" has been closed.>

####<Aug 17, 2017, 11:01:26,382 AM EDT> <Info> <JDBC> <192.168.1.32> <192.168.1.32> <[ACTIVE] ExecuteThread: '14' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <c7735a36-45e4-4d93-b51b-8009a297f810-00001fb7> <1502982086382> <[severity-value: 64] [rid: 0] [partition-id: 0] [partition-name: DOMAIN] > <BEA-001128> <Connection for pool "DWH" has been closed.>

####<Aug 17, 2017, 11:01:26,726 AM EDT> <Info> <Common> <192.168.1.32> <192.168.1.32> <[ACTIVE] ExecuteThread: '12' for queue: 'weblogic.kernel.Default (self-tuning)'> <<anonymous>> <> <005LjH9Naek6uH65vNl3iX000OCT00DLj_> <1502982086726> <[severity-value: 64] [rid: 0:1:1] [partition-id: 0] [partition-name: DOMAIN] > <BEA-000628> <Created "1" resources for pool "DWH", out of which "1" are available and "0" are unavailable.>

####<Aug 17, 2017, 11:11:11,345 AM EDT> <Info> <JDBC> <192.168.1.32> <192.168.1.32> <[ACTIVE] ExecuteThread: '13' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <c7735a36-45e4-4d93-b51b-8009a297f810-00001fb8> <1502982671345> <[severity-value: 64] [rid: 0] [partition-id: 0] [partition-name: DOMAIN] > <BEA-001128> <Connection for pool "PRD" has been closed.>

####<Aug 17, 2017, 11:11:11,346 AM EDT> <Info> <JDBC> <192.168.1.32> <192.168.1.32> <[ACTIVE] ExecuteThread: '13' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <c7735a36-45e4-4d93-b51b-8009a297f810-00001fb8> <1502982671346> <[severity-value: 64] [rid: 0] [partition-id: 0] [partition-name: DOMAIN] > <BEA-001128> <Connection for pool "PRD" has been closed.>

####<Aug 17, 2017, 11:16:03,552 AM EDT> <Info> <Common> <192.168.1.32> <192.168.1.32> <[ACTIVE] ExecuteThread: '11' for queue: 'weblogic.kernel.Default (self-tuning)'> <<anonymous>> <> <005LjHtt_e16uH65vNl3iX000OCT00DMP_> <1502982963552> <[severity-value: 64] [rid: 0:1:1] [partition-id: 0] [partition-name: DOMAIN] > <BEA-000628> <Created "1" resources for pool "DWH", out of which "1" are available and "0" are unavailable.>

####<Aug 17, 2017, 11:16:03,634 AM EDT> <Info> <Common> <192.168.1.32> <192.168.1.32> <[ACTIVE] ExecuteThread: '12' for queue: 'weblogic.kernel.Default (self-tuning)'> <<anonymous>> <> <005LjHtt_eq6uH65vNl3iX000OCT00DMPb> <1502982963634> <[severity-value: 64] [rid: 0:1:1] [partition-id: 0] [partition-name: DOMAIN] > <BEA-000628> <Created "1" resources for pool "DWH", out of which "1" are available and "0" are unavailable.>

####<Aug 17, 2017, 11:16:26,312 AM EDT> <Info> <JDBC> <192.168.1.32> <192.168.1.32> <[ACTIVE] ExecuteThread: '11' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <c7735a36-45e4-4d93-b51b-8009a297f810-00001fb9> <1502982986312> <[severity-value: 64] [rid: 0] [partition-id: 0] [partition-name: DOMAIN] > <BEA-001128> <Connection for pool "DWH" has been closed.>

####<Aug 17, 2017, 11:16:26,342 AM EDT> <Info> <JDBC> <192.168.1.32> <192.168.1.32> <[ACTIVE] ExecuteThread: '11' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <c7735a36-45e4-4d93-b51b-8009a297f810-00001fb9> <1502982986342> <[severity-value: 64] [rid: 0] [partition-id: 0] [partition-name: DOMAIN] > <BEA-001128> <Connection for pool "DWH" has been closed.>

####<Aug 17, 2017, 11:16:26,373 AM EDT> <Info> <JDBC> <192.168.1.32> <192.168.1.32> <[ACTIVE] ExecuteThread: '11' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <c7735a36-45e4-4d93-b51b-8009a297f810-00001fb9> <1502982986373> <[severity-value: 64] [rid: 0] [partition-id: 0] [partition-name: DOMAIN] > <BEA-001128> <Connection for pool "DWH" has been closed.>

####<Aug 17, 2017, 11:26:11,345 AM EDT> <Info> <JDBC> <192.168.1.32> <192.168.1.32> <[ACTIVE] ExecuteThread: '12' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <c7735a36-45e4-4d93-b51b-8009a297f810-00001fba> <1502983571345> <[severity-value: 64] [rid: 0] [partition-id: 0] [partition-name: DOMAIN] > <BEA-001128> <Connection for pool "PRD" has been closed.>

####<Aug 17, 2017, 11:38:12,325 AM EDT> <Info> <Common> <192.168.1.32> <192.168.1.32> <[ACTIVE] ExecuteThread: '14' for queue: 'weblogic.kernel.Default (self-tuning)'> <<anonymous>> <> <005LjJCpA986uH65vNl3iX000OCT00DNX7> <1502984292325> <[severity-value: 64] [rid: 0:1:1] [partition-id: 0] [partition-name: DOMAIN] > <BEA-000628> <Created "1" resources for pool "PRD", out of which "1" are available and "0" are unavailable.>

####<Aug 17, 2017, 11:38:12,328 AM EDT> <Info> <Common> <192.168.1.32> <192.168.1.32> <[ACTIVE] ExecuteThread: '17' for queue: 'weblogic.kernel.Default (self-tuning)'> <<anonymous>> <> <005LjJCpA8a6uH65vNl3iX000OCT00DNX5> <1502984292328> <[severity-value: 64] [rid: 0:1:1] [partition-id: 0] [partition-name: DOMAIN] > <BEA-000628> <Created "1" resources for pool "PRD", out of which "1" are available and "0" are unavailable.>

####<Aug 17, 2017, 11:38:12,329 AM EDT> <Info> <Common> <192.168.1.32> <192.168.1.32> <[ACTIVE] ExecuteThread: '9' for queue: 'weblogic.kernel.Default (self-tuning)'> <<anonymous>> <> <005LjJCpA936uH65vNl3iX000OCT00DNX6> <1502984292329> <[severity-value: 64] [rid: 0:1:1] [partition-id: 0] [partition-name: DOMAIN] > <BEA-000628> <Created "1" resources for pool "PRD", out of which "1" are available and "0" are unavailable.>

####<Aug 17, 2017, 11:41:11,345 AM EDT> <Info> <JDBC> <192.168.1.32> <192.168.1.32> <[ACTIVE] ExecuteThread: '11' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <c7735a36-45e4-4d93-b51b-8009a297f810-00001fbb> <1502984471345> <[severity-value: 64] [rid: 0] [partition-id: 0] [partition-name: DOMAIN] > <BEA-001128> <Connection for pool "PRD" has been closed.>

####<Aug 17, 2017, 11:41:11,348 AM EDT> <Info> <JDBC> <192.168.1.32> <192.168.1.32> <[ACTIVE] ExecuteThread: '11' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <c7735a36-45e4-4d93-b51b-8009a297f810-00001fbb> <1502984471348> <[severity-value: 64] [rid: 0] [partition-id: 0] [partition-name: DOMAIN] > <BEA-001128> <Connection for pool "PRD" has been closed.>

####<Aug 17, 2017, 11:56:11,346 AM EDT> <Info> <JDBC> <192.168.1.32> <192.168.1.32> <[ACTIVE] ExecuteThread: '11' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <c7735a36-45e4-4d93-b51b-8009a297f810-00001fbc> <1502985371346> <[severity-value: 64] [rid: 0] [partition-id: 0] [partition-name: DOMAIN] > <BEA-001128> <Connection for pool "PRD" has been closed.>

####<Aug 17, 2017, 12:00:06,272 PM EDT> <Info> <Common> <192.168.1.32> <192.168.1.32> <[ACTIVE] ExecuteThread: '11' for queue: 'weblogic.kernel.Default (self-tuning)'> <<anonymous>> <> <005LjKQo5b86uH65vNl3iX000OCT00DO^o> <1502985606272> <[severity-value: 64] [rid: 0:2:1] [partition-id: 0] [partition-name: DOMAIN] > <BEA-000628> <Created "1" resources for pool "PRD", out of which "1" are available and "0" are unavailable.>

####<Aug 17, 2017, 12:00:06,554 PM EDT> <Info> <Common> <192.168.1.32> <192.168.1.32> <[ACTIVE] ExecuteThread: '17' for queue: 'weblogic.kernel.Default (self-tuning)'> <<anonymous>> <> <005LjKQo5nR6uH65vNl3iX000OCT00DO^p> <1502985606554> <[severity-value: 64] [rid: 0:3:1] [partition-id: 0] [partition-name: DOMAIN] > <BEA-000628> <Created "1" resources for pool "DWH", out of which "1" are available and "0" are unavailable.>

####<Aug 17, 2017, 12:00:06,595 PM EDT> <Info> <Common> <192.168.1.32> <192.168.1.32> <[ACTIVE] ExecuteThread: '12' for queue: 'weblogic.kernel.Default (self-tuning)'> <<anonymous>> <> <005LjKQo5nt6uH65vNl3iX000OCT00DO^q> <1502985606595> <[severity-value: 64] [rid: 0:2:1] [partition-id: 0] [partition-name: DOMAIN] > <BEA-000628> <Created "1" resources for pool "DWH", out of which "1" are available and "0" are unavailable.>

####<Aug 17, 2017, 12:00:06,642 PM EDT> <Info> <Common> <192.168.1.32> <192.168.1.32> <[ACTIVE] ExecuteThread: '9' for queue: 'weblogic.kernel.Default (self-tuning)'> <<anonymous>> <> <005LjKQo5_16uH65vNl3iX000OCT00DO^m> <1502985606642> <[severity-value: 64] [rid: 0:3:1] [partition-id: 0] [partition-name: DOMAIN] > <BEA-000628> <Created "1" resources for pool "DWH", out of which "1" are available and "0" are unavailable.>

####<Aug 17, 2017, 12:00:06,724 PM EDT> <Info> <Common> <192.168.1.32> <192.168.1.32> <[ACTIVE] ExecuteThread: '11' for queue: 'weblogic.kernel.Default (self-tuning)'> <<anonymous>> <> <005LjKQo5b86uH65vNl3iX000OCT00DO^o> <1502985606724> <[severity-value: 64] [rid: 0:3:1] [partition-id: 0] [partition-name: DOMAIN] > <BEA-000628> <Created "1" resources for pool "DWH", out of which "1" are available and "0" are unavailable.>

####<Aug 17, 2017, 12:00:06,740 PM EDT> <Info> <Common> <192.168.1.32> <192.168.1.32> <[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'> <<anonymous>> <> <005LjKQo5aS6uH65vNl3iX000OCT00DO^n> <1502985606740> <[severity-value: 64] [rid: 0:3:1] [partition-id: 0] [partition-name: DOMAIN] > <BEA-000628> <Created "1" resources for pool "DWH", out of which "1" are available and "0" are unavailable.>

####<Aug 17, 2017, 12:00:11,302 PM EDT> <Info> <JDBC> <192.168.1.32> <192.168.1.32> <[ACTIVE] ExecuteThread: '16' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <c7735a36-45e4-4d93-b51b-8009a297f810-00001fbd> <1502985611302> <[severity-value: 64] [rid: 0] [partition-id: 0] [partition-name: DOMAIN] > <BEA-001128> <Connection for pool "DWH" has been closed.>

####<Aug 17, 2017, 12:00:11,322 PM EDT> <Info> <JDBC> <192.168.1.32> <192.168.1.32> <[ACTIVE] ExecuteThread: '16' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <c7735a36-45e4-4d93-b51b-8009a297f810-00001fbd> <1502985611322> <[severity-value: 64] [rid: 0] [partition-id: 0] [partition-name: DOMAIN] > <BEA-001128> <Connection for pool "DWH" has been closed.>

####<Aug 17, 2017, 12:00:11,352 PM EDT> <Info> <JDBC> <192.168.1.32> <192.168.1.32> <[ACTIVE] ExecuteThread: '16' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <c7735a36-45e4-4d93-b51b-8009a297f810-00001fbd> <1502985611352> <[severity-value: 64] [rid: 0] [partition-id: 0] [partition-name: DOMAIN] > <BEA-001128> <Connection for pool "DWH" has been closed.>

####<Aug 17, 2017, 12:00:11,372 PM EDT> <Info> <JDBC> <192.168.1.32> <192.168.1.32> <[ACTIVE] ExecuteThread: '16' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <c7735a36-45e4-4d93-b51b-8009a297f810-00001fbd> <1502985611372> <[severity-value: 64] [rid: 0] [partition-id: 0] [partition-name: DOMAIN] > <BEA-001128> <Connection for pool "DWH" has been closed.>

####<Aug 17, 2017, 12:00:11,392 PM EDT> <Info> <JDBC> <192.168.1.32> <192.168.1.32> <[ACTIVE] ExecuteThread: '16' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <c7735a36-45e4-4d93-b51b-8009a297f810-00001fbd> <1502985611392> <[severity-value: 64] [rid: 0] [partition-id: 0] [partition-name: DOMAIN] > <BEA-001128> <Connection for pool "DWH" has been closed.>

####<Aug 17, 2017, 12:00:11,923 PM EDT> <Info> <Common> <192.168.1.32> <192.168.1.32> <[ACTIVE] ExecuteThread: '13' for queue: 'weblogic.kernel.Default (self-tuning)'> <<anonymous>> <> <005LjKRU3kf6uH65vNl3iX000OCT00DO_U> <1502985611923> <[severity-value: 64] [rid: 0:1:1] [partition-id: 0] [partition-name: DOMAIN] > <BEA-000628> <Created "1" resources for pool "DWH", out of which "1" are available and "0" are unavailable.>

####<Aug 17, 2017, 12:00:11,924 PM EDT> <Info> <Common> <192.168.1.32> <192.168.1.32> <[ACTIVE] ExecuteThread: '14' for queue: 'weblogic.kernel.Default (self-tuning)'> <<anonymous>> <> <005LjKRU3kP6uH65vNl3iX000OCT00DO_S> <1502985611924> <[severity-value: 64] [rid: 0:1:1] [partition-id: 0] [partition-name: DOMAIN] > <BEA-000628> <Created "1" resources for pool "DWH", out of which "1" are available and "0" are unavailable.>

####<Aug 17, 2017, 12:00:11,938 PM EDT> <Info> <Common> <192.168.1.32> <192.168.1.32> <[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'> <<anonymous>> <> <005LjKRU3nC6uH65vNl3iX000OCT00DO_V> <1502985611938> <[severity-value: 64] [rid: 0:1:1] [partition-id: 0] [partition-name: DOMAIN] > <BEA-000628> <Created "1" resources for pool "DWH", out of which "1" are available and "0" are unavailable.>

####<Aug 17, 2017, 12:00:11,938 PM EDT> <Info> <Common> <192.168.1.32> <192.168.1.32> <[ACTIVE] ExecuteThread: '12' for queue: 'weblogic.kernel.Default (self-tuning)'> <<anonymous>> <> <005LjKRU3np6uH65vNl3iX000OCT00DO_W> <1502985611938> <[severity-value: 64] [rid: 0:1:1] [partition-id: 0] [partition-name: DOMAIN] > <BEA-000628> <Created "1" resources for pool "DWH", out of which "1" are available and "0" are unavailable.>

####<Aug 17, 2017, 12:00:11,939 PM EDT> <Info> <Common> <192.168.1.32> <192.168.1.32> <[ACTIVE] ExecuteThread: '8' for queue: 'weblogic.kernel.Default (self-tuning)'> <<anonymous>> <> <005LjKRU3kV6uH65vNl3iX000OCT00DO_T> <1502985611939> <[severity-value: 64] [rid: 0:1:1] [partition-id: 0] [partition-name: DOMAIN] > <BEA-000628> <Created "1" resources for pool "DWH", out of which "1" are available and "0" are unavailable.>

####<Aug 17, 2017, 12:00:38,993 PM EDT> <Info> <Diagnostics> <192.168.1.32> <192.168.1.32> <[ACTIVE] ExecuteThread: '12' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <c7735a36-45e4-4d93-b51b-8009a297f810-00001fbe> <1502985638993> <[severity-value: 64] [rid: 0] [partition-id: 0] [partition-name: DOMAIN] > <BEA-320143> <Scheduled 1 data retirement tasks as per configuration.>

####<Aug 17, 2017, 12:00:38,993 PM EDT> <Info> <Diagnostics> <192.168.1.32> <192.168.1.32> <[ACTIVE] ExecuteThread: '8' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <c7735a36-45e4-4d93-b51b-8009a297f810-00001fbf> <1502985638993> <[severity-value: 64] [rid: 0] [partition-id: 0] [partition-name: DOMAIN] > <BEA-320144> <Size based data retirement operation started on archive HarvestedDataArchive.>

####<Aug 17, 2017, 12:00:39,896 PM EDT> <Info> <Diagnostics> <192.168.1.32> <192.168.1.32> <[ACTIVE] ExecuteThread: '8' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <c7735a36-45e4-4d93-b51b-8009a297f810-00001fbf> <1502985639896> <[severity-value: 64] [rid: 0] [partition-id: 0] [partition-name: DOMAIN] > <BEA-320145> <Size based data retirement operation completed on archive HarvestedDataArchive. Retired 8,160 records in 903 ms.>

####<Aug 17, 2017, 12:00:39,896 PM EDT> <Info> <Diagnostics> <192.168.1.32> <192.168.1.32> <[ACTIVE] ExecuteThread: '8' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <c7735a36-45e4-4d93-b51b-8009a297f810-00001fbf> <1502985639896> <[severity-value: 64] [rid: 0] [partition-id: 0] [partition-name: DOMAIN] > <BEA-320144> <Size based data retirement operation started on archive EventsDataArchive.>

####<Aug 17, 2017, 12:00:39,896 PM EDT> <Info> <Diagnostics> <192.168.1.32> <192.168.1.32> <[ACTIVE] ExecuteThread: '8' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <c7735a36-45e4-4d93-b51b-8009a297f810-00001fbf> <1502985639896> <[severity-value: 64] [rid: 0] [partition-id: 0] [partition-name: DOMAIN] > <BEA-320145> <Size based data retirement operation completed on archive EventsDataArchive. Retired 0 records in 0 ms.>

I am getting the error "connection for pool "DWH &PRD" are closed.  i have defined these data sources on weblogic server which is able to make connection successfully.looks like  weblogic tries but connection  is immediately close when there is multiple incoming request. please suggest what needs to  be done to recover from this error.

Answers

  • Syedsalmancs110
    Syedsalmancs110 Rank 6 - Analytics Lead

    In my understanding It is not an error please check Weblogic Product Documentation on same.


    Understanding JDBC Data Sources

    If your JDBC Data Sources would have been actually failing then there would have been error message reported for same but in your attached there are no error messgae just information on what weblogic server is doing with respect to jdbc data sources.

  • 3167974
    3167974 Rank 4 - Community Specialist

    Hi Salman,

    but why i m getting the DWH database has been closed. why the weblogic is closing the session.

  • Syedsalmancs110
    Syedsalmancs110 Rank 6 - Analytics Lead

    I am pointing to the text from the document again.

    In WebLogic Server, you configure database connectivity by adding data sources to your WebLogic domain. WebLogic JDBC data sources provide database access and database connection management. Each data source contains a pool of database connections that are created when the data source is created and at server startup. Applications reserve a database connection from the data source by looking up the data source on the JNDI tree or in the local application context and then calling getConnection().When finished with the connection, the application should call connection.close() as early as possible, which returns the database connection to the pool for other applications to use.