2026-07-14 13:50:51 | Log4Net | Error in recursiveQuery : 'Response status code does not indicate success: BadRequest (400); Substatus: 0; ActivityId: 338453af-19b0-4d18-a64b-13ed86d47318; 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: 338453af-19b0-4d18-a64b-13ed86d47318, 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: 338453af-19b0-4d18-a64b-13ed86d47318; 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: 338453af-19b0-4d18-a64b-13ed86d47318, 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-07-14T13:50:51.262Z","duration in milliseconds":287.5231,"data":{"Client Configuration":{"Client Created Time Utc":"2026-07-14T13:50:51.2628323Z","MachineId":"hashedMachineName:892ad787-e8c1-2862-849d-c1fe1be1b415","NumberOfClientsCreated":15998,"NumberOfActiveClients":0,"ConnectionMode":"Direct","User Agent":"cosmos-netstandard-sdk/3.46.1|10|X86|Microsoft Windows 10.0.20348 |.NET Framework 4.8.9332.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":"326d1f1c-75ea-46c7-b7b2-45d4be18b353"},"children":[{"name":"Create Query Pipeline","duration in milliseconds":267.2115,"children":[{"name":"Get Container Properties","duration in milliseconds":46.2663,"children":[{"name":"Get Collection Cache","duration in milliseconds":22.299300000000002,"children":[{"name":"Waiting for Initialization of client to complete","duration in milliseconds":22.2952}]},{"name":"Read Collection","duration in milliseconds":23.5272,"data":{"Client Side Request Stats":{"Id":"AggregatedClientSideRequestStatistics","ContactedReplicas":[],"RegionsContacted":[],"FailedReplicas":[],"AddressResolutionStatistics":[],"StoreResponseStatistics":[],"HttpResponseStats":[{"StartTimeUTC":"2026-07-14T13:50:51.2940842Z","DurationInMs":15.622800000000002,"RequestUri":"https://vitallog-eastus.documents.azure.com/dbs/vitallog/colls/materiallog","ResourceType":"Collection","HttpMethod":"GET","ActivityId":"167459a6-61d5-422a-ac61-5819a4e18f93","StatusCode":"OK"}]}}}]},{"name":"Parse Query","duration in milliseconds":46.7884},{"name":"Gateway QueryPlan","duration in milliseconds":34.6231},{"name":"Microsoft.Azure.Cosmos.Handlers.RequestInvokerHandler","duration in milliseconds":127.8511,"children":[{"name":"Microsoft.Azure.Cosmos.Handlers.DiagnosticsHandler","duration in milliseconds":122.31790000000001,"data":{"System Info":{"systemHistory":[{"dateUtc":"2026-07-14T13:49:58.5623026Z","cpu":3.516,"memory":5000280.000,"threadInfo":{"isThreadStarving":"False","threadWaitIntervalInMs":0.1446,"availableThreads":8190,"minThreads":2,"maxThreads":8191},"numberOfOpenTcpConnection":0},{"dateUtc":"2026-07-14T13:50:08.5649611Z","cpu":2.028,"memory":4994940.000,"threadInfo":{"isThreadStarving":"False","threadWaitIntervalInMs":0.0569,"availableThreads":8190,"minThreads":2,"maxThreads":8191},"numberOfOpenTcpConnection":0},{"dateUtc":"2026-07-14T13:50:18.5707980Z","cpu":2.891,"memory":4967500.000,"threadInfo":{"isThreadStarving":"False","threadWaitIntervalInMs":0.084,"availableThreads":8190,"minThreads":2,"maxThreads":8191},"numberOfOpenTcpConnection":0},{"dateUtc":"2026-07-14T13:50:28.5734521Z","cpu":1.563,"memory":4978240.000,"threadInfo":{"isThreadStarving":"False","threadWaitIntervalInMs":0.1095,"availableThreads":8190,"minThreads":2,"maxThreads":8191},"numberOfOpenTcpConnection":0},{"dateUtc":"2026-07-14T13:50:38.5751456Z","cpu":1.406,"memory":4978268.000,"threadInfo":{"isThreadStarving":"False","threadWaitIntervalInMs":0.0767,"availableThreads":8189,"minThreads":2,"maxThreads":8191},"numberOfOpenTcpConnection":0},{"dateUtc":"2026-07-14T13:50:48.5813412Z","cpu":0.936,"memory":4977980.000,"threadInfo":{"isThreadStarving":"False","threadWaitIntervalInMs":0.0379,"availableThreads":8190,"minThreads":2,"maxThreads":8191},"numberOfOpenTcpConnection":0}]}},"children":[{"name":"Microsoft.Azure.Cosmos.Handlers.TelemetryHandler","duration in milliseconds":122.305,"children":[{"name":"Microsoft.Azure.Cosmos.Handlers.RetryHandler","duration in milliseconds":122.30000000000001,"children":[{"name":"Microsoft.Azure.Cosmos.Handlers.RouterHandler","duration in milliseconds":101.775,"children":[{"name":"Microsoft.Azure.Cosmos.Handlers.TransportHandler","duration in milliseconds":101.77250000000001,"children":[{"name":"Microsoft.Azure.Cosmos.GatewayStoreModel Transport Request","duration in milliseconds":78.017800000000008,"data":{"Client Side Request Stats":{"Id":"AggregatedClientSideRequestStatistics","ContactedReplicas":[],"RegionsContacted":[],"FailedReplicas":[],"AddressResolutionStatistics":[],"StoreResponseStatistics":[],"HttpResponseStats":[{"StartTimeUTC":"2026-07-14T13:50:51.4347061Z","DurationInMs":0,"RequestUri":"https://vitallog-eastus.documents.azure.com/dbs/vitallog/colls/materiallog/docs","ResourceType":"Document","HttpMethod":"POST","ActivityId":"338453af-19b0-4d18-a64b-13ed86d47318","StatusCode":"BadRequest","ReasonPhrase":"Bad Request"}]},"Point Operation Statistics":{"Id":"PointOperationStatistics","ActivityId":"338453af-19b0-4d18-a64b-13ed86d47318","ResponseTimeUtc":"2026-07-14T13:50:51.5128360Z","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: 338453af-19b0-4d18-a64b-13ed86d47318, 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.3422}]}