2026-05-08 15:09:52 | Log4Net | Error in recursiveQuery : 'Response status code does not indicate success: BadRequest (400); Substatus: 0; ActivityId: c024f6bc-44ba-4418-9983-decac2c70494; Reason: ({"code":"BadRequest","message":"{\"errors\":[{\"severity\":\"Error\",\"location\":{\"start\":522,\"end\":556},\"code\":\"SC1012\",\"message\":\"Syntax error, invalid string literal token '' ) order by materiallog._ts desc'.\"}]}\r\nActivityId: c024f6bc-44ba-4418-9983-decac2c70494, Windows/10.0.20348 cosmos-netstandard-sdk/3.18.0"}, Microsoft.Azure.Cosmos.Tracing.TraceData.ClientSideRequestStatisticsTraceDatum, Windows/10.0.20348 cosmos-netstandard-sdk/3.37.5);' Microsoft.Azure.Cosmos.CosmosException : Response status code does not indicate success: BadRequest (400); Substatus: 0; ActivityId: c024f6bc-44ba-4418-9983-decac2c70494; Reason: ({"code":"BadRequest","message":"{\"errors\":[{\"severity\":\"Error\",\"location\":{\"start\":522,\"end\":556},\"code\":\"SC1012\",\"message\":\"Syntax error, invalid string literal token '' ) order by materiallog._ts desc'.\"}]}\r\nActivityId: c024f6bc-44ba-4418-9983-decac2c70494, Windows/10.0.20348 cosmos-netstandard-sdk/3.18.0"}, Microsoft.Azure.Cosmos.Tracing.TraceData.ClientSideRequestStatisticsTraceDatum, Windows/10.0.20348 cosmos-netstandard-sdk/3.37.5); at Microsoft.Azure.Cosmos.GatewayStoreClient.d__9.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.Azure.Cosmos.GatewayStoreClient.d__5.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.Azure.Cosmos.GatewayStoreModel.d__9.MoveNext() --- End of stack trace from previous location where exception was thrown --- at Microsoft.Azure.Cosmos.GatewayStoreModel.d__9.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.Azure.Cosmos.Handlers.TransportHandler.d__3.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.Azure.Cosmos.Handlers.TransportHandler.d__2.MoveNext() --- Cosmos Diagnostics ---{"Summary":{"GatewayCalls":{"(200, 0)":1,"(400, 0)":1}},"name":"Typed FeedIterator ReadNextAsync","start datetime":"2026-05-08T15:09:52.078Z","duration in milliseconds":183.5036,"data":{"Client Configuration":{"Client Created Time Utc":"2026-05-08T15:09:52.0785683Z","MachineId":"hashedMachineName:891bcb9c-dbb6-0a57-9eb5-acd14c5c456b","NumberOfClientsCreated":6839,"NumberOfActiveClients":0,"ConnectionMode":"Direct","User Agent":"cosmos-netstandard-sdk/3.46.1|10|X86|Microsoft Windows 10.0.20348 |.NET Framework 4.8.9315.0|N|","ConnectionConfig":{"gw":"(cps:50, urto:6, p:False, httpf: False)","rntbd":"(cto: 5, icto: -1, mrpc: 30, mcpe: 65535, erd: True, pr: ReuseUnicastPort)","other":"(ed:False, be:False)"},"ConsistencyConfig":"(consistency: NotSet, prgns:[], apprgn: )","ProcessorCount":2},"Synchronization Context":"System.Web.AspNetSynchronizationContext","Query Correlated ActivityId":"49752af0-f511-4d89-8582-dc38f46936b9"},"children":[{"name":"Create Query Pipeline","duration in milliseconds":174.1836,"children":[{"name":"Get Container Properties","duration in milliseconds":111.15520000000001,"children":[{"name":"Get Collection Cache","duration in milliseconds":13.8139,"children":[{"name":"Waiting for Initialization of client to complete","duration in milliseconds":13.8106}]},{"name":"Read Collection","duration in milliseconds":97.2632,"data":{"Client Side Request Stats":{"Id":"AggregatedClientSideRequestStatistics","ContactedReplicas":[],"RegionsContacted":[],"FailedReplicas":[],"AddressResolutionStatistics":[],"StoreResponseStatistics":[],"HttpResponseStats":[{"StartTimeUTC":"2026-05-08T15:09:52.0941435Z","DurationInMs":93.8129,"RequestUri":"https://vitallog-eastus.documents.azure.com/dbs/vitallog/colls/materiallog","ResourceType":"Collection","HttpMethod":"GET","ActivityId":"f1c99e10-3c70-45a5-9e78-6a1ea44cbd99","StatusCode":"OK"}]}}}]},{"name":"Parse Query","duration in milliseconds":5.2838},{"name":"Gateway QueryPlan","duration in milliseconds":7.5443000000000007},{"name":"Microsoft.Azure.Cosmos.Handlers.RequestInvokerHandler","duration in milliseconds":47.8613,"children":[{"name":"Microsoft.Azure.Cosmos.Handlers.DiagnosticsHandler","duration in milliseconds":46.8889,"data":{"System Info":{"systemHistory":[{"dateUtc":"2026-05-08T15:08:55.4152148Z","cpu":26.443,"memory":5118252.000,"threadInfo":{"isThreadStarving":"False","threadWaitIntervalInMs":0.1765,"availableThreads":8190,"minThreads":2,"maxThreads":8191},"numberOfOpenTcpConnection":0},{"dateUtc":"2026-05-08T15:09:05.4158402Z","cpu":3.750,"memory":5116300.000,"threadInfo":{"isThreadStarving":"False","threadWaitIntervalInMs":0.1346,"availableThreads":8190,"minThreads":2,"maxThreads":8191},"numberOfOpenTcpConnection":0},{"dateUtc":"2026-05-08T15:09:15.4202428Z","cpu":6.552,"memory":5089228.000,"threadInfo":{"isThreadStarving":"False","threadWaitIntervalInMs":0.1976,"availableThreads":8190,"minThreads":2,"maxThreads":8191},"numberOfOpenTcpConnection":0},{"dateUtc":"2026-05-08T15:09:25.4324189Z","cpu":31.719,"memory":5158684.000,"threadInfo":{"isThreadStarving":"False","threadWaitIntervalInMs":0.2678,"availableThreads":8190,"minThreads":2,"maxThreads":8191},"numberOfOpenTcpConnection":0},{"dateUtc":"2026-05-08T15:09:35.4364831Z","cpu":58.424,"memory":4956088.000,"threadInfo":{"isThreadStarving":"False","threadWaitIntervalInMs":0.1608,"availableThreads":8190,"minThreads":2,"maxThreads":8191},"numberOfOpenTcpConnection":0},{"dateUtc":"2026-05-08T15:09:45.4678917Z","cpu":56.620,"memory":5179092.000,"threadInfo":{"isThreadStarving":"False","threadWaitIntervalInMs":0.2318,"availableThreads":8190,"minThreads":2,"maxThreads":8191},"numberOfOpenTcpConnection":0}]}},"children":[{"name":"Microsoft.Azure.Cosmos.Handlers.TelemetryHandler","duration in milliseconds":46.8765,"children":[{"name":"Microsoft.Azure.Cosmos.Handlers.RetryHandler","duration in milliseconds":46.8724,"children":[{"name":"Microsoft.Azure.Cosmos.Handlers.RouterHandler","duration in milliseconds":28.4618,"children":[{"name":"Microsoft.Azure.Cosmos.Handlers.TransportHandler","duration in milliseconds":28.459400000000002,"children":[{"name":"Microsoft.Azure.Cosmos.GatewayStoreModel Transport Request","duration in milliseconds":18.2649,"data":{"Client Side Request Stats":{"Id":"AggregatedClientSideRequestStatistics","ContactedReplicas":[],"RegionsContacted":[],"FailedReplicas":[],"AddressResolutionStatistics":[],"StoreResponseStatistics":[],"HttpResponseStats":[{"StartTimeUTC":"2026-05-08T15:09:52.2035200Z","DurationInMs":0,"RequestUri":"https://vitallog-eastus.documents.azure.com/dbs/vitallog/colls/materiallog/docs","ResourceType":"Document","HttpMethod":"POST","ActivityId":"c024f6bc-44ba-4418-9983-decac2c70494","StatusCode":"BadRequest","ReasonPhrase":"Bad Request"}]},"Point Operation Statistics":{"Id":"PointOperationStatistics","ActivityId":"c024f6bc-44ba-4418-9983-decac2c70494","ResponseTimeUtc":"2026-05-08T15:09:52.2347700Z","StatusCode":400,"SubStatusCode":0,"RequestCharge":0,"RequestUri":"dbs/vitallog/colls/materiallog","ErrorMessage":"Microsoft.Azure.Documents.DocumentClientException: {\"code\":\"BadRequest\",\"message\":\"{\\\"errors\\\":[{\\\"severity\\\":\\\"Error\\\",\\\"location\\\":{\\\"start\\\":522,\\\"end\\\":556},\\\"code\\\":\\\"SC1012\\\",\\\"message\\\":\\\"Syntax error, invalid string literal token '' ) order by materiallog._ts desc'.\\\"}]}\\r\\nActivityId: c024f6bc-44ba-4418-9983-decac2c70494, Windows/10.0.20348 cosmos-netstandard-sdk/3.18.0\"}, Microsoft.Azure.Cosmos.Tracing.TraceData.ClientSideRequestStatisticsTraceDatum, Windows/10.0.20348 cosmos-netstandard-sdk/3.37.5\r\n at Microsoft.Azure.Cosmos.GatewayStoreClient.d__9.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at Microsoft.Azure.Cosmos.GatewayStoreClient.d__5.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at Microsoft.Azure.Cosmos.GatewayStoreModel.d__9.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at Microsoft.Azure.Cosmos.GatewayStoreModel.d__9.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at Microsoft.Azure.Cosmos.Handlers.TransportHandler.d__3.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at Microsoft.Azure.Cosmos.Handlers.TransportHandler.d__2.MoveNext()","RequestSessionToken":null,"ResponseSessionToken":null,"BELatencyInMs":null}}}]}]}]}]}]}]}]},{"name":"Query Response Serialization","duration in milliseconds":0.184}]}