Could not open information link in TIBCO Spotfire. An Internal Error has occurred. "com.spotfire.ws.dat.OperatorException: Multiple values not allowed without aggregation."

Could not open information link in TIBCO Spotfire. An Internal Error has occurred. "com.spotfire.ws.dat.OperatorException: Multiple values not allowed without aggregation."

book

Article ID: KB0074798

calendar_today

Updated On:

Products Versions
Spotfire Analyst All

Description

Failure to open an information link, with "Multiple values not allowed without aggregation" stated in the details of the error message, typically indicates that the information link has a conditioning pivot whose "Other columns" field includes at least one column with an aggregation method of "None", and the pivot's "slicing" of that column results in multiple distinct values for each of its cells, so that aggregation is necessary. In some situations, the "None" aggregation method will be changed behind the scenes to an aggregation method of "First", and this will show up in the "Edit > Column Properties" dialog as an entry of "First" for that column's "Pivot.AggregationMethod" property. In other situations, the "None" aggregation is retained, and the error message and exception reported are returned.

Example error message:
----------------------------------------- 
Error message: Could not open information link.

ImportException at Spotfire.Dxp.Data:
Failed to execute data source query. (HRESULT: 80131500)


Stack Trace:
   at Spotfire.Dxp.Data.DataSourceConnection.ExecuteQuery2()
   at Spotfire.Dxp.Data.DataFlow.Execute()
   at Spotfire.Dxp.Data.DataFlow.DataFlowConnection.ExecuteQueryCore2()
   at Spotfire.Dxp.Data.DataSourceConnection.ExecuteQuery2()
   at Spotfire.Dxp.Data.Producers.SourceColumnProducer.<>c__DisplayClass15.<GetColumnsAndProperties>b__12()
   at Spotfire.Dxp.Framework.ApplicationModel.Progress.ExecuteSubtask(String title, ProgressOperation operation)
   at Spotfire.Dxp.Data.Producers.SourceColumnProducer.GetColumnsAndProperties(DataSourceConnection connection)
   at Spotfire.Dxp.Data.Persistence.DataItem.PerformUpdate(SourceColumnProducer producer, DataSourceConnection connection)
   at Spotfire.Dxp.Data.Persistence.DataItem.Update(SourceColumnProducer producer, DataSourceConnection connection)
   at Spotfire.Dxp.Data.Persistence.DataPool.<LoadData>d__2.MoveNext()
   at Spotfire.Dxp.Data.Producers.SourceColumnProducer.ConfigureAndLoadData()
   at Spotfire.Dxp.Framework.DocumentModel.Node.ConfigureSubTree()
   at Spotfire.Dxp.Framework.DocumentModel.Node.<ConfigureSubTree>b__13(Node node)
   at Spotfire.Dxp.Framework.DocumentModel.Node.ConfigureSubTree()
   at Spotfire.Dxp.Framework.DocumentModel.Node.<ConfigureSubTree>b__13(Node node)
   at Spotfire.Dxp.Framework.DocumentModel.Node.ConfigureSubTree()
   at Spotfire.Dxp.Framework.DocumentModel.Node.<ConfigureSubTree>b__13(Node node)
   at Spotfire.Dxp.Framework.DocumentModel.State.NodeState.ForEachChild(IDocumentNodeChild[] children, Action`1 action)
   at Spotfire.Dxp.Framework.DocumentModel.Node.ConfigureSubTree()
   at Spotfire.Dxp.Framework.ApplicationModel.Progress.ExecuteSubtask(String title, IndeterminateProgressFormatter progressFormatter, ProgressSpeedFormatter speedFormatter, ProgressOperation operation)
   at Spotfire.Dxp.Framework.DocumentModel.DocumentNode.ConfigureAndAttachFromNew()
   at Spotfire.Dxp.Framework.DocumentModel.DocumentNode.AttachSubTreeWhileExecuting(UndoableNode newOwner)
   at Spotfire.Dxp.Framework.DocumentModel.DocumentNode.AttachToUndoableNode(UndoableNode newOwner)
   at Spotfire.Dxp.Framework.DocumentModel.UndoableKeyedCollection`2.<>c__DisplayClass6.<Insert>b__5()
   at Spotfire.Dxp.Framework.DocumentModel.Node.Spotfire.Dxp.Framework.DocumentModel.INode.InternalTransaction(Executor executor)
   at Spotfire.Dxp.Framework.DocumentModel.UndoableKeyedCollection`2.Insert(Int32 index, TNode item)
   at Spotfire.Dxp.Data.DataTableCollection.<>c__DisplayClass20.<Add>b__1f()
   at Spotfire.Dxp.Framework.DocumentModel.Node.Spotfire.Dxp.Framework.DocumentModel.INode.InternalTransaction(Executor executor)
   at Spotfire.Dxp.Data.DataTableCollection.Add(String dataTableName, DataSource dataSource, Boolean autoCreateFilters, Boolean includeInAxisControls)
   at Spotfire.Dxp.Application.PartiallyOpenedDataSource.<LoadData>d__0.MoveNext()
   at Spotfire.Dxp.Application.AnalysisApplication.<OpenPartiallyOpenedDocument>d__34.MoveNext()
   at Spotfire.Dxp.Application.AnalysisApplication.<OpenDataSource>d__1b.MoveNext()
   at Spotfire.Dxp.Application.AnalysisApplication.ConsumeDataLoadPromptRequests(IEnumerable`1 prompts)
   at Spotfire.Dxp.Application.AnalysisApplication.Open(DataSource source, DocumentOpenSettings settings)
   at Spotfire.Dxp.Forms.Data.Import.DataSourceFactoryService.OpenDataSourceWithoutPrompting(DataSource dataSource, DocumentOpenSettings documentOpenSettings, IServiceProvider serviceProvider)
   at Spotfire.Dxp.Forms.Data.Import.DataSourceFactoryService.OpenDataSource(InformationLinkDataSource dataSource, DocumentOpenSettings documentOpenSettings, IServiceProvider serviceProvider)
   at Spotfire.Dxp.Forms.Data.Import.DataSourceFactoryService.OpenDataSource(DataSource dataSource, IServiceProvider serviceProvider)
   at Spotfire.Dxp.Forms.Application.FormsProgressService.ProgressThread.DoOperationLoop()

