Itgenacw063 Tabellen 'pay_link' har ingen felt valgt fra 13 tilgjengelige felt

Etter å ha installert den nyeste versjonen av Query Tool, får jeg bare en feil på available fields:

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

Denne vises fortsatt selv etter at jeg har krysset av for Inkluder inaktive felt. Men når jeg trykker på knappen «Koble til», kobler den seg faktisk til.

Men batch-filen fungerer fortsatt ikke, med samme melding:

itgenacw063: The table 'PAY_LINK' has no fields selected from 13 available fields.

Please consider configuring include-inactive-fields to true after consulting the AccountView application administrator to compensate for data errors.

Bericht ID: 7a858c8d-4e4f-499c-a126-d40e75c2c54d

Opgetreden (UTC): 14-7-2025 14:50:56

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.AccountView.AccountViewProvider.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.B.MoveNext()
   at System.Runtime.CompilerServices.AsyncTaskMethodBuilder.Start[TStateMachine](TStateMachine& stateMachine)
   at Invantive.Producer.Windows.Forms.AvailableObjectsList.GetAvailableObjectsAsync()
   at Invantive.Producer.Windows.Forms.AvailableObjectsList.Bind()
   at Invantive.Producer.Windows.Forms.AvailableObjectsList.Activate()
   at Invantive.Producer.Windows.Forms.QueryToolWindow.AvailableObjectsList_ChildChanged(Object sender, ChildChangedEventArgs e)
   at System.Windows.Forms.Integration.WindowsFormsHost.OnChildChanged(Control oldChild)
   at System.Windows.Forms.Integration.WindowsFormsHost.set_Child(Control value)
   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.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
   at System.Reflection.MethodBase.Invoke(Object obj, Object[] parameters)
   at System.Xaml.Schema.SafeReflectionInvoker.InvokeMethodCritical(MethodInfo method, Object instance, Object[] args)
   at MS.Internal.Xaml.Runtime.ClrObjectRuntime.SetValue(Object inst, XamlMember property, Object value)
   at MS.Internal.Xaml.Runtime.PartialTrustTolerantRuntime.SetValue(Object obj, XamlMember property, Object value)
   at System.Xaml.XamlObjectWriter.Logic_ApplyPropertyValue(ObjectWriterContext ctx, XamlMember prop, Object value, Boolean onParent)
   at System.Xaml.XamlObjectWriter.Logic_DoAssignmentToParentProperty(ObjectWriterContext ctx)
   at System.Xaml.XamlObjectWriter.WriteEndObject()
   at System.Windows.FrameworkTemplate.LoadTemplateXaml(XamlReader templateReader, XamlObjectWriter currentWriter)
   at System.Windows.FrameworkTemplate.LoadTemplateXaml(XamlObjectWriter objectWriter)
   at System.Windows.FrameworkTemplate.LoadOptimizedTemplateContent(DependencyObject container, IComponentConnector componentConnector, IStyleConnector styleConnector, List`1 affectedChildren, UncommonField`1 templatedNonFeChildrenField)
   at System.Windows.FrameworkTemplate.LoadContent(DependencyObject container, List`1 affectedChildren)
   at System.Windows.StyleHelper.ApplyTemplateContent(UncommonField`1 dataField, DependencyObject container, FrameworkElementFactory templateRoot, Int32 lastChildIndex, HybridDictionary childIndexFromChildID, FrameworkTemplate frameworkTemplate)
   at System.Windows.FrameworkTemplate.ApplyTemplateContent(UncommonField`1 templateDataField, FrameworkElement container)
   at System.Windows.FrameworkElement.ApplyTemplate()
   at System.Windows.FrameworkElement.MeasureCore(Size availableSize)
   at System.Windows.UIElement.Measure(Size availableSize)
   at MS.Internal.Helper.MeasureElementWithSingleChild(UIElement element, Size constraint)
   at System.Windows.Controls.ContentPresenter.MeasureOverride(Size constraint)
   at System.Windows.FrameworkElement.MeasureCore(Size availableSize)
   at System.Windows.UIElement.Measure(Size availableSize)
   at System.Windows.Controls.Grid.MeasureCell(Int32 cell, Boolean forceInfinityV)
   at System.Windows.Controls.Grid.MeasureCellsGroup(Int32 cellsHead, Size referenceSize, Boolean ignoreDesiredSizeU, Boolean forceInfinityV, Boolean& hasDesiredSizeUChanged)
   at System.Windows.Controls.Grid.MeasureOverride(Size constraint)
   at System.Windows.FrameworkElement.MeasureCore(Size availableSize)
   at System.Windows.UIElement.Measure(Size availableSize)
   at System.Windows.Controls.Border.MeasureOverride(Size constraint)
   at System.Windows.FrameworkElement.MeasureCore(Size availableSize)
   at System.Windows.UIElement.Measure(Size availableSize)
   at System.Windows.Controls.Control.MeasureOverride(Size constraint)
   at System.Windows.FrameworkElement.MeasureCore(Size availableSize)
   at System.Windows.UIElement.Measure(Size availableSize)
   at MS.Internal.Helper.MeasureElementWithSingleChild(UIElement element, Size constraint)
   at System.Windows.Controls.ContentPresenter.MeasureOverride(Size constraint)
   at System.Windows.FrameworkElement.MeasureCore(Size availableSize)
   at System.Windows.UIElement.Measure(Size availableSize)
   at System.Windows.Controls.Border.MeasureOverride(Size constraint)
   at System.Windows.FrameworkElement.MeasureCore(Size availableSize)
   at System.Windows.UIElement.Measure(Size availableSize)
   at System.Windows.Controls.Grid.MeasureCell(Int32 cell, Boolean forceInfinityV)
   at System.Windows.Controls.Grid.MeasureCellsGroup(Int32 cellsHead, Size referenceSize, Boolean ignoreDesiredSizeU, Boolean forceInfinityV, Boolean& hasDesiredSizeUChanged)
   at System.Windows.Controls.Grid.MeasureOverride(Size constraint)
   at System.Windows.FrameworkElement.MeasureCore(Size availableSize)
   at System.Windows.UIElement.Measure(Size availableSize)
   at System.Windows.Controls.Control.MeasureOverride(Size constraint)
   at System.Windows.FrameworkElement.MeasureCore(Size availableSize)
   at System.Windows.UIElement.Measure(Size availableSize)
   at System.Windows.Controls.Grid.MeasureCell(Int32 cell, Boolean forceInfinityV)
   at System.Windows.Controls.Grid.MeasureCellsGroup(Int32 cellsHead, Size referenceSize, Boolean ignoreDesiredSizeU, Boolean forceInfinityV, Boolean& hasDesiredSizeUChanged)
   at System.Windows.Controls.Grid.MeasureOverride(Size constraint)
   at System.Windows.FrameworkElement.MeasureCore(Size availableSize)
   at System.Windows.UIElement.Measure(Size availableSize)
   at System.Windows.ContextLayoutManager.UpdateLayout()
   at System.Windows.ContextLayoutManager.UpdateLayoutCallback(Object arg)
   at System.Windows.Media.MediaContext.FireInvokeOnRenderCallbacks()
   at System.Windows.Media.MediaContext.RenderMessageHandlerCore(Object resizedCompositionTarget)
   at System.Windows.Media.MediaContext.RenderMessageHandler(Object resizedCompositionTarget)
   at System.Windows.Interop.HwndTarget.OnResize()
   at System.Windows.Interop.HwndTarget.HandleMessage(WindowMessage msg, IntPtr wparam, IntPtr lparam)
   at System.Windows.Interop.HwndSource.HwndTargetFilterMessage(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.CallWindowProc(IntPtr wndProc, IntPtr hWnd, Int32 msg, IntPtr wParam, IntPtr lParam)
   at MS.Win32.UnsafeNativeMethods.CallWindowProc(IntPtr wndProc, IntPtr hWnd, Int32 msg, IntPtr wParam, IntPtr lParam)
   at MS.Win32.HwndSubclass.DefWndProcWrapper(IntPtr hwnd, Int32 msg, IntPtr wParam, IntPtr lParam)
   at MS.Win32.UnsafeNativeMethods.CallWindowProc(IntPtr wndProc, IntPtr hWnd, Int32 msg, IntPtr wParam, IntPtr lParam)
   at MS.Win32.UnsafeNativeMethods.CallWindowProc(IntPtr wndProc, IntPtr hWnd, Int32 msg, IntPtr wParam, IntPtr lParam)
   at MS.Win32.HwndSubclass.SubclassWndProc(IntPtr hwnd, Int32 msg, IntPtr wParam, IntPtr lParam)
   at Windows.Win32.PInvoke.SetWindowPos(HWND hWnd, HWND hWndInsertAfter, Int32 X, Int32 Y, Int32 cx, Int32 cy, SET_WINDOW_POS_FLAGS uFlags)
   at Windows.Win32.PInvoke.SetWindowPos(HWND hWnd, HWND hWndInsertAfter, Int32 X, Int32 Y, Int32 cx, Int32 cy, SET_WINDOW_POS_FLAGS uFlags)
   at ControlzEx.Behaviors.WindowChromeBehavior._ApplyNewCustomChrome()
   at ControlzEx.Behaviors.WindowChromeBehavior.Initialize()
   at ControlzEx.Behaviors.WindowChromeBehavior.OnAttached()
   at Microsoft.Xaml.Behaviors.Behavior.Attach(DependencyObject dependencyObject)
   at Microsoft.Xaml.Behaviors.BehaviorCollection.ItemAdded(Behavior item)
   at Microsoft.Xaml.Behaviors.AttachableCollection`1.OnCollectionChanged(Object sender, NotifyCollectionChangedEventArgs e)
   at System.Windows.FreezableCollection`1.OnCollectionChanged(NotifyCollectionChangedEventArgs e)
   at System.Windows.FreezableCollection`1.OnCollectionChanged(NotifyCollectionChangedAction action, Int32 oldIndex, T oldValue, Int32 newIndex, T newValue)
   at System.Windows.FreezableCollection`1.AddHelper(T value)
   at ControlzEx.WindowChromeWindow.InitializeWindowChromeBehavior()
   at ControlzEx.WindowChromeWindow.InitializeBehaviors()
   at System.Windows.Window.CreateSourceWindow(Boolean duringShow)
   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.AccountView.AccountViewProvider.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.B.MoveNext()

Dette ligner på problemet beskrevet i:

Som har ført til innføringen av avkrysningsboksen for å inkludere inaktive felt.

Råd 1 er å kontrollere nøye at avkrysningsboksen er aktivert.

I den neste 24.0-utgivelsen vil feilkoden itgenacw066 vises dersom denne avkrysningsboksen var aktivert, i stedet for itgenacw063, for å redusere usikkerhet.

Råd 2 er å kontrollere at pay_link er en standardtabell i AccountView. Hvis ikke, vennligst legg til en (anonymisert) skjermutskrift fra AccountView som viser innholdet i denne tabellen.

AccountView-driveren støtter også tilpassede tabeller, men de er kanskje ikke alltid definert på samme måte som AccountView foreskriver.

Råd 3 er å generere feilmeldingen på nytt med release 24.0.752. Denne finner du her:

Denne release 24.0.752 sender mer informasjon til Systemmeldinger på Invantive Cloud sammen med feilmeldingen. Siden dette er et produkt som ikke deles av flere brukere, påvirkes det ikke av sommerfreezen.

Kjørte jobben med den nye versjonen. Fikk dere feilloggen?

Nei, vi finner bare loggingen på Query Tool versjon 24.0.686.

Er det mulig å gjenskape feilen med versjon 24.0.752 av Query Tool eller Data Hub?

Beklager, Query Tool var faktisk ikke blitt oppdatert, nå er den det. Det kan hende feilen nå har kommet inn, men programvaren ba også om en omstart av serveren, så det kan være derfor den ikke gjorde det. Jeg kan dessverre ikke gjøre omstarten nå, det gjør jeg i natt.

Under utgivelse 24.0.752 oppstår følgende feilmelding:

itgenacw063
Tabellen ‘PAY_LINK’ har ingen felter valgt fra 13 tilgjengelige felter.
Vurder å konfigurere include-inactive-fields til true etter å ha konsultert AccountView-applikasjonsadministratoren for å kompensere for metadatafeil.

Feltsdefinisjonene er:

Navn Data Type Påkrevd? Aktiv? Virtuell?
PAY_LINK.REC_ID varchar2(10) N N J
PAY_LINK.INV_NR varchar2(12) N N J
PAY_LINK.SUB_NR varchar2(10) N N J
PAY_LINK.LINK_ID varchar2(32) N N J
PAY_LINK.INP_DATE datetime J N J
PAY_LINK.CNG_DATE datetime J N J
PAY_LINK.INP_USR varchar2(20) J N J
PAY_LINK.CNG_USR varchar2(20) J N J
PAY_LINK.CNG_NR integer(4) J N J
PAY_LINK.LINK_STATE integer(4) J N J
PAY_LINK.LINK_URL varchar2(254) J N J
PAY_LINK.SRC_OBJ varchar2(4) J N J
PAY_LINK.TRIAL_LNK boolean J N J

Det ser ut til at den øverste er riktig innstilt, men jeg har nå oppdaget at det er to egendefinerte felt i tabellene. Jeg tror de ble lagt til tidligere på forespørsel fra en kollega. Det gjelder feltene partition_code og partition_name. Jeg ser at de ikke er avkrysset, og jeg kan heller ikke krysse dem av. Kan det være årsaken? Beklager det sene svaret. (ferie)

2025-08-11 Pay_Link

Disse to obligatoriske feltene legges automatisk til av Invantive UniversalSQL-driveren for AccountView når det gjelder en tabell som kan ha forskjellig innhold i hver administrasjon og/eller år. Dette gjelder nesten alle tabeller.

Invantive UniversalSQL-driveren slår nemlig sammen alle administrasjonsår i ett datasett.

Problemet ifølge registreringen er at alle feltene er inaktive.

Fungerer det med den nyeste versjonen hvis du aktiverer include-inactive-fields?

Nei, dessverre fungerer det ikke med include-inactive-fields heller. Jeg har nettopp gjort en avtale for å se på dette problemet.

Problemet viste seg ikke lenger å oppstå under versjon 25.0 med Data Hub. Invantive Query Tool brukte automatisk pålogging, slik at den manuelle innstillingen av include-inactive-fields ikke ble tatt i bruk.

Problemet er løst generelt ved å inkludere include-inactive-fields i tilkoblingsstrengen i settings*.xml som:

connectionString="system-tables-directory=\\acme-srv01\Accountview;include-inactive-fields=True;include-inaccessible-databases=False;database-search-directories=\\acme-srv01\Accountview\admins;text-encoding=Windows-1252;ignore-memo-value-errors=True"