OBIEE 11g: SmartView 'Cannot connect to the provider' Using Different Active Connection

(Doc ID 1667753.1)

Last updated on SEPTEMBER 28, 2016

Applies to:

Business Intelligence Office Plug-in Option - Version and later
Information in this document applies to any platform.


PowerPoint (pptx) or Excel files (xlsx) saved with a named connection returns the following error if refreshed on a client with different connection : 

Cannot connect to the provider. Make sure it is running in the specified host/port (12152)

This started to occurs from the last SmartView version (no problem with previous or

In previous version of Smartview, it was sufficient to connect to an existing OBIEE private connection (a valid one), authenticate yourself, then refresh the Powerpoint slide/Excel file and at this point SmartView would have used the current opened connection to retrieve data. With the last version refresh of slides created with a different connection than the one created on the current PC client and used to import OBIEE view the first time and will generate the mentioned error.


Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms