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 issue with Essbase from OBIEE RPD
Hi All,
Essbase 11.1.2.3.500
OBIEE 12.2.1.1.0
We use OBIEE as reporting tool and connect to Essbase to pull some data via OBIEE rpd. Recently we are receiving below mentioned error in random while running the report. Report ran fine for majority of the users, some users receive this error message randomly. I have attached the screenshot of the Essbase connection pool in OBIEE RPD. Please let me know how to debug this issue.
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. (HY000)
State: HY000. Code: 43113. [nQSError: 43113] Message returned from OBIS. (HY000)
State: HY000. Code: 43119. [nQSError: 43119] Query Failed: (HY000)
State: HY000. Code: 96002. [nQSError: 96002] Essbase Error: You have been logged out by supervisor [CONSOLE], please login again (HY000)
obis log
[2017-09-18T18:55:31.504+00:00] [OBIS] [NOTIFICATION:1] [] [] [ecid: ] [sik: ssi] [tid: 1360] Connection Pool entry for DSN atl-02, DB name is Ess-Clar, connection pool name is Ess-Clar Connection Pool [[
Properties: description=<<2055318233>> DbGateway Exchange: Ess-Clar.Ess-Clar Connection Pool; producerID=0x2fea0800; requestID=0x39a30007; sessionID=0x39a30000; userName=user1;
]]
[2017-09-18T18:55:31.504+00:00] [OBIS] [ERROR:1] [] [] [ecid: ] [sik: ssi] [tid: 1360] [nQSError: 96002] Essbase Error: You have been logged out by supervisor [CONSOLE], please login again [[
file: server\Query\Execution\DbGateway\DbGatewayEssbaseCAPI\Src\SQXDGEssbaseCAPIConnection.cpp; line: 553
Properties: description=<<2055318233>> DbGateway Exchange: Ess-Clar.Ess-Clar Connection Pool; producerID=0x2fea0800; requestID=0x39a30007; sessionID=0x39a30000; userName=user1;
Essabse Log
[2017-09-18T14:55:31.71-04:00] [ESSBASE0] [NOTIFICATION:16] [TCP-59] [] [ecid: 1498233796338,0] [tid: 988] Connected from [::ffff:192.32.170.189]
[2017-09-18T14:55:31.71-04:00] [ESSBASE0] [WARNING:1] [AGENT-1003] [] [ecid: 1498233796338,0] [tid: 988] Error -1 processing request [Logout] - disconnecting
[2017-09-18T14:55:31.87-04:00] [ESSBASE0] [NOTIFICATION:16] [TCP-59] [] [ecid: 1498233796338,0] [tid: 3924] Connected from [::ffff:192.32.170.189]
[2017-09-18T14:55:31.87-04:00] [ESSBASE0] [WARNING:1] [AGENT-1003] [] [ecid: 1498233796338,0] [tid: 3924] Error -1 processing request [Logout] - disconnecting
Answers
-
This can happen when you use connection pooling or just have session keep-alive times which are longer on OBIEE and shorter on Essbase.
Ref MOS Doc ID 1384729.1
0 -
Hi Christian,
Thanks for the reply. How can I find the session keep-alive times in OBIEE ? Is it the ClientSessionExpireMinutes in instanceconfig.xml ?
What would be better approach ? Disable connection pooling or increase the session timeout in Essbase ?
Thanks !
0 -
I wouldn't turn off pooling if you're using connection with a technical account instead of named user accounts. Find out how long sessions are alowed to remain alive on both sides first and then take a decision. Unless you have full control over the systems you'll probably need to talk with the admins as well since normally they aren't super keen on changing such critical settings just like that.
tl;dr - increasing things in the essbase side is better
0 -
I monitored the session on essbase side. What I observed is the OBIEE session is terminated on Essbase side after the connection pool timeout.
0 -
Also this error occurs to User as soon as he login and run the report.
0 -
Probably because his request is trying to use an existing connection that OBI has with Essbase but it's actually time out in the meantime
0 -
Hi Ebin,
I know you came here for help, but would you mind answering a question, if you compare a like for like query when using Smart View with the performance that you get running the same query through OBIEE to Essbase what kind of performance do you experience?
The reason I ask is that a number of years back I was on a project with OBIEE / Essbase as a deliverable and reports which would render in short minutes in Smart View took long hours in OBIEE.
I am curious if this was due to the architecture on the project I was on or if this is truly the best performance you can currently get out of the Essbase / OBIEE combination.
At the time I wound up creating an export of data and metadata, recreating it all in an RDBMS with suitable indexing and getting a solution which was exponentially faster and considerably less frustrating to write queries against.
In my mental notebook I have the words Essbase / OBIEE and 'never again' - has the world improved since then or is my experience not representative?
thanks for your comments!
0 -
At least from my experience I can say: "not representative".
I have done Essbase integration since 10.1.3.2, the first very to support it. Performance was never the killer of the cube outlines and logical models made sense in terms of hypercubes designed for analytical access. If the cubes were extremely sparse and used dynamic calcs all over the place performance was as bad as is to be expected. That said the performance was bad both through OBI and SmartView.
0 -
Thanks, mine might have been a more extreme example as data was coming from HPCM...
0 -
Hi Robert,
We don't have any performance issue. The only issue is sometimes when user login, they see the error message as given in the problem description. We have OBIEE connection pool timeout of 5 minute specified. I monitored the essbase session and could see the sessions getting disconnected.
I will try to increase the session timeout limit in Essbase as Christian suggested. I will update the results.
0