Database query value does not appear in formula bar like others

%3CLINGO-SUB%20id%3D%22lingo-sub-2832043%22%20slang%3D%22en-US%22%3ERe%3A%20Database%20query%20value%20does%20not%20appear%20in%20formula%20bar%20like%20others%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2832043%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1165219%22%20target%3D%22_blank%22%3E%40rodsan724%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYour%20posting%20here%20at%20%3CSTRONG%3Etechcommunity%3C%2FSTRONG%3E%20has%20had%20(as%20I%20write%20this)%2060%20views%20and%20no%20replies.%20I%20think%20it's%20reasonable%20to%20assume%20that%20it's%20because%20you've%20overwhelmed%20everybody%20with%20not%20enough%20information%20but%20a%20lot%20of%20static%20%5Bis%20that%20long%20string%20of%20text%20at%20the%20end%20of%20your%20post%20the%20content%20you%20get%20back%20from%20the%20query%3F%20I%20assume%20so%5D%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnyway%2C%20some%20questions%20for%20you%3A%20what%20kind%20of%20database%20query%20is%20this%3F%20What's%20different%20about%20those%20queries%20that%20DO%20work%3F%20Or%20the%20records%20of%20the%20queries%20that%20do%20work%3F%20If%20we're%20going%20to%20find%20the%20cause%20of%20this%20apparent%20discrepancy%2C%20we%20need%20to%20be%20looking%20for%20%3CU%3E%3CEM%3E%3CSTRONG%3Edistinctions%20of%20kind%3C%2FSTRONG%3E%3C%2FEM%3E%3C%2FU%3E%20in%20various%20aspects%20of%20the%20database%2C%20its%20records%2C%20the%20fields%20that%20you're%20using%20to%20retrieve%20the%20records%2C%20etc.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20you%20say%20you%20%22have%20a%20database%20query%20with%20just%20a%20few%20fields%22%20are%20you%20saying%20that%20there%20are%3A%3C%2FP%3E%3CUL%3E%3CLI%3Ejust%20a%20few%20fields%20being%20used%20as%20criteria%3F%3C%2FLI%3E%3CLI%3Ejust%20a%20few%20fields%20in%20each%20record%3F%3C%2FLI%3E%3CLI%3Ejust%20a%20few%20records%3F%3C%2FLI%3E%3CLI%3Esomething%20else%3F%3C%2FLI%3E%3C%2FUL%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHave%20you%20had%20similar%20queries%20from%20similar%20databases%20in%20the%20past%20(perhaps%20even%20prior%20instances%20of%20the%20same%20database%2C%20just%20earlier%20versions)%20where%20you%20did%20not%20experience%20this%20anomaly%3F%20What%20is%20different%20this%20time%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThose%20are%20just%20for%20starters%3A%20if%20there's%20anything%20else%20you%20can%20say%20that%20might%20help%20get%20a%20more%20complete%20picture%3F%20One%20last%20question%3A%20is%20it%20at%20all%20possible%20for%20you%20to%20post%20a%20copy%20of%20the%20actual%20spreadsheet%2Fworkbook%3F%20Images%20are%20frankly%20of%20limited%20utility%20in%20the%20diagnostic%20process.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2828686%22%20slang%3D%22en-US%22%3EDatabase%20query%20value%20does%20not%20appear%20in%20formula%20bar%20like%20others%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2828686%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20database%20query%20with%20just%20a%20few%20fields.%20One%20field%20is%20called%20FileContents%20and%20it%20contains%20the%20contents%20of%20a%20log%20file.%20In%20this%20particular%20instance%2C%20it%20appears%20there%20is%20a%20value%20in%20the%20cell%2C%20but%20when%20I%20click%20it%20to%20display%20it%20in%20formula%20bar%20it%20is%20blank.%20However%2C%20other%20records%20do%20display%20correctly.%20See%20below%20for%20the%20particular%20value%20in%20question.%20Other%20records%20are%20very%20similar%20and%20work%20fine.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22rodsan724_0-1633962272346.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F316506i618E3D6492E3486D%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22rodsan724_0-1633962272346.png%22%20alt%3D%22rodsan724_0-1633962272346.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EHere%20is%20the%20value%20for%20the%20log%20file%20field%2C%20it%20only%20happens%20in%20this%20particular%20instance%2C%20other%20logged%20items%20appear%20fine...%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E---%20End%20of%20stack%20trace%20from%20previous%20location%20where%20exception%20was%20thrown%20---%20at%20System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()%20at%20System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task%20task)%20at%20Microsoft.AspNetCore.SignalR.Client.HubConnection.%3CSTARTASYNC%3Ed__49.MoveNext()%20---%20End%20of%20stack%20trace%20from%20previous%20location%20where%20exception%20was%20thrown%20---%20at%20System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()%20at%20System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task%20task)%20at%20System.Runtime.CompilerServices.TaskAwaiter.GetResult()%20_61_6%26gt%3Bd.MoveNext()%2020211008%2007%3A33%3A17.082%20-04%3A00%20%5BERR%5D%20SignalR%20disconnected%20TID%3A49%20Mem%3A143333120%20System.Net.Http.HttpRequestException%3A%20Response%20status%20code%20does%20not%20indicate%20success%3A%20401%20(Unauthorized).%20at%20System.Net.Http.HttpResponseMessage.EnsureSuccessStatusCode()%20at%20Microsoft.AspNetCore.Http.Connections.Client.HttpConnection.%3CNEGOTIATEASYNC%3Ed__45.MoveNext()%20---%20End%20of%20stack%20trace%20from%20previous%20location%20where%20exception%20was%20thrown%20---%20at%20System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()%20at%20System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task%20task)%20at%20Microsoft.AspNetCore.Http.Connections.Client.HttpConnection.%3CGETNEGOTIATIONRESPONSEASYNC%3Ed__52.MoveNext()%20---%20End%20of%20stack%20trace%20from%20previous%20location%20where%20exception%20was%20thrown%20---%20at%20System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()%20at%20Microsoft.AspNetCore.Http.Connections.Client.HttpConnection.%3CSELECTANDSTARTTRANSPORT%3Ed__44.MoveNext()%20---%20End%20of%20stack%20trace%20from%20previous%20location%20where%20exception%20was%20thrown%20---%20at%20System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()%20at%20System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task%20task)%20at%20Microsoft.AspNetCore.Http.Connections.Client.HttpConnection.%3CSTARTASYNCCORE%3Ed__41.MoveNext()%20---%20End%20of%20stack%20trace%20from%20previous%20location%20where%20exception%20was%20thrown%20---%20at%20System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()%20at%20System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task%20task)%20at%20Microsoft.AspNetCore.Http.Connections.Client.HttpConnection.%3CSTARTASYNC%3Ed__40.MoveNext()%20---%20End%20of%20stack%20trace%20from%20previous%20location%20where%20exception%20was%20thrown%20---%20at%20System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()%20at%20System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task%20task)%20at%20Microsoft.AspNetCore.Http.Connections.Client.HttpConnectionFactory.%3CCONNECTASYNC%3Ed__3.MoveNext()%20---%20End%20of%20stack%20trace%20from%20previous%20location%20where%20exception%20was%20thrown%20---%20at%20System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()%20at%20Microsoft.AspNetCore.Http.Connections.Client.HttpConnectionFactory.%3CCONNECTASYNC%3Ed__3.MoveNext()%20---%20End%20of%20stack%20trace%20from%20previous%20location%20where%20exception%20was%20thrown%20---%20at%20System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()%20at%20System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task%20task)%20at%20Microsoft.AspNetCore.SignalR.Client.HubConnection.%3CSTARTASYNCCORE%3Ed__58.MoveNext()%20---%20End%20of%20stack%20trace%20from%20previous%20location%20where%20exception%20was%20thrown%20---%20at%20System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()%20at%20System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task%20task)%20at%20Microsoft.AspNetCore.SignalR.Client.HubConnection.%3CSTARTASYNCINNER%3Ed__50.MoveNext()%20---%20End%20of%20stack%20trace%20from%20previous%20location%20where%20exception%20was%20thrown%20---%20at%20System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()%20at%20System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task%20task)%20at%20Microsoft.AspNetCore.SignalR.Client.HubConnection.%3CSTARTASYNC%3Ed__49.MoveNext()%20---%20End%20of%20stack%20trace%20from%20previous%20location%20where%20exception%20was%20thrown%20---%20at%20System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()%20at%20System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task%20task)%20at%20System.Runtime.CompilerServices.TaskAwaiter.GetResult()%20%26lt%3B%3CINIT%3Eb__61_6%26gt%3Bd.MoveNext()%2020211008%2007%3A33%3A28.045%20-04%3A00%20%5BDBG%5D%20HomeIsSelected%20%3A%20False%20TID%3A1%20Mem%3A148871304%2020211008%2007%3A33%3A28.046%20-04%3A00%20%5BDBG%5D%20%3A%20True%20TID%3A1%20Mem%3A148887632%2020211008%2007%3A33%3A28.843%20-04%3A00%20%5BERR%5D%20LoadCommand%20failed%20TID%3A1%20Mem%3A151559472%20Refit.ApiException%3A%20Response%20status%20code%20does%20not%20indicate%20success%3A%20401%20(Unauthorized).%20at%20Refit.RequestBuilderImplementation.%26lt%3B%26gt%3Bc__DisplayClass14_0%602.%26lt%3B%3CBUILDCANCELLABLETASKFUNCFORMETHOD%3Eb__0%26gt%3Bd.MoveNext()%20in%20%2F_%2FRefit%2FRequestBuilderImplementation.cs%3Aline%20267%20---%20End%20of%20stack%20trace%20from%20previous%20location%20where%20exception%20was%20thrown%20---%20at%20System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()%20at%20System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task%20task)%20at%20System.Runtime.CompilerServices.TaskAwaiter%601.GetResult()%20a.%26lt%3B%26gt%3Bc__DisplayClass27_0.%26lt%3B%26lt%3B%26gt%3Bb__0%26gt%3Bd.MoveNext()%2020211008%2007%3A33%3A29.148%20-04%3A00%20%5BERR%5D%20LoadCommand%20failed%20TID%3A1%20Mem%3A151313920%20Refit.ApiException%3A%20Response%20status%20code%20does%20not%20indicate%20success%3A%20401%20(Unauthorized).%20at%20Refit.RequestBuilderImplementation.%26lt%3B%26gt%3Bc__DisplayClass14_0%602.%26lt%3B%3CBUILDCANCELLABLETASKFUNCFORMETHOD%3Eb__0%26gt%3Bd.MoveNext()%20in%20%2F_%2FRefit%2FRequestBuilderImplementation.cs%3Aline%20267%20---%20End%20of%20stack%20trace%20from%20previous%20location%20where%20exception%20was%20thrown%20---%20at%20System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()%20at%20%26gt%3Bc__DisplayClass27_0.%26lt%3B%3CGETLOCATIONSBYSEARCH%3Eb__0%26gt%3Bd.MoveNext()%2020211008%2007%3A33%3A30.729%20-04%3A00%20%5BDBG%5D%20Lo%20False%20TID%3A1%20Mem%3A151251616%2020211008%2007%3A33%3A30.729%20-04%3A00%20%5BDBG%5D%20HomeIsSelected%20%3A%20True%20TID%3A1%20Mem%3A151251616%2020211008%2007%3A33%3A30.781%20-04%3A00%20%5BINF%5D%20%7B%2012%3A00%3A00%20AM%2C%2011008%2007%3A33%3A30.784%20-04%3A00%20%5BDBG%5D%20GetCache%20Start%20for%20location%20date%201166%20TID%3A1%20Mem%3A156359088%2020211008%2007%3A33%3A30.849%20-04%3A00%20%5BDBG%5D%20GetCache%20End%20for%20location%20date%201166%20TID%3A26%20Mem%3A164452952%2020211008%2007%3A33%3A30.905%20-04%3A00%20%5BERR%5D%20Dispatcher_UnhandledException%20-%20TID%3A1%20Mem%3A167274128%20ReactiveUI.UnhandledErrorException%3A%20An%20object%20implementing%20IHandleObservableErrors%20(often%20a%20ReactiveCommand%20or%20ObservableAsPropertyHelper)%20has%20errored%2C%20thereby%20breaking%20its%20observable%20pipeline.%20To%20prevent%20this%2C%20ensure%20the%20pipeline%20does%20not%20error%2C%20or%20Subscribe%20to%20the%20ThrownExceptions%20property%20of%20the%20object%20in%20question%20to%20handle%20the%20erroneous%20case.%20---%26gt%3B%20Refit.ApiException%3A%20Response%20status%20code%20does%20not%20indicate%20success%3A%20401%20(Unauthorized).%20at%20Refit.RequestBuilderImplementation.%26lt%3B%26gt%3Bc__DisplayClass14_0%602.%26lt%3B%3CBUILDCANCELLABLETASKFUNCFORMETHOD%3Eb__0%26gt%3Bd.MoveNext()%20in%20%2F_%2FRefit%2FRequestBuilderImplementation.cs%3Aline%20267%20---%20End%20of%20stack%20trace%20from%20previous%20location%20where%20exception%20was%20thrown%20---%20at%20System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()%20at%20System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task%20task)%20at%20System.Runtime.CompilerServices.TaskAwaiter%601.GetResult(d__19.MoveNext()%20---%20End%20of%20stack%20trace%20from%20previous%20location%20where%20exception%20was%20thrown%20---%20at%20System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()%20at%20System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task%20task)%20at%20System.Runtime.CompilerServices.TaskAwaiter%601.GetResult()%20Get%26gt%3Bb__95_0%26gt%3Bd.MoveNext()%20---%20End%20of%20stack%20trace%20from%20previous%20location%20where%20exception%20was%20thrown%20---%20at%20System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()%20at%20System.Reactive.ExceptionHelpers.ThrowIfNotNull(Exception%20exception)%20in%20%2F_%2FRx.NET%2FSource%2Fsrc%2FSystem.Reactive%2FInternal%2FExceptionServices.cs%3Aline%2022%20at%20System.Reactive.Subjects.AsyncSubject%601.GetResult()%20in%20%2F_%2FRx.NET%2FSource%2Fsrc%2FSystem.Reactive%2FSubjects%2FAsyncSubject.cs%3Aline%20439%20at%20l.%26lt%3B%26lt%3B-ctor%26gt%3Bb__52_9%26gt%3Bd.MoveNext()%20---%20End%20of%20inner%20exception%20stack%20trace%20---%20at%20ReactiveUI.RxApp.%26lt%3B%26gt%3Bc__DisplayClass10_0.%26lt%3B.cctor%26gt%3Bb__2()%20in%20D%3A%5Ca%5C1%5Cs%5Csrc%5CReactiveUI%5CRxApp.cs%3Aline%20106%20at%20System.Reactive.Concurrency.Scheduler.Invoke(IScheduler%20scheduler%2C%20Action%20action)%20in%20%2F_%2FRx.NET%2FSource%2Fsrc%2FSystem.Reactive%2FConcurrency%2FScheduler.Simple.cs%3Aline%20253%20at%20System.Reactive.Concurrency.DispatcherScheduler.%26lt%3B%26gt%3Bc__DisplayClass12_0%601.%3CSCHEDULE%3Eb__0()%20in%20%2F_%2FRx.NET%2FSource%2Fsrc%2FSystem.Reactive%2FPlatforms%2FDesktop%2FConcurrency%2FDispatcherScheduler.cs%3Aline%2098%20at%20System.Windows.Threading.ExceptionWrapper.InternalRealCall(Delegate%20callback%2C%20Object%20args%2C%20Int32%20numArgs)%20at%20System.Windows.Threading.ExceptionWrapper.TryCatchWhen(Object%20source%2C%20Delegate%20callback%2C%20Object%20args%2C%20Int32%20numArgs%2C%20Delegate%20catchHandler)%2020211008%2007%3A33%3A33.124%20-04%3A00%20%5BFTL%5D%20Dispatcher_UnhandledException%20-%20App%20Crash%2C%20Memory%20Available%2059%20%25%2C%20Process%20Memory%20Used%20583131136%20TID%3A1%20Mem%3A165303056%3C%2FSCHEDULE%3E%3C%2FBUILDCANCELLABLETASKFUNCFORMETHOD%3E%3C%2FGETLOCATIONSBYSEARCH%3E%3C%2FBUILDCANCELLABLETASKFUNCFORMETHOD%3E%3C%2FBUILDCANCELLABLETASKFUNCFORMETHOD%3E%3C%2FINIT%3E%3C%2FSTARTASYNC%3E%3C%2FSTARTASYNCINNER%3E%3C%2FSTARTASYNCCORE%3E%3C%2FCONNECTASYNC%3E%3C%2FCONNECTASYNC%3E%3C%2FSTARTASYNC%3E%3C%2FSTARTASYNCCORE%3E%3C%2FSELECTANDSTARTTRANSPORT%3E%3C%2FGETNEGOTIATIONRESPONSEASYNC%3E%3C%2FNEGOTIATEASYNC%3E%3C%2FSTARTASYNC%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2828686%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Contributor

