Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 44 Oracle Analytics and AI Sharing Center
- 19 Oracle Analytics and AI Lounge
- 278 Oracle Analytics and AI News
- 56 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 103 Oracle Analytics and AI Trainings
- 20 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Connection destroyed due to timeout.
Using ODBC connections to SQL Server 2012. We are getting Connection destroyed due to timeout. A lot of them. Every minute. What setting do I need to change to prevent this or is this normal? See below.
2017-04-17T14:23:04.386-04:00] [OBIS] [NOTIFICATION:1] [] [] [ecid: ] [sik: ssi] [tid: 194c] Connection Pool entry for DSN SIEBEL_OLAP_DB64, DB name is Dentsply BI Cube, connection pool name is Connection Pool [[
Properties: description=<<12499895>> DbGateway Exchange: Dentsply BI Cube.Connection Pool; producerID=0x33731a98; requestID=0x6a400fe; sessionID=0x6a40000; userName=DITYX273;
]]
[2017-04-17T14:23:04.386-04:00] [OBIS] [NOTIFICATION:1] [] [] [ecid: ] [sik: ssi] [tid: 1654] Connection Pool entry for DSN SIEBEL_OLAP_DB64, DB name is Dentsply BI Cube, connection pool name is Connection Pool [[
Properties: description=<<12504191>> DbGateway Exchange: Dentsply BI Cube.Connection Pool; producerID=0xb41c12a0; requestID=0x6a400fe; sessionID=0x6a40000; userName=DITYX273;
]]
[2017-04-17T14:23:04.401-04:00] [OBIS] [NOTIFICATION:1] [] [] [ecid: ] [sik: ssi] [tid: 112c] Connection Pool entry for DSN SIEBEL_OLAP_DB64, DB name is Dentsply BI Cube, connection pool name is Connection Pool [[
Properties: description=<<12508588>> DbGateway Exchange: Dentsply BI Cube.Connection Pool; producerID=0xa2110aa8; requestID=0x6a400fe; sessionID=0x6a40000; userName=DITYX273;
]]
[2017-04-17T14:23:04.417-04:00] [OBIS] [NOTIFICATION:1] [] [] [ecid: ] [sik: ssi] [tid: 28c8] Connection Pool entry for DSN SIEBEL_OLAP_DB64, DB name is Dentsply BI Cube, connection pool name is Connection Pool [[
Properties: description=<<12511981>> DbGateway Exchange: Dentsply BI Cube.Connection Pool; producerID=0xd1a50008; requestID=0x6a400fe; sessionID=0x6a40000; userName=DITYX273;
]]
[2017-04-17T14:23:04.839-04:00] [OBIS] [NOTIFICATION:1] [] [] [ecid: ] [sik: ssi] [tid: 9f0] Connection Pool exit for DSN SIEBEL_OLAP_DB64, DB name is Dentsply BI Cube, connection pool name is Connection Pool [[
Properties: description=<<12447902>> DbGateway Exchange: Dentsply BI Cube.Connection Pool; producerID=0xc3390d50; requestID=0x6a400f7; sessionID=0x6a40000; userName=DITYX273;
]]
[2017-04-17T14:23:04.839-04:00] [OBIS] [NOTIFICATION:1] [] [] [ecid: ] [sik: ssi] [tid: 9f0] Connection destroyed due to timeout. dsn is VALUEOF(OLAP_DSN_DB64), DB name is Dentsply BI Cube [[
Properties: description=<<12447902>> DbGateway Exchange: Dentsply BI Cube.Connection Pool; producerID=0xc3390d50; requestID=0x6a400f7; sessionID=0x6a40000; userName=DITYX273;
]]
[2017-04-17T14:23:07.433-04:00] [OBIS] [NOTIFICATION:1] [] [] [ecid: ] [sik: ssi] [tid: 194c] Connection Pool exit for DSN SIEBEL_OLAP_DB64, DB name is Dentsply BI Cube, connection pool name is Connection Pool [[
Properties: description=<<12499895>> DbGateway Exchange: Dentsply BI Cube.Connection Pool; producerID=0x33731a98; requestID=0x6a400fe; sessionID=0x6a40000; userName=DITYX273;
]]
[2017-04-17T14:23:07.433-04:00] [OBIS] [NOTIFICATION:1] [] [] [ecid: ] [sik: ssi] [tid: 194c] Connection destroyed due to timeout. dsn is VALUEOF(OLAP_DSN_DB64), DB name is Dentsply BI Cube [[
Properties: description=<<12499895>> DbGateway Exchange: Dentsply BI Cube.Connection Pool; producerID=0x33731a98; requestID=0x6a400fe; sessionID=0x6a40000; userName=DITYX273;
]]
[2017-04-17T14:23:07.808-04:00] [OBIS] [NOTIFICATION:1] [] [] [ecid: ] [sik: ssi] [tid: 28c8] Connection Pool exit for DSN SIEBEL_OLAP_DB64, DB name is Dentsply BI Cube, connection pool name is Connection Pool [[
Properties: description=<<12511981>> DbGateway Exchange: Dentsply BI Cube.Connection Pool; producerID=0xd1a50008; requestID=0x6a400fe; sessionID=0x6a40000; userName=DITYX273;
]]
[2017-04-17T14:23:07.808-04:00] [OBIS] [NOTIFICATION:1] [] [] [ecid: ] [sik: ssi] [tid: 28c8] Connection destroyed due to timeout. dsn is VALUEOF(OLAP_DSN_DB64), DB name is Dentsply BI Cube [[
Properties: description=<<12511981>> DbGateway Exchange: Dentsply BI Cube.Connection Pool; producerID=0xd1a50008; requestID=0x6a400fe; sessionID=0x6a40000; userName=DITYX273;
]]
[2017-04-17T14:23:09.620-04:00] [OBIS] [NOTIFICATION:1] [] [] [ecid: ] [sik: ssi] [tid: 112c] Connection Pool exit for DSN SIEBEL_OLAP_DB64, DB name is Dentsply BI Cube, connection pool name is Connection Pool [[
Properties: description=<<12508588>> DbGateway Exchange: Dentsply BI Cube.Connection Pool; producerID=0xa2110aa8; requestID=0x6a400fe; sessionID=0x6a40000; userName=DITYX273;
]]
[2017-04-17T14:23:09.636-04:00] [OBIS] [NOTIFICATION:1] [] [] [ecid: ] [sik: ssi] [tid: 112c] Connection destroyed due to timeout. dsn is VALUEOF(OLAP_DSN_DB64), DB name is Dentsply BI Cube [[
Properties: description=<<12508588>> DbGateway Exchange: Dentsply BI Cube.Connection Pool; producerID=0xa2110aa8; requestID=0x6a400fe; sessionID=0x6a40000; userName=DITYX273;
]]
[2017-04-17T14:23:10.495-04:00] [OBIS] [NOTIFICATION:1] [] [] [ecid: ] [sik: ssi] [tid: 1654] Connection Pool exit for DSN SIEBEL_OLAP_DB64, DB name is Dentsply BI Cube, connection pool name is Connection Pool [[
Properties: description=<<12504191>> DbGateway Exchange: Dentsply BI Cube.Connection Pool; producerID=0xb41c12a0; requestID=0x6a400fe; sessionID=0x6a40000; userName=DITYX273;
]]
[2017-04-17T14:23:10.495-04:00] [OBIS] [NOTIFICATION:1] [] [] [ecid: ] [sik: ssi] [tid: 1654] Connection destroyed due to timeout. dsn is VALUEOF(OLAP_DSN_DB64), DB name is Dentsply BI Cube [[
Properties: description=<<12504191>> DbGateway Exchange: Dentsply BI Cube.Connection Pool; producerID=0xb41c12a0; requestID=0x6a400fe; sessionID=0x6a40000; userName=DITYX273;
Answers
-
Hi,
Are you facing any issues with your application? Also what is your OBIEE version and what driver are you using to connect to SQL server?
0 -
Yes were are experiencing performance issues. We are on 12c 12.2.1.1.0. Sql Server 6.03.9600.17415 SQLSRV32.DLL
0 -
Can you elaborate a little bit more about this "performance issue" ? Is it that the reports are running slow, page navigation is slow or are you getting report errors, users getting logged out. etc..
Sometimes a driver bug can cause connection related issues, so an alternative here would be to use the data direct driver included with OBIEE. You can set connection timeout in ODBC configuration, OBIEE RPD and there might be a timeout setting in SQL server. But before making any changes you need to find out what exactly is causing your performance issues.
0 -
Navigation is very slow sometimes, but my biggest concern is the number of records being written to the log file. This is happening almost every minute. I have the pool timeout set to 300 sec.
0 -
user4567292 wrote:Navigation is very slow sometimes, but my biggest concern is the number of records being written to the log file.
Why should this concern you? As far as I can see from the logs you posted, those are just notifications from the BI server and no errors. I do not think that those are causing your navigation slowness. Navigation could be slow because of various factors like browser issues, resource constraints on the server, too much logging etc.. I suggest you read the below excellent article.
0 -
So you believe that these notifications are not an issue?
I have a 12c tuning document but I will read through the 11g one. Thanks.
0 -
I do not see it as an issue for the problem you described. See below for reference
https://docs.oracle.com/middleware/1221/biee/BIESG/logging.htm#BIESG1679
0