InformationModelException at Spotfire.Dxp.Data:

An Internal Error has occurred. com.spotfire.ws.dat.OperatorException: Multiple values not allowed without aggregation (HRESULT: 80131500)

Stack Trace:
   at Spotfire.Dxp.Data.InformationModel.InternalInformationModelManager.DataStream.GetNextBlock()
   at Spotfire.Dxp.Data.InformationModel.InternalInformationModelManager.DataStream.Read(Byte[] buffer, Int32 offset, Int32 count)
   at Spotfire.Dxp.Internal.Utilities.SeekableStream.Read(Byte[] buffer, Int32 offset, Int32 count)
   at System.IO.BinaryReader.FillBuffer(Int32 numBytes)
   at System.IO.BinaryReader.ReadUInt16()
   at Spotfire.Dxp.Data.Formats.Sbdf.SbdfSectionHeader.ReadSectionType(BinaryReader reader, SbdfSectionTypeId expectedType)
   at Spotfire.Dxp.Data.Import.SbdfDataRowReader.DelayedInit()
   at Spotfire.Dxp.Data.Import.InformationLinkDataSourceConnection.ExecuteQueryCore2()
   at Spotfire.Dxp.Data.DataSourceConnection.ExecuteQuery2()

InformationModelServiceException at Spotfire.Dxp.Services:

An Internal Error has occurred. com.spotfire.ws.dat.OperatorException: Multiple values not allowed without aggregation (HRESULT: 80131509)

Stack Trace:
   at Spotfire.Dxp.Services.WebServiceBase`1.InvokeService[T](ServiceMethod`1 serviceMethod, ExceptionFactoryMethod exceptionFactoryMethod)
   at Spotfire.Dxp.Data.InformationModel.InternalInformationModelManager.DataStream.GetNextBlock()

Resolution

The way to fix this is to select an aggregation method other than "None" for such columns, when defining the information link's conditioning pivot.
 

Issue/Introduction

When attempting to run an information link in a TIBCO Spotfire client, you get the error message "Could not open information link", with "An Internal Error has occurred. com.spotfire.ws.dat.OperatorException: Multiple values not allowed without aggregation. in the details". This could happen if the information link has a pivot for which an aggregation method is needed.

Additional Information