Products | Versions |
---|---|
Spotfire Web Player | 7.0 and lower |
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.
- ClouderaHiveFor 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... <Spotfire.Dxp.Data.Access.Adapters.Settings> <!-- Different authentication modes can be set up for the various data sources. Valid modes are: WebConfig To connect with credentials stored in Spotfire.Dxp.Web.Properties.Settings/DataAdapterCredentials below. Kerberos To connect using Kerberos authentication. Prompt To prompt the user for credentials. ServiceAccount To connect as the account used to run the application pool in the IIS. --> <setting name="WebAuthenticationMode" serializeAs="Xml"> <value> <adapters> <adapter name="Spotfire.SqlServerAdapter" mode="Prompt" /> <adapter name="Spotfire.TeradataAdapter" mode="Prompt" /> <adapter name="Spotfire.OracleAdapter" mode="Prompt" /> <adapter name="Spotfire.SsasAdapter" mode="ServiceAccount" /> <adapter name="Spotfire.SapBwAdapter" mode="Prompt" /> <adapter name="Spotfire.EssbaseAdapter" mode="Prompt" /> <adapter name="Spotfire.CompositeAdapter" mode="Prompt" /> <adapter name="Spotfire.MySqlAdapter" mode="Prompt" /> <adapter name="Spotfire.NetezzaAdapter" mode="Prompt" /> <adapter name="Spotfire.PostgreSqlAdapter" mode="Prompt" /> </adapters> </value> </setting> ...
<adapter name="Spotfire.MyAdapter" mode="Prompt"/>
For example, if you are adding an OData adapter, you will need to add the following within the <adapters> node:
<adapter name="Spotfire.ODataAdapter" mode="Prompt"/>And the resulting web.config will resemble the following.
... <Spotfire.Dxp.Data.Access.Adapters.Settings> <!-- Different authentication modes can be set up for the various data sources. Valid modes are: WebConfig To connect with credentials stored in Spotfire.Dxp.Web.Properties.Settings/DataAdapterCredentials below. Kerberos To connect using Kerberos authentication. Prompt To prompt the user for credentials. ServiceAccount To connect as the account used to run the application pool in the IIS. --> <setting name="WebAuthenticationMode" serializeAs="Xml"> <value> <adapters> <adapter name="Spotfire.SqlServerAdapter" mode="Prompt" /> <adapter name="Spotfire.TeradataAdapter" mode="Prompt" /> <adapter name="Spotfire.OracleAdapter" mode="Prompt" /> <adapter name="Spotfire.SsasAdapter" mode="ServiceAccount" /> <adapter name="Spotfire.SapBwAdapter" mode="Prompt" /> <adapter name="Spotfire.EssbaseAdapter" mode="Prompt" /> <adapter name="Spotfire.CompositeAdapter" mode="Prompt" /> <adapter name="Spotfire.MySqlAdapter" mode="Prompt" /> <adapter name="Spotfire.NetezzaAdapter" mode="Prompt" /> <adapter name="Spotfire.PostgreSqlAdapter" mode="Prompt" /> <adapter name="Spotfire.ODataAdapter" mode="Prompt"/> </adapters> </value> </setting> ...
Steps:
1). Edit the web.config in a plain text editor (like Notepad).
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.
Note: In Spotfire versions 7.5 and higher, all data connectors are present by default in the configuration file.
Installation and Configuration Manual.