OSIsoft - Unable to connect to PI Server

[Shreyam Dasgupta]

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)