Manoj Chaurasia Posted December 25, 2013 Share Posted December 25, 2013 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 Link to comment Share on other sites More sharing options...
Aditya Singh 3 Posted October 23, 2015 Share Posted October 23, 2015 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. Link to comment Share on other sites More sharing options...
Manoj Chaurasia Posted October 23, 2015 Author Share Posted October 23, 2015 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 Link to comment Share on other sites More sharing options...
Manoj Chaurasia Posted October 23, 2015 Author Share Posted October 23, 2015 Thank you very much both of you. The problem is solved after I reset the SQL in Information model Link to comment Share on other sites More sharing options...
gurusai sankar Posted June 27, 2019 Share Posted June 27, 2019 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 Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now