Commands out of sync; you can't run this command now

[Quang Tran 2]

I updated my company spotfire from version 7 to version 11 and got this error when reconnect mysql databse. It hasnever happen before when my companyuse version 7. Please help!!

Error message: An error occurred when executing a query in the external data source.

External error:

ERROR [HY000] [MySQL][ODBC 8.0(w) Driver][mysqld-5.6.40-log]Commands out of sync; you can't run this command now

ImportException at Spotfire.Dxp.Data:

An error occurred when executing a query in the external data source.

External error:

ERROR [HY000] [MySQL][ODBC 8.0(w) Driver][mysqld-5.6.40-log]Commands out of sync; you can't run this command now

Stack Trace:

at Spotfire.Dxp.Data.Producers.ConnectorImportColumnProducer.CreateView(ManagedDataConnection dataConnection, Guid virtualJoinViewId, DataTableSchema schema, Guid promptCollectionId, CxxSession session, IServiceProvider serviceProvider, GlobalMethodRegistry globalMethodRegistry, NotificationService notificationService, Int32 rowLimit, PendingViewRequestsManager pendingViewRequestsManager)

at Spotfire.Dxp.Data.Producers.ConnectorImportColumnProducer.GetColumnsAndProperties()

at Spotfire.Dxp.Data.Persistence.DataItem.PerformUpdate(DataColumnProducer producer, Boolean forceUpdate)

at Spotfire.Dxp.Data.Persistence.DataPool.GetDerivedData(DataColumnProducer producer, Boolean loadingPre50CalculatedColumnProducer, DataPoolReferenceType dataPoolReferenceType)

at Spotfire.Dxp.Data.Persistence.DataPool.GetData(DataColumnProducer producer, Boolean loadingPre50CalculatedColumnProducer, DataPoolReferenceType dataPoolReferenceType)

at Spotfire.Dxp.Data.Producers.ConnectorImportColumnProducer.PoolReferenceCompute_(DocumentNode node)

at Spotfire.Dxp.Framework.DocumentModel.RuntimeProperties.RuntimePropertyMultiplexor`1.ComputeValue(NonSharedRuntimePropertyValue`1 runtimePropertyValue, StatelessPropertyComputer`1 propertyComputer, DocumentNode ownerNode)

at Spotfire.Dxp.Framework.DocumentModel.RuntimeProperties.RuntimePropertyMultiplexor`1.c__DisplayClass33_1.b__0()

at Spotfire.Dxp.Framework.DocumentModel.ThreadTransactionInfo.EvaluateWithLimitationTarget(ILimitationTarget limitationTarget, Executor executor)

at Spotfire.Dxp.Framework.DocumentModel.RuntimeProperties.RuntimePropertyMultiplexor`1.LookupOrEvaluateValue(StatelessPropertyComputer`1 propertyComputer, DocumentNode ownerNode, StatelessDependencyDeclarer dependencyDeclarer)

at Spotfire.Dxp.Framework.DocumentModel.RuntimeProperties.RuntimePropertyMultiplexor`1.GetValue(StatelessPropertyComputer`1 propertyComputer, StatelessDependencyDeclarer dependencyDeclarer, DocumentNode ownerNode)

at Spotfire.Dxp.Framework.DocumentModel.RuntimeProperty`1.c__DisplayClass29_0.b__2()

at Spotfire.Dxp.Framework.DocumentModel.DocumentView.Use(DocumentView documentView, DocumentViewExecutionState documentViewExecutionState, Action action)

at Spotfire.Dxp.Framework.DocumentModel.RuntimeProperty`1.b__29_0()

at Spotfire.Dxp.Data.Producers.ConnectorImportColumnProducer.LoadData(Boolean willPotentiallyLoadData)

at Spotfire.Dxp.Data.Producers.ConnectorImportColumnProducer.d__120.MoveNext()

at Spotfire.Dxp.Data.Extensions.EnumeratorExtensions.MoveNext(IEnumerator`1 enumerator, Exception& exception)