Problem z dostępem do informatora

Adam G · 22 Stycznia 2021

Mam następujący problem na chwilę obecną znalazłem dwa indeksy utworzone sferycznie w 2016 roku.

Przy próbie wejścia w informator wyskakuje taki błąd:

InsERT.Mox.WpfControls.ServiceGridElements.C1.ExceptionsFactory+GetSourceQueryException: InsERT.Mox.WpfControls.ServiceGridElements.C1.ExceptionsFactory+ExceptionContext SvcGrid.GetSourceQuery failed An error occurred while executing the command definition. See the inner exception for details.
   w InsERT.Mox.WpfControls.SvcGrid.GetSourceQueryHandleAcceptableExceptions()
   w InsERT.Mox.WpfControls.SvcGrid.SetupItemsSource(Boolean newCollectionView, IActualConfig actualConfig, IGroupsStates groupsStates, Object positonOnIdentifier, IInitializeGridActions initializeActions)
   w InsERT.Mox.WpfControls.SvcGrid.DoApplyGridParameters(IGridConfig gridConfig, Boolean reloadSourceQuery)
   w InsERT.Mox.WpfControls.SvcGrid.ApplyProperties()
   w InsERT.Mox.WpfControls.SvcGrid.OnApplyTemplate()
   w System.Windows.FrameworkElement.ApplyTemplate()
   w System.Windows.FrameworkElement.MeasureCore(Size availableSize)
   w System.Windows.UIElement.Measure(Size availableSize)
   w InsERT.Mox.WpfControls.OverlappingPanel.MeasureOverride(Size constraint)
   w System.Windows.FrameworkElement.MeasureCore(Size availableSize)
   w System.Windows.UIElement.Measure(Size availableSize)
   w System.Windows.Controls.Control.MeasureOverride(Size constraint)
   w System.Windows.FrameworkElement.MeasureCore(Size availableSize)
   w System.Windows.UIElement.Measure(Size availableSize)
   w System.Windows.Controls.Decorator.MeasureOverride(Size constraint)
   w System.Windows.FrameworkElement.MeasureCore(Size availableSize)
   w System.Windows.UIElement.Measure(Size availableSize)
   w System.Windows.Controls.Grid.MeasureCell(Int32 cell, Boolean forceInfinityV)
   w System.Windows.Controls.Grid.MeasureCellsGroup(Int32 cellsHead, Size referenceSize, Boolean ignoreDesiredSizeU, Boolean forceInfinityV, Boolean& hasDesiredSizeUChanged)
   w System.Windows.Controls.Grid.MeasureCellsGroup(Int32 cellsHead, Size referenceSize, Boolean ignoreDesiredSizeU, Boolean forceInfinityV)
   w System.Windows.Controls.Grid.MeasureOverride(Size constraint)
   w System.Windows.FrameworkElement.MeasureCore(Size availableSize)
   w System.Windows.UIElement.Measure(Size availableSize)
   w System.Windows.Controls.Control.MeasureOverride(Size constraint)
   w System.Windows.FrameworkElement.MeasureCore(Size availableSize)
   w System.Windows.UIElement.Measure(Size availableSize)
   w System.Windows.Controls.Decorator.MeasureOverride(Size constraint)
   w System.Windows.FrameworkElement.MeasureCore(Size availableSize)
   w System.Windows.UIElement.Measure(Size availableSize)
   w System.Windows.ContextLayoutManager.UpdateLayout()
   w System.Windows.ContextLayoutManager.UpdateLayoutCallback(Object arg)
   w System.Windows.Media.MediaContext.InvokeOnRenderCallback.DoWork()
   w System.Windows.Media.MediaContext.FireInvokeOnRenderCallbacks()
   w System.Windows.Media.MediaContext.RenderMessageHandlerCore(Object resizedCompositionTarget)
   w System.Windows.Media.MediaContext.RenderMessageHandler(Object resizedCompositionTarget)
   w System.Windows.Threading.ExceptionWrapper.InternalRealCall(Delegate callback, Object args, Int32 numArgs)
   w System.Windows.Threading.ExceptionWrapper.TryCatchWhen(Object source, Delegate callback, Object args, Int32 numArgs, Delegate catchHandler)
-System.Data.Entity.Core.EntityCommandExecutionException: An error occurred while executing the command definition. See the inner exception for details.
-   w System.Data.Entity.Core.EntityClient.Internal.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior, ObjectContext objectContext)
   w System.Data.Entity.Core.Objects.Internal.ObjectQueryExecutionPlan.Execute[TResultType](ObjectContext context, ObjectParameterCollection parameterValues)
   w System.Data.Entity.Core.Objects.ObjectQuery`1.GetResults(Nullable`1 forMergeOption)
   w System.Data.Entity.Core.Objects.ObjectQuery`1.<System.Collections.Generic.IEnumerable<T>.GetEnumerator>b__26_0()
   w System.Lazy`1.CreateValue()
   w System.Lazy`1.LazyInitValue()
   w System.Lazy`1.get_Value()
   w System.Data.Entity.Internal.LazyEnumerator`1.MoveNext()
   w System.Linq.Buffer`1..ctor(IEnumerable`1 source)
   w System.Linq.Enumerable.ToArray[TSource](IEnumerable`1 source)
   w InsERT.Moria.Dokumenty.Logistyka.RaportRuchuAsortymentu.PostFilterProcess(IInjectionScope unitOfWork, IQueryable`1 source)
   w InsERT.Moria.Logistyka.UI.RuchAsortymentuDataSource.PostFilterProcess(IQueryable`1 source)
   w InsERT.Mox.UIFramework.FilterableSourceBase`1.get_Source()
   w InsERT.Mox.UIFramework.GridDataSource`1.GetSourceQuery()
   w InsERT.Mox.WpfControls.SvcGrid.GetSourceQueryFromGridDataSource()
   w InsERT.Mox.WpfControls.SvcGrid.GetSourceQueryHandleAcceptableExceptions()
