2026-07-16 11:42:17 | Log4Net | Error in getArchivedmaterialsbyprofileid: Response status code does not indicate success: BadRequest (400); Substatus: 0; ActivityId: fd74f6ea-6a85-4c39-9e99-ce689a67c815; Reason: ({"code":"BadRequest","message":"{\"errors\":[{\"severity\":\"Error\",\"location\":{\"start\":153,\"end\":200},\"code\":\"SC1001\",\"message\":\"Syntax error, incorrect syntax near '' and ArchivedMaterialLog.DiscardedState != ''.\"}]}\r\nActivityId: fd74f6ea-6a85-4c39-9e99-ce689a67c815, 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: fd74f6ea-6a85-4c39-9e99-ce689a67c815; Reason: ({"code":"BadRequest","message":"{\"errors\":[{\"severity\":\"Error\",\"location\":{\"start\":153,\"end\":200},\"code\":\"SC1001\",\"message\":\"Syntax error, incorrect syntax near '' and ArchivedMaterialLog.DiscardedState != ''.\"}]}\r\nActivityId: fd74f6ea-6a85-4c39-9e99-ce689a67c815, 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-16T11:42:17.004Z","duration in milliseconds":99.173700000000011,"data":{"Client Configuration":{"Client Created Time Utc":"2026-07-16T11:42:17.0049157Z","MachineId":"hashedMachineName:c6f2c64c-bdba-1236-10b6-e2ed98b34463","NumberOfClientsCreated":12464,"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":"18eca053-073a-45a7-bb4f-285c4382d551"},"children":[{"name":"Create Query Pipeline","duration in milliseconds":90.385500000000008,"children":[{"name":"Get Container Properties","duration in milliseconds":47.9409,"children":[{"name":"Get Collection Cache","duration in milliseconds":11.215,"children":[{"name":"Waiting for Initialization of client to complete","duration in milliseconds":11.2126}]},{"name":"Read Collection","duration in milliseconds":36.670500000000004,"data":{"Client Side Request Stats":{"Id":"AggregatedClientSideRequestStatistics","ContactedReplicas":[],"RegionsContacted":[],"FailedReplicas":[],"AddressResolutionStatistics":[],"StoreResponseStatistics":[],"HttpResponseStats":[{"StartTimeUTC":"2026-07-16T11:42:17.0049157Z","DurationInMs":46.8804,"RequestUri":"https://vitallog-eastus.documents.azure.com/dbs/vitallog/colls/ArchivedMaterialLog","ResourceType":"Collection","HttpMethod":"GET","ActivityId":"5dbee007-92e3-46c4-be2d-61f8c163f2e3","StatusCode":"OK"}]}}}]},{"name":"Parse Query","duration in milliseconds":5.7827},{"name":"Gateway QueryPlan","duration in milliseconds":0.2802},{"name":"Microsoft.Azure.Cosmos.Handlers.RequestInvokerHandler","duration in milliseconds":35.4778,"children":[{"name":"Microsoft.Azure.Cosmos.Handlers.DiagnosticsHandler","duration in milliseconds":35.4272,"data":{"System Info":{"systemHistory":[{"dateUtc":"2026-07-16T11:41:23.6815532Z","cpu":2.031,"memory":5630044.000,"threadInfo":{"isThreadStarving":"False","threadWaitIntervalInMs":0.0557,"availableThreads":8190,"minThreads":2,"maxThreads":8191},"numberOfOpenTcpConnection":0},{"dateUtc":"2026-07-16T11:41:33.6935063Z","cpu":2.500,"memory":5622108.000,"threadInfo":{"isThreadStarving":"False","threadWaitIntervalInMs":0.0809,"availableThreads":8190,"minThreads":2,"maxThreads":8191},"numberOfOpenTcpConnection":0},{"dateUtc":"2026-07-16T11:41:43.7085774Z","cpu":1.716,"memory":5636516.000,"threadInfo":{"isThreadStarving":"False","threadWaitIntervalInMs":0.0755,"availableThreads":8190,"minThreads":2,"maxThreads":8191},"numberOfOpenTcpConnection":0},{"dateUtc":"2026-07-16T11:41:53.7222004Z","cpu":2.262,"memory":5634044.000,"threadInfo":{"isThreadStarving":"False","threadWaitIntervalInMs":0.0554,"availableThreads":8190,"minThreads":2,"maxThreads":8191},"numberOfOpenTcpConnection":0},{"dateUtc":"2026-07-16T11:42:03.7243405Z","cpu":3.828,"memory":5676248.000,"threadInfo":{"isThreadStarving":"False","threadWaitIntervalInMs":0.0688,"availableThreads":8190,"minThreads":2,"maxThreads":8191},"numberOfOpenTcpConnection":0},{"dateUtc":"2026-07-16T11:42:13.7392607Z","cpu":3.978,"memory":5670276.000,"threadInfo":{"isThreadStarving":"False","threadWaitIntervalInMs":0.0683,"availableThreads":8190,"minThreads":2,"maxThreads":8191},"numberOfOpenTcpConnection":0}]}},"children":[{"name":"Microsoft.Azure.Cosmos.Handlers.TelemetryHandler","duration in milliseconds":35.4179,"children":[{"name":"Microsoft.Azure.Cosmos.Handlers.RetryHandler","duration in milliseconds":35.4151,"children":[{"name":"Microsoft.Azure.Cosmos.Handlers.RouterHandler","duration in milliseconds":19.4433,"children":[{"name":"Microsoft.Azure.Cosmos.Handlers.TransportHandler","duration in milliseconds":19.441000000000003,"children":[{"name":"Microsoft.Azure.Cosmos.GatewayStoreModel Transport Request","duration in milliseconds":12.982600000000002,"data":{"Client Side Request Stats":{"Id":"AggregatedClientSideRequestStatistics","ContactedReplicas":[],"RegionsContacted":[],"FailedReplicas":[],"AddressResolutionStatistics":[],"StoreResponseStatistics":[],"HttpResponseStats":[{"StartTimeUTC":"2026-07-16T11:42:17.0517961Z","DurationInMs":0,"RequestUri":"https://vitallog-eastus.documents.azure.com/dbs/vitallog/colls/ArchivedMaterialLog/docs","ResourceType":"Document","HttpMethod":"POST","ActivityId":"fd74f6ea-6a85-4c39-9e99-ce689a67c815","StatusCode":"BadRequest","ReasonPhrase":"Bad Request"}]},"Point Operation Statistics":{"Id":"PointOperationStatistics","ActivityId":"fd74f6ea-6a85-4c39-9e99-ce689a67c815","ResponseTimeUtc":"2026-07-16T11:42:17.0674241Z","StatusCode":400,"SubStatusCode":0,"RequestCharge":0,"RequestUri":"dbs/vitallog/colls/ArchivedMaterialLog","ErrorMessage":"Microsoft.Azure.Documents.DocumentClientException: {\"code\":\"BadRequest\",\"message\":\"{\\\"errors\\\":[{\\\"severity\\\":\\\"Error\\\",\\\"location\\\":{\\\"start\\\":153,\\\"end\\\":200},\\\"code\\\":\\\"SC1001\\\",\\\"message\\\":\\\"Syntax error, incorrect syntax near '' and ArchivedMaterialLog.DiscardedState != ''.\\\"}]}\\r\\nActivityId: fd74f6ea-6a85-4c39-9e99-ce689a67c815, 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.171}]}