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!

Error retrieving data in Oracle BI 11g from DB2 AS/400

ddekockMar 16 2011 — edited Apr 18 2011

Hello everybody,

In my Oracle BI 11g environment I want to have data coming from a DB2 AS/400 database. Retrieving the tables from the database in BI Administration and building the repository works fine. But as soon as I want to see the data (from the BI Administration or BI Answers) I get the following error (in BI Answers):

+Description: System.Data.Odbc.OdbcException: ERROR [08S01] [IBM][iSeries Access ODBC Driver]Communication link failure. comm rc=11004 - CWBCO1011 - Remote port could not be resolved+

I tried some different settings (ODBC Basis, ODBC Advanced and AS/400) as a databasetype and different type of connections (ODBC 2.0 and ODBC 3.5) in the connection pool. But non of the settings seems to solve the problem.

When I try to query the database using another tool, Oracle Interactive Reporting, everything works fine as long as I use ODBC as both database- and connectiontype.

Does anybode got an idea how this can be solved/where to look for a solution?

Thanks in advance!

With regards,

Dennis de Kock

Locked Post

New comments cannot be posted to this locked post.

Locked on May 16 2011

Added on Mar 16 2011

#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee

3 comments

386 views