Connectors will not work after upgrading to 7.5 or 7.6
book
Article ID: KB0081597
calendar_today
Updated On:
Products
Versions
Spotfire Analyst
7.5 and 7.6
Description
After upgrading from 6.5 or 7.0 to 7.5 or 7.6, the Spotfire connectors stop working.
The details of the error will be:
An exception was thrown by the data connection. Exception text: System.MissingMethodException: Method not found: 'Spotfire.Dxp.Data.Access.Query.SqlQuery Spotfire.Dxp.Data.Access.Query.Visitors.UnnestSqlQueryTransformation.Execute(Spotfire.Dxp.Data.Access.Query.SqlQuery)'. at Spotfire.Dxp.Data.Adapters.SqlServer.SqlServerAdapterConnection.Transform(SqlQuery query) at Spotfire.Dxp.Data.Adapters.SqlServer.SqlServerAdapterConnection.ExecuteQueryCore(SqlQuery query, AdapterDataSchema schema, QueryResultWriter resultWriter, CancellationToken cancellationToken, IDictionary`2 logContext) at Spotfire.Dxp.Data.Access.Adapters.DataAdapterConnection.ExecuteQuery(SqlQuery query, AdapterDataSchema schema, QueryResultWriter resultWriter, CancellationToken cancellationToken, IDictionary`2 logContext) at Spotfire.Dxp.Data.Access.Adapters.DataAdapter.TryExecuteQuery(IDataAdapterExecutionContext executionContext, AdapterCredentialsValue credentials, SqlQuery query, AdapterDataSchema schema, QueryResultWriter resultWriter, CancellationToken cancellationToken, IDictionary`2 logContext) at Spotfire.Dxp.Data.Access.Adapters.DataAccessDataSourceLink.<>c__DisplayClass5d.<>c__DisplayClass5f.<ExecuteQueryAndCreateTable>b__5b(CancellationToken token) at Spotfire.Dxp.Data.Access.Adapters.DataAccessDataSourceLink.ExecuteAdapterMethod
Issue/Introduction
After upgrading to 7.5 or 7.6, the Spotfire connectors stop working.
Resolution
In 7.5 and 7.6, the Spotfire Connector software is a separate download and will need to be added within the new 7.5 or 7.6 deployment area.
Starting with 7.7, the connectors are part of the client deployment kit itself ,so when the latest deployment is added to the deployment area, the connectors will automatically be included.