My Oracle Support Banner

Connection has failed error message when doing view data in OBIEE 11g rpd (Doc ID 1234535.1)

Last updated on FEBRUARY 24, 2019

Applies to:

Business Intelligence Server Enterprise Edition - Version [1905] and later
Information in this document applies to any platform.


Issue seen : Opening rpd in offline mode causes "Connection has failed" error message when performing "View Data" in physical layer of rpd.
Same connection to database from rpd works fine when opening rpd in online mode


1)upgrade rpd from 10g to 11g
2) open upgraded rpd in offline mode
3) do update row count OR import any table - gives "connection has failed"
4) tried creating new connection pool - doesnt work
5) The information provided in connection pool is correct
6) If we build a new rpd using 11g everything works - update rowcount works,
import works
Issue specific to upgraded rpd


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.