Shreyam Dasgupta Posted November 22, 2021 Posted November 22, 2021 Hello Team, We are trying to connect with the OSIsoft PI Asset Framework Event Frames . We are able to establish the connection with the server using Windows Authentication method. We havetried connection with Spotfire Version 10.3 & 11.4. But when we are trying to pull attribute data into the Spotfire, it is giving the below error : Error message: Failed to create DataTable ImportException at Spotfire.Dxp.Data: Failed to create DataTable (HRESULT: 80131500) Stack Trace: at Spotfire.Dxp.Data.ColumnFactory.CreateColumns(DataRowReader reader, String documentTitle, IDataPropertyContainer properties, GlobalMethodRegistry globalMethodRegistry, CxxSession session, Boolean addNewProperties, PartialDataLoadReport report, Func`2 resultPropertiesCreator, UInt64 maxRowsToConsume) at Spotfire.Dxp.Data.Producers.SourceColumnProducer.c__DisplayClass73_0.b__0() at Spotfire.Dxp.Framework.ApplicationModel.Progress.ExecuteSubtask(String title, ProgressOperation operation) at Spotfire.Dxp.Data.Producers.SourceColumnProducer.CreateView(CxxSession session, GlobalMethodRegistry globalMethodRegistry, DataSourceConnection connection, DataRowReader initialReader, IDataPropertyContainer defaultColumnProperties, UInt64 maxRowsToConsume, Boolean disableReset, 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.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.UndoableList`1.c__DisplayClass18_0.b__0() at Spotfire.Dxp.Framework.DocumentModel.Node.InternalTransaction(Executor executor, Boolean rollbackNestedInternalTransactionAtException, Boolean isStreamingProperty) at Spotfire.Dxp.Framework.ApplicationModel.PromptService.ExecuteInPromptMode(PromptMode promptMode, Executor executor) at Spotfire.Dxp.Data.DataTable.ReplaceSourceProducer(DataColumnProducer oldProducer, DataColumnProducer newProducer, IList`1 transformations, Boolean suppressDataSourcePrompting) at Spotfire.Dxp.Data.SourceView.InternalMethods.ReplaceSourceOperation(DataOperation operationToReplace, DataFlowBuilder dataFlowToReplaceWith, Boolean suppressDataSourcePrompting) at Spotfire.Dxp.Data.DataRecommendations.DataSourceInput.ReplaceDataSourceCore(DataTable target, SourceView sourceView, DataOperation operationToReplace) at Spotfire.Dxp.Data.DataTable.EnsureNoForcedPrompting(Executor executor) at Spotfire.Dxp.Data.DataRecommendations.AddDataInput.ReplaceDataSource(DataTable target, SourceView sourceView, DataOperation operationToReplace) at Spotfire.Dxp.Data.DataRecommendations.ReplaceDataSourceAction.Execute(AddDataInput input, DataColumnProducer target, ExecuteSettings settings) at Spotfire.Dxp.Data.DataRecommendations.ExistingTableOutputConfiguration.Execute(Boolean autoCreateFilters) at Spotfire.Dxp.Data.Access.AddData.AddDataSummary.c__DisplayClass25_0.b__0() NullReferenceException at SpotfirePS.Framework.OSIAFDataSource: Object reference not set to an instance of an object. (HRESULT: 80004003) Stack Trace: at SpotfirePS.Framework.OSIAFDataSource.EFDataSource.EventFrameDataRowReader.MoveNextCore() at Spotfire.Dxp.Data.Cxx.CxxDataTransfer.c__DisplayClass9_1.b__0() at Spotfire.Dxp.Framework.ApplicationModel.Progress.ExecuteSubtask(String title, IndeterminateProgressFormatter progressFormatter, ProgressOperation operation) at Spotfire.Dxp.Data.Cxx.CxxDataTransfer.CreateTable(DataRowReader dataRowReader, CxxSession session, PartialDataLoadReport report, Advancer rowAdvancer, Boolean needsReset, Int64 exclusiveStartRowIndex, UInt64 maxRowsThatWillBeRead) at Spotfire.Dxp.Data.Cxx.CxxDataTransfer.CreateTable(DataRowReader dataRowReader, CxxSession session, PartialDataLoadReport report, Boolean needsReset, UInt64 maxRowsToConsume) at Spotfire.Dxp.Data.Cxx.CxxCreateViewResult.Create(DataRowReader reader, IDataPropertyContainer defaultProperties, String documentTitle, CxxSession session, Boolean addNewProperties, PartialDataLoadReport loadReport, UInt64 maxRowsToConsume) at Spotfire.Dxp.Data.ColumnFactory.CreateColumnsPrivate(DataRowReader reader, String documentTitle, IDataPropertyContainer properties, GlobalMethodRegistry globalMethodRegistry, CxxSession session, Boolean addNewProperties, PartialDataLoadReport report, Func`2 resultPropertiesCreator, UInt64 maxRowsToConsume) at Spotfire.Dxp.Data.ColumnFactory.CreateColumns(DataRowReader reader, String documentTitle, IDataPropertyContainer properties, GlobalMethodRegistry globalMethodRegistry, CxxSession session, Boolean addNewProperties, PartialDataLoadReport report, Func`2 resultPropertiesCreator, UInt64 maxRowsToConsume)
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