I have a database query with just a few fields. One field is called FileContents and it contains the contents of a log file. In this particular instance, it appears there is a value in the cell, but when I click it to display it in formula bar it is blank. However, other records do display correctly. See below for the particular value in question. Other records are very similar and work fine.

 

rodsan724_0-1633962272346.png

Here is the value for the log file field, it only happens in this particular instance, other logged items appear fine...

 

--- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.AspNetCore.SignalR.Client.HubConnection.<StartAsync>d__49.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Runtime.CompilerServices.TaskAwaiter.GetResult() _61_6>d.MoveNext() 20211008 07:33:17.082 -04:00 [ERR] SignalR disconnected TID:49 Mem:143333120 System.Net.Http.HttpRequestException: Response status code does not indicate success: 401 (Unauthorized). at System.Net.Http.HttpResponseMessage.EnsureSuccessStatusCode() at Microsoft.AspNetCore.Http.Connections.Client.HttpConnection.<NegotiateAsync>d__45.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.AspNetCore.Http.Connections.Client.HttpConnection.<GetNegotiationResponseAsync>d__52.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at Microsoft.AspNetCore.Http.Connections.Client.HttpConnection.<SelectAndStartTransport>d__44.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.AspNetCore.Http.Connections.Client.HttpConnection.<StartAsyncCore>d__41.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.AspNetCore.Http.Connections.Client.HttpConnection.<StartAsync>d__40.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.AspNetCore.Http.Connections.Client.HttpConnectionFactory.<ConnectAsync>d__3.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at Microsoft.AspNetCore.Http.Connections.Client.HttpConnectionFactory.<ConnectAsync>d__3.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.AspNetCore.SignalR.Client.HubConnection.<StartAsyncCore>d__58.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.AspNetCore.SignalR.Client.HubConnection.<StartAsyncInner>d__50.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.AspNetCore.SignalR.Client.HubConnection.<StartAsync>d__49.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Runtime.CompilerServices.TaskAwaiter.GetResult() <<Init>b__61_6>d.MoveNext() 20211008 07:33:28.045 -04:00 [DBG] HomeIsSelected : False TID:1 Mem:148871304 20211008 07:33:28.046 -04:00 [DBG] : True TID:1 Mem:148887632 20211008 07:33:28.843 -04:00 [ERR] LoadCommand failed TID:1 Mem:151559472 Refit.ApiException: Response status code does not indicate success: 401 (Unauthorized). at Refit.RequestBuilderImplementation.<>c__DisplayClass14_0`2.<<BuildCancellableTaskFuncForMethod>b__0>d.MoveNext() in /_/Refit/RequestBuilderImplementation.cs:line 267 --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult() a.<>c__DisplayClass27_0.<<>b__0>d.MoveNext() 20211008 07:33:29.148 -04:00 [ERR] LoadCommand failed TID:1 Mem:151313920 Refit.ApiException: Response status code does not indicate success: 401 (Unauthorized). at Refit.RequestBuilderImplementation.<>c__DisplayClass14_0`2.<<BuildCancellableTaskFuncForMethod>b__0>d.MoveNext() in /_/Refit/RequestBuilderImplementation.cs:line 267 --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at >c__DisplayClass27_0.<<GetLocationsBySearch>b__0>d.MoveNext() 20211008 07:33:30.729 -04:00 [DBG] Lo False TID:1 Mem:151251616 20211008 07:33:30.729 -04:00 [DBG] HomeIsSelected : True TID:1 Mem:151251616 20211008 07:33:30.781 -04:00 [INF] { 12:00:00 AM, 11008 07:33:30.784 -04:00 [DBG] GetCache Start for location date 1166 TID:1 Mem:156359088 20211008 07:33:30.849 -04:00 [DBG] GetCache End for location date 1166 TID:26 Mem:164452952 20211008 07:33:30.905 -04:00 [ERR] Dispatcher_UnhandledException - TID:1 Mem:167274128 ReactiveUI.UnhandledErrorException: An object implementing IHandleObservableErrors (often a ReactiveCommand or ObservableAsPropertyHelper) has errored, thereby breaking its observable pipeline. To prevent this, ensure the pipeline does not error, or Subscribe to the ThrownExceptions property of the object in question to handle the erroneous case. ---> Refit.ApiException: Response status code does not indicate success: 401 (Unauthorized). at Refit.RequestBuilderImplementation.<>c__DisplayClass14_0`2.<<BuildCancellableTaskFuncForMethod>b__0>d.MoveNext() in /_/Refit/RequestBuilderImplementation.cs:line 267 --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult(d__19.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult() Get>b__95_0>d.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Reactive.ExceptionHelpers.ThrowIfNotNull(Exception exception) in /_/Rx.NET/Source/src/System.Reactive/Internal/ExceptionServices.cs:line 22 at System.Reactive.Subjects.AsyncSubject`1.GetResult() in /_/Rx.NET/Source/src/System.Reactive/Subjects/AsyncSubject.cs:line 439 at l.<<-ctor>b__52_9>d.MoveNext() --- End of inner exception stack trace --- at ReactiveUI.RxApp.<>c__DisplayClass10_0.<.cctor>b__2() in D:\a\1\s\src\ReactiveUI\RxApp.cs:line 106 at System.Reactive.Concurrency.Scheduler.Invoke(IScheduler scheduler, Action action) in /_/Rx.NET/Source/src/System.Reactive/Concurrency/Scheduler.Simple.cs:line 253 at System.Reactive.Concurrency.DispatcherScheduler.<>c__DisplayClass12_0`1.<Schedule>b__0() in /_/Rx.NET/Source/src/System.Reactive/Platforms/Desktop/Concurrency/DispatcherScheduler.cs:line 98 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) 20211008 07:33:33.124 -04:00 [FTL] Dispatcher_UnhandledException - App Crash, Memory Available 59 %, Process Memory Used 583131136 TID:1 Mem:165303056

1 Reply

@rodsan724 

 

Your posting here at techcommunity has had (as I write this) 60 views and no replies. I think it's reasonable to assume that it's because you've overwhelmed everybody with not enough information but a lot of static [is that long string of text at the end of your post the content you get back from the query? I assume so]

 

Anyway, some questions for you: what kind of database query is this? What's different about those queries that DO work? Or the records of the queries that do work? If we're going to find the cause of this apparent discrepancy, we need to be looking for distinctions of kind in various aspects of the database, its records, the fields that you're using to retrieve the records, etc.

 

When you say you "have a database query with just a few fields" are you saying that there are:

  • just a few fields being used as criteria?
  • just a few fields in each record?
  • just a few records?
  • something else?

 

Have you had similar queries from similar databases in the past (perhaps even prior instances of the same database, just earlier versions) where you did not experience this anomaly? What is different this time?

 

Those are just for starters: if there's anything else you can say that might help get a more complete picture? One last question: is it at all possible for you to post a copy of the actual spreadsheet/workbook? Images are frankly of limited utility in the diagnostic process.