2026-06-09 12:42:11 | Log4Net | Error in getArchivedmaterialsbyprofileid: Response status code does not indicate success: BadRequest (400); Substatus: 0; ActivityId: 5ee4bc6a-b1c3-40e2-8554-76942122d946; Reason: ({"code":"BadRequest","message":"{\"errors\":[{\"severity\":\"Error\",\"location\":{\"start\":153,\"end\":154},\"code\":\"SC1001\",\"message\":\"Syntax error, incorrect syntax near 'A'.\"}]}\r\nActivityId: 5ee4bc6a-b1c3-40e2-8554-76942122d946, 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: 5ee4bc6a-b1c3-40e2-8554-76942122d946; Reason: ({"code":"BadRequest","message":"{\"errors\":[{\"severity\":\"Error\",\"location\":{\"start\":153,\"end\":154},\"code\":\"SC1001\",\"message\":\"Syntax error, incorrect syntax near 'A'.\"}]}\r\nActivityId: 5ee4bc6a-b1c3-40e2-8554-76942122d946, 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-06-09T12:42:11.895Z","duration in milliseconds":56.957800000000006,"data":{"Client Configuration":{"Client Created Time Utc":"2026-06-09T12:42:11.8950031Z","MachineId":"hashedMachineName:892ad787-e8c1-2862-849d-c1fe1be1b415","NumberOfClientsCreated":10334,"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":"4efafdd7-7f3c-4de9-b5ed-1145bf3be86e"},"children":[{"name":"Create Query Pipeline","duration in milliseconds":55.368700000000004,"children":[{"name":"Get Container Properties","duration in milliseconds":31.2953,"children":[{"name":"Get Collection Cache","duration in milliseconds":15.4311,"children":[{"name":"Waiting for Initialization of client to complete","duration in milliseconds":15.4253}]},{"name":"Read Collection","duration in milliseconds":15.777000000000001,"data":{"Client Side Request Stats":{"Id":"AggregatedClientSideRequestStatistics","ContactedReplicas":[],"RegionsContacted":[],"FailedReplicas":[],"AddressResolutionStatistics":[],"StoreResponseStatistics":[],"HttpResponseStats":[{"StartTimeUTC":"2026-06-09T12:42:11.9105628Z","DurationInMs":15.6248,"RequestUri":"https://vitallog-eastus.documents.azure.com/dbs/vitallog/colls/ArchivedMaterialLog","ResourceType":"Collection","HttpMethod":"GET","ActivityId":"5fb4fd88-8808-454c-a072-e9f822cd833a","StatusCode":"OK"}]}}}]},{"name":"Parse Query","duration in milliseconds":4.6926000000000005},{"name":"Gateway QueryPlan","duration in milliseconds":0.3865},{"name":"Microsoft.Azure.Cosmos.Handlers.RequestInvokerHandler","duration in milliseconds":19.0045,"children":[{"name":"Microsoft.Azure.Cosmos.Handlers.DiagnosticsHandler","duration in milliseconds":18.922700000000003,"data":{"System Info":{"systemHistory":[{"dateUtc":"2026-06-09T12:41:15.5673321Z","cpu":4.134,"memory":5468164.000,"threadInfo":{"isThreadStarving":"False","threadWaitIntervalInMs":0.1144,"availableThreads":8190,"minThreads":2,"maxThreads":8191},"numberOfOpenTcpConnection":0},{"dateUtc":"2026-06-09T12:41:25.5826082Z","cpu":3.354,"memory":5463888.000,"threadInfo":{"isThreadStarving":"False","threadWaitIntervalInMs":0.1035,"availableThreads":8190,"minThreads":2,"maxThreads":8191},"numberOfOpenTcpConnection":0},{"dateUtc":"2026-06-09T12:41:35.5934987Z","cpu":3.666,"memory":5472188.000,"threadInfo":{"isThreadStarving":"False","threadWaitIntervalInMs":0.1156,"availableThreads":8190,"minThreads":2,"maxThreads":8191},"numberOfOpenTcpConnection":0},{"dateUtc":"2026-06-09T12:41:45.6078830Z","cpu":4.212,"memory":5471052.000,"threadInfo":{"isThreadStarving":"False","threadWaitIntervalInMs":0.094,"availableThreads":8190,"minThreads":2,"maxThreads":8191},"numberOfOpenTcpConnection":0},{"dateUtc":"2026-06-09T12:41:55.6159851Z","cpu":1.328,"memory":5470728.000,"threadInfo":{"isThreadStarving":"False","threadWaitIntervalInMs":0.0873,"availableThreads":8190,"minThreads":2,"maxThreads":8191},"numberOfOpenTcpConnection":0},{"dateUtc":"2026-06-09T12:42:05.6195243Z","cpu":1.872,"memory":5469176.000,"threadInfo":{"isThreadStarving":"False","threadWaitIntervalInMs":0.1108,"availableThreads":8190,"minThreads":2,"maxThreads":8191},"numberOfOpenTcpConnection":0}]}},"children":[{"name":"Microsoft.Azure.Cosmos.Handlers.TelemetryHandler","duration in milliseconds":18.9119,"children":[{"name":"Microsoft.Azure.Cosmos.Handlers.RetryHandler","duration in milliseconds":18.9071,"children":[{"name":"Microsoft.Azure.Cosmos.Handlers.RouterHandler","duration in milliseconds":6.4599,"children":[{"name":"Microsoft.Azure.Cosmos.Handlers.TransportHandler","duration in milliseconds":6.4574000000000007,"children":[{"name":"Microsoft.Azure.Cosmos.GatewayStoreModel Transport Request","duration in milliseconds":4.0452,"data":{"Client Side Request Stats":{"Id":"AggregatedClientSideRequestStatistics","ContactedReplicas":[],"RegionsContacted":[],"FailedReplicas":[],"AddressResolutionStatistics":[],"StoreResponseStatistics":[],"HttpResponseStats":[{"StartTimeUTC":"2026-06-09T12:42:11.9261876Z","DurationInMs":15.620700000000001,"RequestUri":"https://vitallog-eastus.documents.azure.com/dbs/vitallog/colls/ArchivedMaterialLog/docs","ResourceType":"Document","HttpMethod":"POST","ActivityId":"5ee4bc6a-b1c3-40e2-8554-76942122d946","StatusCode":"BadRequest","ReasonPhrase":"Bad Request"}]},"Point Operation Statistics":{"Id":"PointOperationStatistics","ActivityId":"5ee4bc6a-b1c3-40e2-8554-76942122d946","ResponseTimeUtc":"2026-06-09T12:42:11.9418083Z","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\\\":154},\\\"code\\\":\\\"SC1001\\\",\\\"message\\\":\\\"Syntax error, incorrect syntax near 'A'.\\\"}]}\\r\\nActivityId: 5ee4bc6a-b1c3-40e2-8554-76942122d946, 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.0363}]}