Itgentkr005 Could not retrieve the metadata for 1 tables of TweedeKamer.NL data set

Vragen
,
1

Bij het benaderen van de Tweede Kamer-tabellen via Query Tool treedt bij elk gebruik, inclusief aanmelden, de volgende foutmelding op sinds release 25.0.5 (treedt niet op bij 24.0):

itgentkr005
Could not retrieve the metadata for 1 tables of TweedeKamer.NL data set.

Callstack:

InvantiveSystemException
   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.Basics.InvantiveSystemException..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, String partitionCode, String tableName, String parameter1, String parameter2, String parameter3, String parameter4, String parameter5, String clientId)
   at Invantive.Data.Providers.TweedeKamerNl.TweedeKamerNlProvider.GetMetadataForDataSet(GlobalState owner, ExecutionOptions executionOptions, SqlExecutionStep sqlExecutionStep, String defaultCatalog, String dataSetUrl, DataContainerMetadata dataContainerMetadata)
   at Invantive.Data.Providers.TweedeKamerNl.TweedeKamerNlProvider.RegisterDataContainerMetadata(GlobalState owner, ExecutionOptions executionOptions, SqlExecutionStep sqlExecutionStep, IConnection connection, DataContainerMetadata dataContainerMetadata)
   at Invantive.Data.GenericProvider.GetDataContainerMetadata(GlobalState owner, ExecutionOptions executionOptions, SqlExecutionStep sqlExecutionStep)
   at Invantive.Data.GenericProvider.GetDatabaseMetadata(GlobalState owner, ExecutionOptions executionOptions, SqlExecutionStep sqlExecutionStep)
   at Invantive.Data.ConnectionManager.i(GlobalState owner, ExecutionOptions , SqlExecutionStep )
   at Invantive.Data.ConnectionManager.g(GlobalState owner, ExecutionOptions , SqlExecutionStep )
   at Invantive.Producer.Windows.Forms.AvailableObjectsList.a(GlobalState , ExecutionOptions executionOptions)
   at Invantive.Producer.Windows.Forms.AvailableObjectsList.<GetAvailableObjectsAsync>d__45.MoveNext()
   at System.Runtime.CompilerServices.AsyncTaskMethodBuilder.Start[TStateMachine](TStateMachine& stateMachine)
   at Invantive.Producer.Windows.Forms.AvailableObjectsList.GetAvailableObjectsAsync()
   at Invantive.Producer.Windows.Forms.AvailableObjectsList.c()
   at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
   at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
   at System.Delegate.DynamicInvokeImpl(Object[] args)
   at System.Windows.Forms.Control.InvokeMarshaledCallbackDo(ThreadMethodEntry tme)
   at System.Windows.Forms.Control.InvokeMarshaledCallbackHelper(Object obj)
   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.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Windows.Forms.Control.InvokeMarshaledCallback(ThreadMethodEntry tme)
   at System.Windows.Forms.Control.InvokeMarshaledCallbacks()
   at System.Windows.Forms.Control.WndProc(Message& m)
   at System.Windows.Forms.UserControl.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
   at MS.Win32.UnsafeNativeMethods.DispatchMessage(MSG& msg)
   at MS.Win32.UnsafeNativeMethods.DispatchMessage(MSG& msg)
   at System.Windows.Threading.Dispatcher.PushFrameImpl(DispatcherFrame frame)
   at System.Windows.Window.ShowHelper(Object booleanBox)
   at System.Windows.Window.ShowDialog()
   at Invantive.Producer.Windows.Forms.RibbonWindowBase`1.ShowDialog()
   at Invantive.Producer.QueryTool.App.OnStartup(StartupEventArgs e)
   at System.Windows.Application.<.ctor>b__1_0(Object unused)
   at System.Windows.Threading.ExceptionWrapper.InternalRealCall(Delegate callback, Object args, Int32 numArgs)
   at System.Windows.Threading.ExceptionWrapper.TryCatchWhen(Object source, Delegate callback, Object args, Int32 numArgs, Delegate catchHandler)
   at System.Windows.Threading.DispatcherOperation.InvokeImpl()
   at MS.Internal.CulturePreservingExecutionContext.CallbackWrapper(Object obj)
   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.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at MS.Internal.CulturePreservingExecutionContext.Run(CulturePreservingExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Windows.Threading.DispatcherOperation.Invoke()
   at System.Windows.Threading.Dispatcher.ProcessQueue()
   at System.Windows.Threading.Dispatcher.WndProcHook(IntPtr hwnd, Int32 msg, IntPtr wParam, IntPtr lParam, Boolean& handled)
   at MS.Win32.HwndWrapper.WndProc(IntPtr hwnd, Int32 msg, IntPtr wParam, IntPtr lParam, Boolean& handled)
   at MS.Win32.HwndSubclass.DispatcherCallbackOperation(Object o)
   at System.Windows.Threading.ExceptionWrapper.InternalRealCall(Delegate callback, Object args, Int32 numArgs)
   at System.Windows.Threading.ExceptionWrapper.TryCatchWhen(Object source, Delegate callback, Object args, Int32 numArgs, Delegate catchHandler)
   at System.Windows.Threading.Dispatcher.LegacyInvokeImpl(DispatcherPriority priority, TimeSpan timeout, Delegate method, Object args, Int32 numArgs)
   at MS.Win32.HwndSubclass.SubclassWndProc(IntPtr hwnd, Int32 msg, IntPtr wParam, IntPtr lParam)
   at MS.Win32.UnsafeNativeMethods.DispatchMessage(MSG& msg)
   at MS.Win32.UnsafeNativeMethods.DispatchMessage(MSG& msg)
   at System.Windows.Threading.Dispatcher.PushFrameImpl(DispatcherFrame frame)
   at System.Windows.Application.RunDispatcher(Object ignore)
   at System.Windows.Application.RunInternal(Window window)
   at Invantive.Producer.QueryTool.App.Main()
   at Invantive.Data.Providers.TweedeKamerNl.TweedeKamerNlProvider.GetMetadataForDataSet(GlobalState owner, ExecutionOptions executionOptions, SqlExecutionStep sqlExecutionStep, String defaultCatalog, String dataSetUrl, DataContainerMetadata dataContainerMetadata)
   at Invantive.Data.Providers.TweedeKamerNl.TweedeKamerNlProvider.RegisterDataContainerMetadata(GlobalState owner, ExecutionOptions executionOptions, SqlExecutionStep sqlExecutionStep, IConnection connection, DataContainerMetadata dataContainerMetadata)
   at Invantive.Data.GenericProvider.GetDataContainerMetadata(GlobalState owner, ExecutionOptions executionOptions, SqlExecutionStep sqlExecutionStep)
   at Invantive.Data.GenericProvider.GetDatabaseMetadata(GlobalState owner, ExecutionOptions executionOptions, SqlExecutionStep sqlExecutionStep)
   at Invantive.Data.ConnectionManager.i(GlobalState owner, ExecutionOptions , SqlExecutionStep )
   at Invantive.Data.ConnectionManager.g(GlobalState owner, ExecutionOptions , SqlExecutionStep )
   at Invantive.Producer.Windows.Forms.AvailableObjectsList.a(GlobalState , ExecutionOptions executionOptions)
   at Invantive.Producer.Windows.Forms.AvailableObjectsList.<GetAvailableObjectsAsync>d__45.MoveNext()
Release 25.0 rolling out on all products
6

Deze foutmelding wordt veroorzaakt doordat de HTTP-diskcache ongeldige JSON bevatte. Ook na 7 dagen werd de oude metadata nog gebruikt, terwijl de standaardinstelling 10 uur is.

Verbeteringen zijn doorgevoerd in release 25.0 voor de caching van metadata zodat de gewenste levensduur gevolgd wordt.

De ongeldige JSON is ontstaan doordat release 25.0 publieke data zoals ECB niet meer versleutelt. Indien een versleutelde cache entry gebruikt wordt, dan treedt onder 25.0.14 de volgende foutmelding op:

itgenclr078
Error parsing Infinity value. Path ‘’, line 1, position 1.

met callstack:

Newtonsoft.Json.JsonReaderException
   at Newtonsoft.Json.JsonTextReader.ParseNumberPositiveInfinity(ReadType readType, Boolean matched)
   at Newtonsoft.Json.JsonTextReader.ParseValue()
   at Newtonsoft.Json.JsonReader.ReadForType(JsonContract contract, Boolean hasConverter)
   at Newtonsoft.Json.Serialization.JsonSerializerInternalReader.Deserialize(JsonReader reader, Type objectType, Boolean checkAdditionalContent)
   at Newtonsoft.Json.JsonSerializer.DeserializeInternal(JsonReader reader, Type objectType)
   at Newtonsoft.Json.JsonSerializer.Deserialize[T](JsonReader reader)
   at Invantive.Basics.HttpResponseCacheObject.FromJson(GlobalState owner, ExecutionOptions executionOptions, Byte[] jsonBytes, Boolean includePayload, String& reasonNull) in ...\Invantive.Basics\Statistics\HttpResponseCacheObject.cs:line 838
7

Dit topic is 3 dagen na het laatste antwoord automatisch gesloten. Nieuwe antwoorden zijn niet meer toegestaan.