AccountView tables not fully loaded with Invantive Query Tool

Last week, a connection was set up for us during a call so that AccountView can be accessed via the Invantive Query Tool, and therefore also loaded into Power BI.

However, it appears that certain important tables, such as TRANSACT, are not retrieving all columns:

I do see a large number of rows, but not the corresponding columns.
This, incidentally, is the case for every Partition Code, not just EQUIP.

We are unable to reproduce this issue under Query Tool 24.0.638 by first logging in to AccountView:

And then running the query shown on the Your Garden demo database of AccountView:

What does stand out is that practically all columns appear to be missing. Only the two columns that are automatically added for the partition are present.

Our advice is to carefully check that the following folders exist under the specified System Tables Directory, or that AccountView itself is able to open the folder structure:

  • Datadict
  • Sys_vfp
  • System
  • the folders containing the administrations

You may also want to involve an AccountView application administrator to verify that everything is working correctly.

When retrieving the table columns in Query Tool, I also get the following error message:

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)

The advice is to avoid the itgenfpr024 error message by unchecking “Include Inaccessible Databases” when logging in (driver attribute include-inaccessible-databases=false in the connection string).

Possibly related: the following query gives an error message:

select * 
from   dct_fld

namely:

itgenrst009:
The column ‘FLD_EXPN’ in ‘’ can contain a text of at most 4 characters. The value ’

But the following does work, by excluding the fields that give an error message:

select * except FLD_EXPN, fld_extra, when_expn, grde_class, grde_clib, grdl_clib, grdl_class
from   dct_fld
where dbf_name='TRANSACT'

Analysis

An analysis of the metadata of this AccountView environment produces strange results with the following query:

select jaar
,      fld_Active
,      count(*)
from   ( select fld_active
         ,      to_char(INP_DATE, 'YYYY') jaar
         from   dct_fld
       )
group 
by     jaar
,      fld_active
order
by     jaar
,      fld_active

The output on a demo installation of Your Garden shows that the value of FLD_ACTIVE is mostly true:

However, on the environment under investigation, the balance is different. According to the metadata, most fields are inactive:

This isn’t exactly the reverse. A detailed analysis shows that all combinations of incorrect settings seem to be able to occur.

It appears that the environment’s metadata is somewhat corrupted. This apparently has no effect on the functioning of AccountView itself. The AccountView application administrator may be able to provide some information about any metadata corruption or historical issues.

Solution

This form of metadata corruption, where the inactive flag is often set incorrectly, will from now on be flagged via the following error message:

itgenacw063
The table ‘…’ has no fields selected from … available fields.
Please consider configuring include-inactive-fields to true after consulting the AccountView application administrator to compensate for data errors.

To better support working with this metadata corruption, the AccountView driver has been extended with the configuration option include-inactive-fields. This option is set to false by default in order to preserve the historical and intended behaviour. However, if the following error message occurs, this option can optionally be ticked on the login screen:

The result of this, using the first query, is:

The only risk identified so far in displaying all inactive fields is that users may get the impression that fields are incorrectly empty.

Availability

This change is available from release 24.0.647 and 24.1.88-BETA onwards.

This question was automatically closed after 1 week of inactivity. The last answer given has been marked as the solution.

Please ask a new question via a separate topic if the problem occurs again. Please include a link to this topic in the new question by pasting its URL into the text.