Skip to Main Content
Forums

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Strange Essbase Errors

AM_1Dec 25 2008 — edited Jan 12 2009
Hello experts,

I'm developing OBIEE reports based on EssBase cubes.

Sometimes (for certain reports / prompts) I get following error messages

State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. Essbase Error: Invalid login id - request [EssSetActive] failed (HY000)

State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. Essbase Error: message on contacting or from application [PNL_APP] server: [Thu Dec 25 14:25:53 2008]Local////Error(1013080) Already Connected to Server -- The previous connected request still running, try again (HY000)

My connection pool configuration:

Call interface: Essbase
Maximum connections: 10
Shared logon: True (a single user / password used for all queries)
Use Session: True (also tried false - doesn't help)
Use multithreaded connections: True

Does anybody have an idea - what causes these problems and how can I prevent them?

Thanks,
Alex

Edited by: AM_1 on 04:52 25/12/2008
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 9 2009
Added on Dec 25 2008
#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee, #essbase
6 comments
1,623 views