Anyone can help me about the error I found as trying to add new information link to analysis file.

[Manoj Chaurasia]

Hi,

Anyone can help me about the error I found as trying to add new information link to analysis file.

The information link somehow contain errors as I put a column name "PRESEND".

The error I captured from the dialog as below,

"

 

Error message: Could not open data source.

TargetInvocationException at Spotfire.Dxp.Framework:Exception has been thrown by the target of an invocation. (HRESULT: 80131604)

Stack Trace: at Spotfire.Dxp.Framework.ApplicationModel.ProgressService.ExecuteWithProgress(String title, String description, ProgressOperation operation) at Spotfire.Dxp.Forms.Application.FormsApplicationThread.ExecutePromptingOperation(String title, String description, PromptingApplicationInvocation promptingApplicationInvocation) at Spotfire.Dxp.Application.RichAnalysisApplication.Open(String filePath, DocumentOpenSettings documentOpenSettings) at Spotfire.Dxp.Main.Program.c__DisplayClassa.b__9(LoadCallbackParameters parameters) at Spotfire.Dxp.Forms.Framework.Utilities.LoadFileHelper.LoadFile(LoadCallback callback, LoadCallbackParameters parameters)

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__DisplayClass11.b__e() 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__1.MoveNext() at Spotfire.Dxp.Data.Producers.SourceColumnProducer.d__7.MoveNext() at Spotfire.Dxp.Data.DataTable.d__35.MoveNext() at Spotfire.Dxp.Data.DataManager.d__7b.MoveNext() at Spotfire.Dxp.Data.DataManager.d__40.MoveNext() at Spotfire.Dxp.Data.DataManager.d__30.MoveNext() at Spotfire.Dxp.Data.DataManager.d__18.MoveNext() at Spotfire.Dxp.Application.PartiallyOpenedDxpFile.d__0.MoveNext() at Spotfire.Dxp.Application.AnalysisApplication.d__34.MoveNext() at Spotfire.Dxp.Application.AnalysisApplication.d__f.MoveNext() at Spotfire.Dxp.Forms.Application.FormsApplicationThread.c__DisplayClass5.b__4() at Spotfire.Dxp.Forms.Application.FormsProgressService.ProgressThread.DoOperationLoop()

InformationModelException at Spotfire.Dxp.Data:Failed to execute query: Invalid column name 'PRESEND'. (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.SbdfDataRowReader..ctor(Stream stm, PartialDataLoadReport loadReport) at Spotfire.Dxp.Data.Import.InformationLinkDataSourceConnection.ExecuteQueryCore2() at Spotfire.Dxp.Data.DataSourceConnection.ExecuteQuery2()

InformationModelServiceException at Spotfire.Dxp.Services:Failed to execute query: Invalid column name 'PRESEND'. (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()"

PRESEND

[Aditya Singh 3]

Hi

As the error says "Invalid column name 'PRESEND'" it means this column is not in your table element in library. Please make sure you have this column in your table in library and after adding this column go to SQL of Information Link and click reset to original.

[Manoj Chaurasia]

Give a check whether this column is present in the desired database from where you are pulling up the data as well as the information model. Just remove the column from the information link & again add it in information link from the information model

[Manoj Chaurasia]

Thank you very much both of you. The problem is solved after I reset the SQL in Information model

[gurusai sankar]

Hi Addy, i am getting below error when i edited sql query and run. 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_id The error which iam 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.<CreateView>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.<LoadData>d__15.MoveNext()

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

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

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

   at Spotfire.Dxp.Framework.DocumentModel.State.NodeState.<>c__DisplayClass91_0.<ForEachManagedChild>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.<Insert>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.<Add>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.<LoadData>d__9.MoveNext()

   at Spotfire.Dxp.Application.AnalysisApplication.<OpenPartiallyOpenedDocument>d__110.MoveNext()

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