--System.Data.SqlClient.SqlException: Upłynął limit czasu wykonywania. Limit upłynął przed ukończeniem operacji lub serwer nie odpowiada.
--   w System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   w System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   w System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   w System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   w System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
   w System.Data.SqlClient.SqlDataReader.get_MetaData()
   w System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
   w System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
   w System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   w System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   w System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   w System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
   w System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior)
   w System.Data.Entity.Core.EntityClient.Internal.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior, ObjectContext objectContext)
---System.ComponentModel.Win32Exception: Upłynął limit czasu operacji oczekiwania

EnvironmentStackTrace:
   w System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   w System.Environment.get_StackTrace()
   w InsERT.Mox.UIFramework.AnalyzedException..ctor(Exception exception)
   w InsERT.Mox.UIFramework.ErrorContext..ctor(Exception exception, String dumpFilePath, Stream screenCapture)
   w InsERT.Moria.Startup.UI.NerfSupport.ShowFerfWindow(Exception exception, String dumpFile, Boolean newThread)
   w InsERT.Moria.Startup.UI.NerfSupport.HandleUsingFerf(Exception exception)
   w InsERT.Moria.Startup.UI.NerfSupport.ProcessUnhandledException(Exception exception)
   w InsERT.Moria.Startup.UI.NerfSupport.Dispatcher_UnhandledExceptionFilter(Object sender, DispatcherUnhandledExceptionFilterEventArgs e)
   w System.Windows.Threading.Dispatcher.ExceptionFilter(Exception e)
   w System.Windows.Threading.Dispatcher.ExceptionFilterStatic(Object source, Exception e)
   w System.Windows.Threading.ExceptionWrapper.FilterException(Object source, Exception e)
   w System.Windows.Threading.ExceptionWrapper.TryCatchWhen(Object source, Delegate callback, Object args, Int32 numArgs, Delegate catchHandler)
   w InsERT.Mox.WpfControls.SvcGrid.GetSourceQueryHandleAcceptableExceptions()
   w InsERT.Mox.WpfControls.SvcGrid.SetupItemsSource(Boolean newCollectionView, IActualConfig actualConfig, IGroupsStates groupsStates, Object positonOnIdentifier, IInitializeGridActions initializeActions)
   w InsERT.Mox.WpfControls.SvcGrid.DoApplyGridParameters(IGridConfig gridConfig, Boolean reloadSourceQuery)
   w InsERT.Mox.WpfControls.SvcGrid.ApplyProperties()
   w InsERT.Mox.WpfControls.SvcGrid.OnApplyTemplate()
   w System.Windows.FrameworkElement.ApplyTemplate()
   w System.Windows.FrameworkElement.MeasureCore(Size availableSize)
   w System.Windows.UIElement.Measure(Size availableSize)
   w InsERT.Mox.WpfControls.OverlappingPanel.MeasureOverride(Size constraint)
   w System.Windows.FrameworkElement.MeasureCore(Size availableSize)
   w System.Windows.UIElement.Measure(Size availableSize)
   w System.Windows.Controls.Control.MeasureOverride(Size constraint)
   w System.Windows.FrameworkElement.MeasureCore(Size availableSize)
   w System.Windows.UIElement.Measure(Size availableSize)
   w System.Windows.Controls.Decorator.MeasureOverride(Size constraint)
   w System.Windows.FrameworkElement.MeasureCore(Size availableSize)
   w System.Windows.UIElement.Measure(Size availableSize)
   w System.Windows.Controls.Grid.MeasureCell(Int32 cell, Boolean forceInfinityV)
   w System.Windows.Controls.Grid.MeasureCellsGroup(Int32 cellsHead, Size referenceSize, Boolean ignoreDesiredSizeU, Boolean forceInfinityV, Boolean& hasDesiredSizeUChanged)
   w System.Windows.Controls.Grid.MeasureCellsGroup(Int32 cellsHead, Size referenceSize, Boolean ignoreDesiredSizeU, Boolean forceInfinityV)
   w System.Windows.Controls.Grid.MeasureOverride(Size constraint)
   w System.Windows.FrameworkElement.MeasureCore(Size availableSize)
   w System.Windows.UIElement.Measure(Size availableSize)
   w System.Windows.Controls.Control.MeasureOverride(Size constraint)
   w System.Windows.FrameworkElement.MeasureCore(Size availableSize)
   w System.Windows.UIElement.Measure(Size availableSize)
   w System.Windows.Controls.Decorator.MeasureOverride(Size constraint)
   w System.Windows.FrameworkElement.MeasureCore(Size availableSize)
   w System.Windows.UIElement.Measure(Size availableSize)
   w System.Windows.ContextLayoutManager.UpdateLayout()
   w System.Windows.ContextLayoutManager.UpdateLayoutCallback(Object arg)
   w System.Windows.Media.MediaContext.InvokeOnRenderCallback.DoWork()
   w System.Windows.Media.MediaContext.FireInvokeOnRenderCallbacks()
   w System.Windows.Media.MediaContext.RenderMessageHandlerCore(Object resizedCompositionTarget)
   w System.Windows.Media.MediaContext.RenderMessageHandler(Object resizedCompositionTarget)
   w System.Windows.Threading.ExceptionWrapper.InternalRealCall(Delegate callback, Object args, Int32 numArgs)
   w System.Windows.Threading.ExceptionWrapper.TryCatchWhen(Object source, Delegate callback, Object args, Int32 numArgs, Delegate catchHandler)
   w System.Windows.Threading.DispatcherOperation.InvokeImpl()
   w System.Windows.Threading.DispatcherOperation.InvokeInSecurityContext(Object state)
   w MS.Internal.CulturePreservingExecutionContext.CallbackWrapper(Object obj)
   w System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   w System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   w System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   w MS.Internal.CulturePreservingExecutionContext.Run(CulturePreservingExecutionContext executionContext, ContextCallback callback, Object state)
   w System.Windows.Threading.DispatcherOperation.Invoke()
   w System.Windows.Threading.Dispatcher.ProcessQueue()
   w System.Windows.Threading.Dispatcher.WndProcHook(IntPtr hwnd, Int32 msg, IntPtr wParam, IntPtr lParam, Boolean& handled)
   w MS.Win32.HwndWrapper.WndProc(IntPtr hwnd, Int32 msg, IntPtr wParam, IntPtr lParam, Boolean& handled)
   w MS.Win32.HwndSubclass.DispatcherCallbackOperation(Object o)
   w System.Windows.Threading.ExceptionWrapper.InternalRealCall(Delegate callback, Object args, Int32 numArgs)
   w System.Windows.Threading.ExceptionWrapper.TryCatchWhen(Object source, Delegate callback, Object args, Int32 numArgs, Delegate catchHandler)
   w System.Windows.Threading.Dispatcher.LegacyInvokeImpl(DispatcherPriority priority, TimeSpan timeout, Delegate method, Object args, Int32 numArgs)
   w MS.Win32.HwndSubclass.SubclassWndProc(IntPtr hwnd, Int32 msg, IntPtr wParam, IntPtr lParam)
   w MS.Win32.UnsafeNativeMethods.DispatchMessage(MSG& msg)
   w System.Windows.Threading.Dispatcher.PushFrameImpl(DispatcherFrame frame)
   w System.Windows.Threading.Dispatcher.PushFrame(DispatcherFrame frame)
   w System.Windows.Window.ShowHelper(Object booleanBox)
   w System.Windows.Window.Show()
   w System.Windows.Window.ShowDialog()
   w InsERT.Moria.Startup.UI.NexoAppBase.Go()
   w InsERT.Moria.Subiekt.SubiektApp.Main(String[] args)

