OBIEE 11g: SmartView 'Cannot connect to the provider' Using Different Active Connection
Last updated on SEPTEMBER 28, 2016
Applies to:Business Intelligence Office Plug-in Option - Version 220.127.116.11.1 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 :
This started to occurs from the last SmartView version 18.104.22.168.200 (no problem with previous 22.214.171.124 or 126.96.36.199).
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 188.8.131.52.200 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