Unable to Perform Operation: Commonly Used Project Suddenly Cannot Open

[Stephen Prosser]

I commonly use a large Spotfire project, almost daily. Yesterday I was hit with a long error message saying the project could not be loaded. I tried forcing propmts when loading the data, but I keep getting the same error. I have pasted a snapshot of the error message below as well as full text for the entire error message below. Any ideas on how to fix this

 

 

Error message:

 

 

 

 

InvalidOperationException at Spotfire.Dxp.Data:

Data should have been pushed. (HRESULT: 80131509)

 

Stack Trace:

at Spotfire.Dxp.Data.Producers.DataTransformationColumnProducer.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.DataTransformationColumnProducer.GetDataReference_(DocumentNode node)

at Spotfire.Dxp.Framework.DocumentModel.RuntimeProperties.RuntimePropertyMultiplexor`1.ComputeValue(RuntimePropertyValue`1 runtimePropertyValue, StatelessPropertyComputer`1 propertyComputer, StatelessDependencyDeclarer dependencyDeclarer, DocumentNode ownerNode, Int32& firstGenerationForValue, Int32& lastGenerationForValue)

at Spotfire.Dxp.Framework.DocumentModel.RuntimeProperties.RuntimePropertyMultiplexor`1.c__DisplayClass9.b__4()

at Spotfire.Dxp.Framework.DocumentModel.ThreadTransactionInfo.EvaluateWithGenerationDependant(ILimitationTarget generationDependant, Executor executor)

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

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

at Spotfire.Dxp.Framework.DocumentModel.RuntimeProperty`1.c__DisplayClass8.b__6()

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

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

at Spotfire.Dxp.Data.Producers.DataTransformationColumnProducer.ColumnsCoreCompute()

at Spotfire.Dxp.Data.Producers.FilteredColumnProducer.ColumnsCompute_(DocumentNode node)

at Spotfire.Dxp.Framework.DocumentModel.RuntimeProperties.RuntimePropertyMultiplexor`1.ComputeValue(RuntimePropertyValue`1 runtimePropertyValue, StatelessPropertyComputer`1 propertyComputer, StatelessDependencyDeclarer dependencyDeclarer, DocumentNode ownerNode, Int32& firstGenerationForValue, Int32& lastGenerationForValue)

at Spotfire.Dxp.Framework.DocumentModel.RuntimeProperties.RuntimePropertyMultiplexor`1.c__DisplayClass9.b__4()

at Spotfire.Dxp.Framework.DocumentModel.ThreadTransactionInfo.EvaluateWithGenerationDependant(ILimitationTarget generationDependant, Executor executor)

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

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

at Spotfire.Dxp.Framework.DocumentModel.RuntimeProperty`1.c__DisplayClass8.b__6()

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

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

at Spotfire.Dxp.Data.Producers.FilteredColumnProducer.NameMapCompute_(DocumentNode node)

at Spotfire.Dxp.Framework.DocumentModel.RuntimeProperties.RuntimePropertyMultiplexor`1.ComputeValue(RuntimePropertyValue`1 runtimePropertyValue, StatelessPropertyComputer`1 propertyComputer, StatelessDependencyDeclarer dependencyDeclarer, DocumentNode ownerNode, Int32& firstGenerationForValue, Int32& lastGenerationForValue)

at Spotfire.Dxp.Framework.DocumentModel.RuntimeProperties.RuntimePropertyMultiplexor`1.c__DisplayClass9.b__4()

at Spotfire.Dxp.Framework.DocumentModel.ThreadTransactionInfo.EvaluateWithGenerationDependant(ILimitationTarget generationDependant, Executor executor)

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

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