Czy można liczyć na jakąś pomoc w tym temacie?

Przemysław Werner · 22 Stycznia 2021

Proszę w pierwszej kolejności wykonać konserwację bazy danych, a w kolejnym kroku spróbować zawęzić zakres danych z wykorzystaniem filtrów.

Adam G · 22 Stycznia 2021

Konserwacja bazy danych była wykonana 2 dni temu po aktualizacji do 34.0.1.

Nie jestem w stanie zawęzić zakresu danych bo błąd wyskakuje przed pojawieniem się okna Informatora.

Problem się zapętla i trzeba ubić proces Subiekta, aby móc pracować z programem.

W międzyczasie znalazł się jeszcze jeden index w asortymencie z tym samym błędem(tez utworzony sferycznie w 2016 roku).

Przemysław Werner · 22 Stycznia 2021

Niestety bez analizy danych nie jesteśmy w stanie jednoznacznie określić przyczyny. Proszę o przesłanie danych przez formularz kontaktowy, kontynuując korespondencję z InsERT pod numerem zgłoszenia INS-680699.

Subiekt nexo

Rachmistrz nexo

Rewizor nexo

Gratyfikant nexo

Gestor nexo

Biuro nexo

Subiekt 123

Subiekt GT

Rachmistrz GT

Rewizor GT

Gratyfikant GT

Gestor GT

Biuro GT

Problem z dostępem do informatora

Polecane posty

Adam G 23

Link to postu

Przemysław Werner 393

Link to postu

Adam G 23

Link to postu

Przemysław Werner 393

Link to postu

Pomoc