Product: TIBCO Spotfire®
Error, "Unable to open analysis" received in TIBCO Spotfire Web Player when opening a report that uses data from a Spotfire Data Connector.
Product: TIBCO Spotfire Web Player (incl. Consumer and Business Author)
Version: 7.0 and earlier
OS: All Supported Operating Systems
When using TIBCO Spotfire Web Player to open a report that has data tables based on data connectors, the following error is thrown (where '/myFolder/MyReport' is the Spotfire Library path to your analysis file).
• Unable to open analysis '/myFolder/MyReport'.
In the Spotfire.Dxp.Web.Log error:
=====================================
ERROR 2016-03-08 07:19:52,539 [nxow0vwe0dkpkuscm0sjsxfr, 2960, 50, NBKVSMJ] Spotfire.Dxp.Web.Forms.Error - ClientError: Unable to open analysis '/myFolder/MyReport'.
System.InvalidOperationException: Adapter authentication mode configuration is missing in web.config.
=====================================
This will normally be seen with the following data connectors.
• ClouderaHive
• DB2
• Greenplum
• Hana
• Hortonworks
• Impala
• OData
• PivotalHd
• Redshift
• Salesforce
• SparkSql
• TeradataAster
• Vertica
For each data connector to work with TIBCO Spotfire Web Player, the corresponding data adapter settings must be present in that Web Player instance's web.config file. The adapter settings for the following data connectors are not present in the web.config file by default, and must be added manually.
• ClouderaHive
• DB2
• Greenplum
• Hana
• Hortonworks
• Impala
• OData
• PivotalHd
• Redshift
• Salesforce
• SparkSql
• TeradataAster
• Vertica
In the web.config file, you will see the following adapter settings by default:
=====================================
...
...
=====================================
In the adapters node, you need to add the adapter you require access to in the Web Player. The format follows.
•
Here are some sample lines for the available data connectors.
•
•
•
•
•
•
•
•
•
•
•
•
•
For example, if you are adding an OData adapter, the web.config will resemble the following.
=====================================
...
...
=====================================
Steps:
1). Edit the web.config in a plain text editor.
2). Update the adapter settings as described above and per the manual.
3). Save the web.config file.
4). Restart IIS or the TIBCO Spotfire Web Player application pool.
Installation and Configuration Manual.
• URL: https://docs.tibco.com/pub/spotfire_web_player/7.0.1/doc/pdf/TIB_sfire_webp_7.0.1_installation.pdf
• Chapter: 6.4 Data from External Sources
• Excerpt: TIBCO Spotfire can access data directly from several external data sources using the Spotfire Data Connectors. To be able to use analyses with data from these sources in Spotfire Web Player, you must specify the authentication method in the web.config file for how users will connect to the external data sources.