Connectors will not work after upgrading to 7.5 or 7.6

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.