Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 16 Oracle Analytics Lounge
- 216 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 79 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations 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