Bij het opvragen van de tabelkolommen in Query Tool krijg ik ook de volgende foutmelding:
itgenfpr024: The database directory '\\ACME-DC\ACCOUNTVIEW\FRE16\' must exist.
Message ID: 02ce1631-b444-44d5-b173-2d40ed9311db
Occurred (UTC): 31-3-2025 10:29:43
select * from AccountView..TRANSACT limit 50
ValidationException
at Invantive.Basics.ValidationException..ctor(GlobalState owner, ExecutionOptions executionOptions, String messageCode, String errorMessage, String kindRequest, String localStackTrace, String nk, Exception innerException, Boolean inheritMessageCodeWhenPresent, Nullable`1 uid, Nullable`1 isRecoverable, String poolIdentityId, String url, Nullable`1 partyUid, String partitionCode, String tableName, String parameter1, String parameter2, String parameter3, String parameter4, String parameter5, String clientId)
at Invantive.Data.Providers.Foxpro.FoxproProvider.set_DatabaseDirectoryList(String[] )
at Invantive.Data.ProviderAttribute`1.SetValue(GlobalState owner, ExecutionOptions executionOptions, SqlExecutionStep sqlExecutionStep, Object value)
at Invantive.Data.ProviderAttribute`1.SetValue(GlobalState owner, ExecutionOptions executionOptions, SqlExecutionStep sqlExecutionStep, IProviderManager manager, Object attributeValue, ProviderAttributeNewValueOrigin origin)
at Invantive.Data.ProviderAttributes.SetOneSetting(GlobalState owner, ExecutionOptions executionOptions, SqlExecutionStep sqlExecutionStep, IBasicProviderManager manager, String attributeCode, Object attributeValue, ProviderAttributeNewValueOrigin origin, Boolean failOnNotFound)
at Invantive.Data.ProviderAttributes.MergeSettings(GlobalState owner, ExecutionOptions executionOptions, SqlExecutionStep sqlExecutionStep, IBasicProviderManager manager, ConnectionStringAttributes attributeValues, ProviderAttributeNewValueOrigin origin, Boolean failOnNotFound)
at Invantive.Data.GenericProvider.OnBeforeInitialize(GlobalState owner, ExecutionOptions executionOptions, SqlExecutionStep sqlExecutionStep, ConnectionStringAttributes attributeValues)
at Invantive.Data.GenericProvider.Initialize(GlobalState owner, ExecutionOptions executionOptions, SqlExecutionStep sqlExecutionStep, IProviderManager manager, ConnectionStringAttributes attributeValues)
at Invantive.Data.Providers.AccountView.AccountViewProvider.a(GlobalState , ExecutionOptions executionOptions, String , SqlExecutionStep sqlExecutionStep)
at Invantive.Data.Providers.AccountView.AccountViewProvider.c.A(String )
at System.Collections.Concurrent.ConcurrentDictionary`2.GetOrAdd(TKey key, Func`2 valueFactory)
at Invantive.Data.Providers.AccountView.AccountViewProvider.A(GlobalState , ExecutionOptions executionOptions, String , SqlExecutionStep sqlExecutionStep)
at Invantive.Data.Providers.AccountView.AccountViewProvider.b.A(String )
at System.Linq.Enumerable.WhereSelectArrayIterator`2.MoveNext()
at System.Linq.Buffer`1..ctor(IEnumerable`1 source)
at System.Linq.Enumerable.ToArray[TSource](IEnumerable`1 source)
at Invantive.Data.Providers.AccountView.AccountViewProvider.FetchYieldUnfilteredInternal(GlobalState owner, ExecutionOptions executionOptions, SqlExecutionStep sqlExecutionStep, EntityFieldCollection entityFields, QueryObject queryObject, ParameterList parameters, Boolean fetchSingle, Boolean fetchCountFirst, Int32 pagingSteps, Boolean fetchCount)
at Invantive.Data.GenericProvider.FetchYieldUnfiltered(GlobalState owner, ExecutionOptions executionOptions, SqlExecutionStep sqlExecutionStep, EntityFieldCollection entityFields, QueryObject queryObject, ParameterList parameters, Boolean fetchSingle, Boolean fetchCountFirst, Int32 pagingSteps, Boolean fetchCount)
at Invantive.Sql.V1.DataSourceOrFunctionWithRotatorTree.<GetDataEnumerator>d__51.MoveNext()
at Invantive.Data.CompressedEnumerable`1.<GetEnumerator>d__10.MoveNext()
at Invantive.Sql.V1.FirehoseResultSet.c.MoveNext()
at Invantive.Sql.V1.FirehoseResultSet.C.MoveNext()
at Invantive.Data.CompressedEnumerable`1.<GetEnumerator>d__10.MoveNext()
at Invantive.Sql.V1.FirehoseResultSet.c.MoveNext()
at Invantive.Sql.V1.FirehoseResultSet.C.MoveNext()
at Invantive.Sql.V1.ChainedFirehose.A.MoveNext()
at Invantive.Sql.V1.FirehoseResultSet.C.MoveNext()
at Invantive.Sql.V1.SelectListIterator.C.MoveNext()
at Invantive.Sql.V1.FirehoseResultSet.C.MoveNext()
at Invantive.Data.CompressedEnumerable`1.<GetEnumerator>d__10.MoveNext()
at Invantive.Sql.V1.FirehoseResultSet.c.MoveNext()
at Invantive.Data.ExtensionMethods.R`1.MoveNext()
at Invantive.Sql.V1.TopIterator.A.MoveNext()
at Invantive.Sql.V1.FirehoseResultSet.C.MoveNext()
at Invantive.Data.CompressedEnumerable`1.<GetEnumerator>d__10.MoveNext()
at Invantive.Sql.V1.FirehoseResultSet.c.MoveNext()
at Invantive.Sql.V1.MaterializeSparseArrayIterator.<Iterator>d__1.MoveNext()
at Invantive.Sql.V1.QueryPlan.B.MoveNext()
at Invantive.Data.ExtensionMethods.IteratorWithFinally`1.IteratorWithFinallyEnumerator.MoveNext()
at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
at Invantive.Data.ConnectionManager.ExecuteAndCombineQueryPlansV1(GlobalState owner, ExecutionOptions executionOptions, SqlExecutionStep sqlExecutionStep, QueryPlan[] queryPlans, String sqlStatement, ParameterList parameters)
at Invantive.Data.ConnectionManager.ExecuteProviderPassthroughSqlActionTable(GlobalState owner, ExecutionOptions executionOptions, String actionSql, ParameterList parameters, SqlExecutionStep sqlExecutionStep, String callSafeNameOverrule)
at Invantive.Data.ConnectionManager.c(GlobalState owner, ExecutionOptions , SqlExecutionStep , String actionSql, ParameterList , String )
at Invantive.Producer.Windows.Forms.DescribeTabData.FetchData(GlobalState owner, ExecutionOptions executionOptions)
at System.Threading.Tasks.Task.Execute()
at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot)
at System.Threading.Tasks.Task.ExecuteEntry(Boolean bPreventDoubleExecution)
at System.Threading.ThreadPoolWorkQueue.Dispatch()
at Invantive.Data.Providers.Foxpro.FoxproProvider.set_DatabaseDirectoryList(String[] )
at Invantive.Data.ProviderAttribute`1.SetValue(GlobalState owner, ExecutionOptions executionOptions, SqlExecutionStep sqlExecutionStep, Object value)
at Invantive.Data.ProviderAttribute`1.SetValue(GlobalState owner, ExecutionOptions executionOptions, SqlExecutionStep sqlExecutionStep, IProviderManager manager, Object attributeValue, ProviderAttributeNewValueOrigin origin)
at Invantive.Data.ProviderAttributes.SetOneSetting(GlobalState owner, ExecutionOptions executionOptions, SqlExecutionStep sqlExecutionStep, IBasicProviderManager manager, String attributeCode, Object attributeValue, ProviderAttributeNewValueOrigin origin, Boolean failOnNotFound)
at Invantive.Data.ProviderAttributes.MergeSettings(GlobalState owner, ExecutionOptions executionOptions, SqlExecutionStep sqlExecutionStep, IBasicProviderManager manager, ConnectionStringAttributes attributeValues, ProviderAttributeNewValueOrigin origin, Boolean failOnNotFound)
at Invantive.Data.GenericProvider.OnBeforeInitialize(GlobalState owner, ExecutionOptions executionOptions, SqlExecutionStep sqlExecutionStep, ConnectionStringAttributes attributeValues)
at Invantive.Data.GenericProvider.Initialize(GlobalState owner, ExecutionOptions executionOptions, SqlExecutionStep sqlExecutionStep, IProviderManager manager, ConnectionStringAttributes attributeValues)
at Invantive.Data.Providers.AccountView.AccountViewProvider.a(GlobalState , ExecutionOptions executionOptions, String , SqlExecutionStep sqlExecutionStep)
at Invantive.Data.Providers.AccountView.AccountViewProvider.c.A(String )
at System.Collections.Concurrent.ConcurrentDictionary`2.GetOrAdd(TKey key, Func`2 valueFactory)
at Invantive.Data.Providers.AccountView.AccountViewProvider.A(GlobalState , ExecutionOptions executionOptions, String , SqlExecutionStep sqlExecutionStep)
at Invantive.Data.Providers.AccountView.AccountViewProvider.b.A(String )
at System.Linq.Enumerable.WhereSelectArrayIterator`2.MoveNext()
at System.Linq.Buffer`1..ctor(IEnumerable`1 source)
at System.Linq.Enumerable.ToArray[TSource](IEnumerable`1 source)
at Invantive.Data.Providers.AccountView.AccountViewProvider.FetchYieldUnfilteredInternal(GlobalState owner, ExecutionOptions executionOptions, SqlExecutionStep sqlExecutionStep, EntityFieldCollection entityFields, QueryObject queryObject, ParameterList parameters, Boolean fetchSingle, Boolean fetchCountFirst, Int32 pagingSteps, Boolean fetchCount)
at Invantive.Data.GenericProvider.FetchYieldUnfiltered(GlobalState owner, ExecutionOptions executionOptions, SqlExecutionStep sqlExecutionStep, EntityFieldCollection entityFields, QueryObject queryObject, ParameterList parameters, Boolean fetchSingle, Boolean fetchCountFirst, Int32 pagingSteps, Boolean fetchCount)
at Invantive.Sql.V1.DataSourceOrFunctionWithRotatorTree.<GetDataEnumerator>d__51.MoveNext()
at Invantive.Data.CompressedEnumerable`1.<GetEnumerator>d__10.MoveNext()
at Invantive.Sql.V1.FirehoseResultSet.c.MoveNext()
at Invantive.Sql.V1.FirehoseResultSet.C.MoveNext()
at Invantive.Data.CompressedEnumerable`1.<GetEnumerator>d__10.MoveNext()
at Invantive.Sql.V1.FirehoseResultSet.c.MoveNext()
at Invantive.Sql.V1.FirehoseResultSet.C.MoveNext()
at Invantive.Sql.V1.ChainedFirehose.A.MoveNext()
at Invantive.Sql.V1.FirehoseResultSet.C.MoveNext()
at Invantive.Sql.V1.SelectListIterator.C.MoveNext()
at Invantive.Sql.V1.FirehoseResultSet.C.MoveNext()
at Invantive.Data.CompressedEnumerable`1.<GetEnumerator>d__10.MoveNext()
at Invantive.Sql.V1.FirehoseResultSet.c.MoveNext()
at Invantive.Data.ExtensionMethods.R`1.MoveNext()
at Invantive.Sql.V1.TopIterator.A.MoveNext()
at Invantive.Sql.V1.FirehoseResultSet.C.MoveNext()
at Invantive.Data.CompressedEnumerable`1.<GetEnumerator>d__10.MoveNext()
at Invantive.Sql.V1.FirehoseResultSet.c.MoveNext()
at Invantive.Sql.V1.MaterializeSparseArrayIterator.<Iterator>d__1.MoveNext()
at Invantive.Sql.V1.QueryPlan.B.MoveNext()
at Invantive.Data.ExtensionMethods.IteratorWithFinally`1.IteratorWithFinallyEnumerator.MoveNext()
at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
at Invantive.Data.ConnectionManager.ExecuteAndCombineQueryPlansV1(GlobalState owner, ExecutionOptions executionOptions, SqlExecutionStep sqlExecutionStep, QueryPlan[] queryPlans, String sqlStatement, ParameterList parameters)
at Invantive.Data.ConnectionManager.ExecuteProviderPassthroughSqlActionTable(GlobalState owner, ExecutionOptions executionOptions, String actionSql, ParameterList parameters, SqlExecutionStep sqlExecutionStep, String callSafeNameOverrule)
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at Invantive.Data.ConnectionManager.ExecuteProviderPassthroughSqlActionTable(GlobalState owner, ExecutionOptions executionOptions, String actionSql, ParameterList parameters, SqlExecutionStep sqlExecutionStep, String callSafeNameOverrule)
at Invantive.Data.ConnectionManager.c(GlobalState owner, ExecutionOptions , SqlExecutionStep , String actionSql, ParameterList , String )
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at Invantive.Data.ConnectionManager.c(GlobalState owner, ExecutionOptions , SqlExecutionStep , String actionSql, ParameterList , String )
at Invantive.Producer.Windows.Forms.DescribeTabData.FetchData(GlobalState owner, ExecutionOptions executionOptions)