AnsweredAssumed Answered

The 'SQLNCLI10.1' provider is not registered on the local machine

Question asked by Rahuketu on Jul 31, 2017
Latest reply on Jul 31, 2017 by jnoss

I am having issues with running PI AF Analysis / Backfilling .

 

 

It fails to perform calculation for duration provided(only works for last 3 days out 3 years). I have SQLNCLI11.1 already installed on my windows server. Windows log show following :-

 

 

 

 

 

Function System.String FillDataSetCommon(OSIsoft.AF.Service.CallContext, System.String, System.String, System.String, Boolean, Byte[], OSIsoft.AF.Service.dcTableColumnDef[], OSIsoft.AF.Service.dcTableParameter[], System.Collections.Generic.Dictionary`2[System.String,System.String], OSIsoft.AF.Service.dcServerError ByRef) at line: 0 in file

 

 

System.InvalidOperationException:.

   at System.Data.OleDb.OleDbServicesWrapper.GetDataSource(OleDbConnectionString constr, DataSourceWrapper& datasrcWrapper)

   at System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection)

   at System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)

   at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup, DbConnectionOptions userOptions)

   at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)

   at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)

   at System.Data.ProviderBase.DbConnectionInternal.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)

   at System.Data.OleDb.OleDbConnection.Open()

   at System.Data.Common.DbDataAdapter.FillSchemaInternal(DataSet dataset, DataTable datatable, SchemaType schemaType, IDbCommand command, String srcTable, CommandBehavior behavior)

   at System.Data.Common.DbDataAdapter.FillSchema(DataSet dataSet, SchemaType schemaType, IDbCommand command, String srcTable, CommandBehavior behavior)

   at System.Data.Common.DbDataAdapter.FillSchema(DataSet dataSet, SchemaType schemaType)

   at OSIsoft.AF.Service.AFService.FillDataSetCommon(CallContext callContext, String dataAdapterType, String connection, String command, Boolean impersonateUser, Byte[] encryptedPassword, dcTableColumnDef[] tableColumnDefs, dcTableParameter[] parameters, Dictionary`2 defaultParameters, dcServerError& err)

 

 

dcServerError state:

Operation =  0

ErrorNumber =  -2

Message =  The 'SQLNCLI10.1' provider is not registered on the local machine.

Procedure =  System.Data

ObjectType =  43

ID =  a6be2b6c-387b-4525-89a5-81dfb7971da7

ObjectName =  OFM_COMPLETION_en_US_1

SubObjectType =  0

User =  Unknown

LockedByUser =     at System.Data.OleDb.OleDbServicesWrapper.GetDataSource(OleDbConnectionString constr, DataSourceWrapper& datasrcWrapper)

   at System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection)

   at System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)

   at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup, DbConnectionOptions userOptions)

   at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)

   at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)

   at System.Data.ProviderBase.DbConnectionInternal.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)

   at System.Data.OleDb.OleDbConnection.Open()

   at System.Data.Common.DbDataAdapter.FillSchemaInternal(DataSet dataset, DataTable datatable, SchemaType schemaType, IDbCommand command, String srcTable, CommandBehavior behavior)

   at System.Data.Common.DbDataAdapter.FillSchema(DataSet dataSet, SchemaType schemaType, IDbCommand command, String srcTable, CommandBehavior behavior)

   at System.Data.Common.DbDataAdapter.FillSchema(DataSet dataSet, SchemaType schemaType)

   at OSIsoft.AF.Service.AFService.FillDataSetCommon(CallContext callContext, String dataAdapterType, String connection, String command, Boolean impersonateUser, Byte[] encryptedPassword, dcTableColumnDef[] tableColumnDefs, dcTableParameter[] parameters, Dictionary`2 defaultParameters, dcServerError& err)

OtherObjectType =  0

OtherObjectName =  Unknown

OtherObjectID =  00000000-0000-0000-0000-000000000000

Outcomes