Jump to content

Error while opening data from Information Link


Mounika Kankipati

Recommended Posts

Hi,

Iam getting the following error while opening data frominformation link .

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.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.d__2.MoveNext()

at Spotfire.Dxp.Data.Producers.SourceColumnProducer.ConfigureAndLoadData()

at Spotfire.Dxp.Framework.DocumentModel.Node.ConfigureSubTree()

at Spotfire.Dxp.Framework.DocumentModel.Node.b__13(Node node)

at Spotfire.Dxp.Framework.DocumentModel.UndoableListAvlLeaf`1.ForEachChild(Action`1 action, Boolean includeFrozen)

at Spotfire.Dxp.Framework.DocumentModel.Node.ConfigureSubTree()

at Spotfire.Dxp.Framework.DocumentModel.Node.b__13(Node node)

at Spotfire.Dxp.Framework.DocumentModel.UndoableList`1.ForEachChild(Action`1 action, Boolean includeFrozen)

at Spotfire.Dxp.Framework.DocumentModel.Node.ConfigureSubTree()

at Spotfire.Dxp.Framework.DocumentModel.Node.b__13(Node node)

at Spotfire.Dxp.Framework.DocumentModel.State.NodeState.c__DisplayClass9.b__8(IDocumentNodeChild documentNodeChild)

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, ProgressOperation operation)

at Spotfire.Dxp.Framework.DocumentModel.DocumentNode.ConfigureAndAttachFromNew()

at Spotfire.Dxp.Framework.DocumentModel.DocumentNode.AttachSubTreeWhileExecuting(UndoableNode newOwner)

at Spotfire.Dxp.Framework.DocumentModel.UndoableNode.Spotfire.Dxp.Framework.DocumentModel.IUndoableNode.AttachItemToUndoableNode(Object item)

at Spotfire.Dxp.Framework.DocumentModel.UndoableKeyedCollection`2.c__DisplayClass6.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__DisplayClass24.b__23()

at Spotfire.Dxp.Framework.DocumentModel.Node.Spotfire.Dxp.Framework.DocumentModel.INode.InternalTransaction(Executor executor)

at Spotfire.Dxp.Data.DataTableCollection.Add(DataTable dataTable)

at Spotfire.Dxp.Data.DataTableCollection.Add(String dataTableName, DataSource dataSource, Boolean autoCreateFilters, Boolean includeInAxisControls)

at Spotfire.Dxp.Application.PartiallyOpenedDataSource.d__0.MoveNext()

at Spotfire.Dxp.Application.AnalysisApplication.d__34.MoveNext()

at Spotfire.Dxp.Application.AnalysisApplication.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.Application.FormsProgressService.ProgressThread.DoOperationLoop()

 

InformationModelException at Spotfire.Dxp.Data:

An Internal Error has occurred. com.spotfire.ws.dat.OperatorException: unexpected exception (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.ReadMagicNumber(BinaryReader reader)

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: unexpected exception (HRESULT: 80131509)

Stack Trace:

at Spotfire.Dxp.Services.WebServiceBase`1.InvokeService[T](ServiceMethod`1 serviceMethod, ExceptionFactoryMethod exceptionFactoryMethod)

at Spotfire.Dxp.Services.Data.InformationModel.QueryManagerService.GetDataBlock(String jobId, Int32 timeout)

at Spotfire.Dxp.Data.InformationModel.InternalInformationModelManager.DataStream.GetNextBlock()

 

Can anyone please guide me how to reslove this issue

Thanks,

Mounika.

Link to comment
Share on other sites

from the first line - my guess is that the Information LinksData Source might have changed

Test it by:

1) Open Info Designer in spotfire

2) right click info link and do a validate - see if it throws an error.

3) if your info link is ok... then your analysis may be corrupt which would suck!

Sorry - not alot of help... can help troubleshoot info link tho if it turns out yoru validation throws something back.

 

Cheers,

 

Dave

Link to comment
Share on other sites

  • 2 years later...

Hi,

 

Did you manage to find the issue

I have a similar problem. When i validate the link i do not get any warnings or errors. when I run the sql generated directly to the database, i get the result.I am also able to validate the datasource with no errors

I assume the probelm is with the data source but I am not sure how to identify the problem.

 

Thanks,

Priya

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...