at Spotfire.Dxp.Framework.DocumentModel.RuntimeProperty`1.c__DisplayClass8.b__6()

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

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

at Spotfire.Dxp.Data.Producers.FilteredColumnProducer.TryGetColumn(String name, IDataColumn& column)

at Spotfire.Dxp.Data.SourceColumnImpl.GetBaseColumn()

at Spotfire.Dxp.Data.SourceColumnImpl.ConvertedColumnCompute_(DocumentNode node)

at Spotfire.Dxp.Framework.DocumentModel.RuntimeProperties.RuntimePropertyMultiplexor`1.ComputeValue(RuntimePropertyValue`1 runtimePropertyValue, StatelessPropertyComputer`1 propertyComputer, StatelessDependencyDeclarer dependencyDeclarer, DocumentNode ownerNode, Int32& firstGenerationForValue, Int32& lastGenerationForValue)

at Spotfire.Dxp.Framework.DocumentModel.RuntimeProperties.RuntimePropertyMultiplexor`1.c__DisplayClass9.b__4()

at Spotfire.Dxp.Framework.DocumentModel.ThreadTransactionInfo.EvaluateWithGenerationDependant(ILimitationTarget generationDependant, Executor executor)

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

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

at Spotfire.Dxp.Framework.DocumentModel.RuntimeProperty`1.c__DisplayClass8.b__6()

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

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

at Spotfire.Dxp.Data.SourceColumnImpl.GetCoreColumn()

at Spotfire.Dxp.Data.DataColumnImpl.BaseColumnCompute_(DocumentNode node)

at Spotfire.Dxp.Framework.DocumentModel.RuntimeProperties.RuntimePropertyMultiplexor`1.ComputeValue(RuntimePropertyValue`1 runtimePropertyValue, StatelessPropertyComputer`1 propertyComputer, StatelessDependencyDeclarer dependencyDeclarer, DocumentNode ownerNode, Int32& firstGenerationForValue, Int32& lastGenerationForValue)

at Spotfire.Dxp.Framework.DocumentModel.RuntimeProperties.RuntimePropertyMultiplexor`1.c__DisplayClass9.b__4()

at Spotfire.Dxp.Framework.DocumentModel.ThreadTransactionInfo.EvaluateWithGenerationDependant(ILimitationTarget generationDependant, Executor executor)

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

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

at Spotfire.Dxp.Framework.DocumentModel.RuntimeProperty`1.c__DisplayClass8.b__6()

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

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

at Spotfire.Dxp.Data.DataColumnImpl.get_ImplementationColumn()

at Spotfire.Dxp.Data.Expressions.QualifiedTypeCheckContext.TableEntry.DataTableEntry.TryGetColumnEntry(String columnName, ColumnAliasReference& entry)

at Spotfire.Dxp.Data.Expressions.QualifiedTypeCheckContext.TryCreateColumnAliasReference(QualifiedName name, ColumnAliasReference& reference)

at Spotfire.Dxp.Data.Expressions.SyntaxTree.TableScope.TryGetColumnAliasReference(QualifiedName name, ColumnAliasReference& reference)

at Spotfire.Dxp.Data.Expressions.Visitors.Parsed.TypeCheck.Visit(ParsedColumnObject columnObject)

at Spotfire.Dxp.Data.Expressions.Visitors.Parsed.TypeCheck.VisitChild[T](ParsedSqlAst child, Boolean insideMultipleTablesColumnExpression)

at Spotfire.Dxp.Data.Expressions.Visitors.Parsed.TypeCheck.TypeCheckFunctionCallAllowingMultipleTables(ParsedFunctionCall functionCall)

at Spotfire.Dxp.Data.Expressions.Visitors.Parsed.TypeCheck.Visit(ParsedFunctionCall functionCall)

at Spotfire.Dxp.Data.Expressions.Visitors.Parsed.TypeCheck.VisitChild[T](ParsedSelectItem child)

at Spotfire.Dx

[Varma Nadimpalli]

Hello Stephen,

What is the version of Spotfire where you have this issue

Are there any changes made in recent to this analysis dxp or are there any changes the way you access this report

[Stephen Prosser]

We use version 7.10.1.0.12. Nothing changed from the days when it worked to when it stopped working. I open the project the same way every day.