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!

How to create one Connection Pool for Two Different Databases in OBIEE

2850269Feb 9 2015 — edited Feb 13 2015

Hi,

I have a requirement where few reports come from one database and few other from another database. I created two connection pools and added the dataabse connection details. But when I created the report I get the error as below.

State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 17001] Oracle Error code: 942, message: ORA-00942: table or view does not exist at OCI call OCIStmtExecute. [nQSError: 17010] SQL statement preparation failed. (HY000)

Now, I would like to see if I can create one connection pool for two different databases.If so, how can that be done.

Thanks!
This post has been answered by Gianni Ceresa on Feb 12 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 13 2015
Added on Feb 9 2015
#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee
26 comments
6,108 views