Can someone help on below spotfire error

[gurusai sankar]

Hi All,

I am getting below error when i am editiong sql query as per the requirement.

Below is the query which i am using:

SELECT

tab1.*,

tab2.*

FROM

(SELECT rank() over (partition BY PROPOSAL_ID order by PERIOD_ID) prop_rownum,

P1."PROPOSAL_ID" AS "PROPREQUESTID",

P1."IT_TOWER" AS "ITTOWER",

P3."PERIOD_NAME" AS "PERIODNAME",

P3."COST" AS "COST"

FROM "PPM_USR"."PPM_PROJECT_PROPOSAL_DATA_V" P1,

"PPM_USR"."PPM_PROPOSED_COST_MONTHLY_V" P3

WHERE P1."PROPOSAL_ID" = P3."PROP_REQUEST_ID"

)tab1

FULL OUTER JOIN

(SELECT rank() over (partition BY LINK_PROJ_PROP_ID order by PROJECT_NO) cost_rownum,

P2."PROJECT_TYPE" AS "PROJECTTYPE",

P2."PROJECT_NO" AS "PROJECTNO",

P2."LINK_PROJ_PROP_ID" AS Link_prop_id

FROM "PPM_USR"."PPM_PROJECT_DATA_V" P2

)tab2

ON tab1.prop_rownum=tab2.cost_rownum

where tab1.PROPREQUESTID=tab2.Link_prop_idBelow is the error which i am getting:

Error message: Could not open information link.

 

ImportException at Spotfire.Dxp.Data:

Failed to execute data source query for data source "Information link". (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__DisplayClass72_1.b__0()

at Spotfire.Dxp.Framework.ApplicationModel.Progress.ExecuteSubtask(String title, ProgressOperation operation)

at Spotfire.Dxp.Data.Producers.SourceColumnProducer.CreateView(CxxSession session, DataPropertyRegistry propertyRegistry, GlobalMethodRegistry globalMethodRegistry, DataSourceConnection connection, PartialDataLoadReport& partialLoadReport)

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

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

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

at Spotfire.Dxp.Framework.DocumentModel.Node.c.b__47_0(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.c.b__47_0(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.c.b__47_0(Node node)

at Spotfire.Dxp.Framework.DocumentModel.State.NodeState.c__DisplayClass91_0.b__0(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(UndoableNodeBase newOwner)

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

at Spotfire.Dxp.Framework.DocumentModel.UndoableKeyedCollection`2.c__DisplayClass43_0.b__0()

at Spotfire.Dxp.Framework.DocumentModel.Node.InternalTransaction(Executor executor, Boolean rollbackNestedInternalTransactionAtException)

at Spotfire.Dxp.Framework.DocumentModel.UndoableKeyedCollection`2.Insert(Int32 index, TNode item)

at Spotfire.Dxp.Data.DataTableCollection.c__DisplayClass68_0.b__0()

at Spotfire.Dxp.Framework.DocumentModel.Node.InternalTransaction(Executor executor, Boolean rollbackNestedInternalTransactionAtException)

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

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

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

at Spotfire.Dxp.Application.AnalysisApplication.d__99.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:

Failed to get data: Fail to convert to internal representation (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:

Failed to get data: Fail to convert to internal representation (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()kindly help on this.

 

Regards,

Guru

[James Watts]

Presumably it is a data conversion error; you may need to perform explicit conversions on one or more columns in your SQL to match Spotfire's data types.

[Shashank Gurnalkar]

Hello Jim,

 

We generally see this error when any changes have been made to the information link and/or in the underlying data table since the last time you had your data linked/refreshed. For example, if you change the type of a column there can be a type mismatch between what you have in the database and what is specified in the information link.

[gurusai sankar]

Thanks Jim, It worked . Thanks a lot for your continued support. kindly provide your inputs for below spotfire Query. It is some urgent requirement. 

 

https://community.spotfire.com/questions/how-display-trend-3-years-selected-year