Probleem is helaas nog niet opgelost, na het installeren van de 20.1.271 krijg ik nog steeds deze foutmelding in Query Tool. Je zou ergens moeten kunnen instellen waar je dit limiet kan verhogen, ik weet alleen niet waar. SQL, XML en batch geprobeerd in verschillende vormen. Hoe/waar stel je dit in?
itgenfpr034: More memo value errors than the allowed maximum of 100. Either fix the file corruption or increase the limit using the setting 'max-table-memo-value-errors'. (ART_HDR).
Bericht ID: 51f59145-9ec7-4691-8f31-417a895b5b8b
Opgetreden (UTC): 11/9/2020 3:46:15 PM
select /*+ ods(false) */ *
from AccountView..ART_HDR
limit 10
Invantive.Basics.InvantiveSqlException
at Invantive.Basics.ValidationException..ctor(GlobalState owner, ExecutionOptions executionOptions, String messageCode, String messageText, String kindRequest, String localStackTrace, String nk, Exception innerException, Boolean inheritMessageCodeWhenPresent, Nullable`1 uid, Boolean isRecoverable)
at Invantive.Basics.InvantiveSqlException..ctor(GlobalState owner, ExecutionOptions executionOptions, String validationCode, String errorMessage, String kindRequest, String stackTrace, String nk, Exception innerException, Boolean inheritMessageCodeWhenPresent, Nullable`1 uid, Boolean isRecoverable, String poolIdentityId)
at Invantive.Data.Providers.Foxpro.FoxproProvider.FetchInternal(GlobalState owner, ExecutionOptions executionOptions, EntityFieldCollection entityFields, QueryObject queryObject, ParameterList parameters, Boolean fetchSingle, Boolean fetchCountFirst, Int32 pagingSteps, Boolean fetchCount)
at Invantive.Data.GenericProvider.Fetch(GlobalState owner, ExecutionOptions executionOptions, EntityFieldCollection entityFields, QueryObject queryObject, ParameterList parameters, Boolean fetchSingle, Boolean fetchCountFirst, Int32 pagingSteps, Boolean fetchCount)
at Invantive.Data.Windows.Providers.AccountView.AccountViewProvider.RF.MoveNext()
at Invantive.Data.SqlUtility.QPF.MoveNext()
at Invantive.Data.ParallelSelectManyEnumerator`2.Read(GlobalState owner, ExecutionOptions executionOptions, TSource source, CancellationToken cancellationToken)
at Invantive.Data.ParallelSelectManyEnumerator`2.<>c__DisplayClass31_1.<System.Collections.IEnumerator.MoveNext>b__0()
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.FetchInternal(GlobalState owner, ExecutionOptions executionOptions, EntityFieldCollection entityFields, QueryObject queryObject, ParameterList parameters, Boolean fetchSingle, Boolean fetchCountFirst, Int32 pagingSteps, Boolean fetchCount)
at Invantive.Data.GenericProvider.Fetch(GlobalState owner, ExecutionOptions executionOptions, EntityFieldCollection entityFields, QueryObject queryObject, ParameterList parameters, Boolean fetchSingle, Boolean fetchCountFirst, Int32 pagingSteps, Boolean fetchCount)
at Invantive.Data.Windows.Providers.AccountView.AccountViewProvider.RF.MoveNext()
at Invantive.Data.SqlUtility.QPF.MoveNext()
at Invantive.Data.ParallelSelectManyEnumerator`2.Read(GlobalState owner, ExecutionOptions executionOptions, TSource source, CancellationToken cancellationToken)
at Invantive.Data.ParallelSelectManyEnumerator`2.<>c__DisplayClass31_1.<System.Collections.IEnumerator.MoveNext>b__0()
at System.Threading.Tasks.Task.Execute()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at (Object )
at IBC.TEO.V(Object )
at Invantive.Basics.ErrorConstants.ThrowOneOrMoreExceptions(GlobalState owner, ExecutionOptions executionOptions, IEnumerable`1 exceptions)
at Invantive.Data.ParallelSelectManyEnumerator`2.System.Collections.IEnumerator.MoveNext()
at Invantive.Sql.V1.DataSourceOrFunctionTree.<GetData>d__54.MoveNext()
at Invantive.Data.CompressedEnumerable`1.<GetEnumerator>d__8.MoveNext()
at Invantive.Sql.V1.FirehoseResultSet.LP.MoveNext()
at Invantive.Sql.V1.FirehoseResultSet.SP.MoveNext()
at Invantive.Data.CompressedEnumerable`1.<GetEnumerator>d__8.MoveNext()
at Invantive.Sql.V1.FirehoseResultSet.LP.MoveNext()
at Invantive.Sql.V1.FirehoseResultSet.SP.MoveNext()
at Invantive.Sql.V1.ChainedFirehose.EP.MoveNext()
at Invantive.Sql.V1.FirehoseResultSet.SP.MoveNext()
at Invantive.Sql.V1.SelectListIterator.JX.MoveNext()
at Invantive.Sql.V1.FirehoseResultSet.SP.MoveNext()
at Invantive.Data.CompressedEnumerable`1.<GetEnumerator>d__8.MoveNext()
at Invantive.Sql.V1.FirehoseResultSet.LP.MoveNext()
at System.Linq.Enumerable.<TakeIterator>d__25`1.MoveNext()
at Invantive.Sql.V1.TopIterator.TX.MoveNext()
at Invantive.Sql.V1.FirehoseResultSet.SP.MoveNext()
at Invantive.Data.CompressedEnumerable`1.<GetEnumerator>d__8.MoveNext()
at Invantive.Sql.V1.FirehoseResultSet.LP.MoveNext()
at Invantive.Sql.V1.MaterializeSparseArrayIterator.<Iterator>d__1.MoveNext()
at Invantive.Sql.V1.QueryPlan.XX.MoveNext()
at Invantive.Data.ExtensionMethods.ELF`1.VGF.MoveNext()
at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
at Invantive.Data.ConnectionManager.DO.A(QueryPlan )
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.ConnectionManager.ExecuteAndCombineQueryPlansV1(GlobalState owner, ExecutionOptions executionOptions, QueryPlan[] queryPlans, String sqlStatement, ParameterList parameters)
at Invantive.Data.ConnectionManager.ExecuteProviderPassthroughSqlActionTable(GlobalState owner, ExecutionOptions executionOptions, String actionSql, ParameterList parameters, 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, String callSafeNameOverrule)
at Invantive.Data.ConnectionManager.PassthroughSqlActionTable(GlobalState owner, ExecutionOptions executionOptions, String actionSql, ParameterList parameters, String callSafeNameOverrule)
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at Invantive.Data.ConnectionManager.PassthroughSqlActionTable(GlobalState owner, ExecutionOptions executionOptions, String actionSql, ParameterList parameters, String callSafeNameOverrule)
at Invantive.Data.ActionProceduresBase.PassthroughSqlActionTable(GlobalState owner, ExecutionOptions executionOptions, String actionSql, ParameterList parameters)
at Invantive.Producer.Windows.Forms.QueryToolResults.JPF(GlobalState , ExecutionOptions , IProgressNotifier , String , ParameterList , Boolean , Boolean , Boolean , Boolean ) in C:\Users\gle3.WS212\Documents\ws-master\Invantive.Producer\src\Invantive.Producer.Windows.Forms\QueryTool\QueryToolAvailableObjectsViewModel.cs:line 55
at Invantive.Producer.Windows.Forms.QueryToolResults.TPF(GlobalState , ExecutionOptions , String , ParameterList ) in C:\Users\gle3.WS212\Documents\ws-master\Invantive.Producer\src\Invantive.Producer.Windows.Forms\QueryTool\QueryToolAvailableObjectsViewModel.cs:line 30
Ook krijg ik nu een nieuwe error, zie onderstaand:
**** Waarschuwing itgendhb173: Context: select /*+ ods(true, interval '1 second') */ count(*) from AccountView..PROF_DST
Uitroep itgendci226: Missing provider.
Deze foutmelding krijg ik nu in datahub op alle tabellen, nu funtioneert het dus helemaal niet.
Foxpro database is al gereorganiseerd.