2026-09-08 12:01:18 | Log4Net | Error in getArchivedmaterialsbyprofileid: Response status code does not indicate success: BadRequest (400); Substatus: 0; ActivityId: 66ff3ed1-5044-46d3-ab54-10455b22c3e8; 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: 66ff3ed1-5044-46d3-ab54-10455b22c3e8, 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: 66ff3ed1-5044-46d3-ab54-10455b22c3e8; 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: 66ff3ed1-5044-46d3-ab54-10455b22c3e8, 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-09-08T12:01:18.254Z","duration in milliseconds":39.8566,"data":{"Client Configuration":{"Client Created Time Utc":"2026-09-08T12:01:18.2541770Z","MachineId":"hashedMachineName:1e8ed7d7-9f87-1f2d-ac4c-c40273ddea1f","NumberOfClientsCreated":34847,"NumberOfActiveClients":0,"ConnectionMode":"Direct","User Agent":"cosmos-netstandard-sdk/3.46.1|10|X86|Microsoft Windows 10.0.20348 |.NET Framework 4.8.9339.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":"bc949e07-17c7-499f-bb0b-572a25fab004"},"children":[{"name":"Create Query Pipeline","duration in milliseconds":38.207100000000004,"children":[{"name":"Get Container Properties","duration in milliseconds":28.618000000000002,"children":[{"name":"Get Collection Cache","duration in milliseconds":10.520800000000001,"children":[{"name":"Waiting for Initialization of client to complete","duration in milliseconds":10.5183}]},{"name":"Read Collection","duration in milliseconds":18.0409,"data":{"Client Side Request Stats":{"Id":"AggregatedClientSideRequestStatistics","ContactedReplicas":[],"RegionsContacted":[],"FailedReplicas":[],"AddressResolutionStatistics":[],"StoreResponseStatistics":[],"HttpResponseStats":[{"StartTimeUTC":"2026-09-08T12:01:18.2697990Z","DurationInMs":15.626800000000001,"RequestUri":"https://vitallog-eastus.documents.azure.com/dbs/vitallog/colls/ArchivedMaterialLog","ResourceType":"Collection","HttpMethod":"GET","ActivityId":"8924fb02-4341-43cd-9d34-2402e25b0453","StatusCode":"OK"}]}}}]},{"name":"Parse Query","duration in milliseconds":3.5723000000000003},{"name":"Gateway QueryPlan","duration in milliseconds":0.26380000000000003},{"name":"Microsoft.Azure.Cosmos.Handlers.RequestInvokerHandler","duration in milliseconds":5.7456000000000005,"children":[{"name":"Microsoft.Azure.Cosmos.Handlers.DiagnosticsHandler","duration in milliseconds":5.7012,"data":{"System Info":{"systemHistory":[{"dateUtc":"2026-09-08T12:00:23.1499758Z","cpu":0.547,"memory":5623824.000,"threadInfo":{"isThreadStarving":"False","threadWaitIntervalInMs":0.0673,"availableThreads":8190,"minThreads":2,"maxThreads":8191},"numberOfOpenTcpConnection":0},{"dateUtc":"2026-09-08T12:00:33.1522807Z","cpu":0.703,"memory":5619380.000,"threadInfo":{"isThreadStarving":"False","threadWaitIntervalInMs":0.0616,"availableThreads":8190,"minThreads":2,"maxThreads":8191},"numberOfOpenTcpConnection":0},{"dateUtc":"2026-09-08T12:00:43.1658053Z","cpu":3.042,"memory":5624236.000,"threadInfo":{"isThreadStarving":"False","threadWaitIntervalInMs":0.0484,"availableThreads":8190,"minThreads":2,"maxThreads":8191},"numberOfOpenTcpConnection":0},{"dateUtc":"2026-09-08T12:00:53.1684550Z","cpu":3.203,"memory":5600288.000,"threadInfo":{"isThreadStarving":"False","threadWaitIntervalInMs":0.0783,"availableThreads":8190,"minThreads":2,"maxThreads":8191},"numberOfOpenTcpConnection":0},{"dateUtc":"2026-09-08T12:01:03.1814606Z","cpu":2.418,"memory":5600504.000,"threadInfo":{"isThreadStarving":"False","threadWaitIntervalInMs":0.076,"availableThreads":8190,"minThreads":2,"maxThreads":8191},"numberOfOpenTcpConnection":0},{"dateUtc":"2026-09-08T12:01:13.1866794Z","cpu":2.734,"memory":5607420.000,"threadInfo":{"isThreadStarving":"False","threadWaitIntervalInMs":0.0644,"availableThreads":8190,"minThreads":2,"maxThreads":8191},"numberOfOpenTcpConnection":0}]}},"children":[{"name":"Microsoft.Azure.Cosmos.Handlers.TelemetryHandler","duration in milliseconds":5.6957,"children":[{"name":"Microsoft.Azure.Cosmos.Handlers.RetryHandler","duration in milliseconds":5.6928,"children":[{"name":"Microsoft.Azure.Cosmos.Handlers.RouterHandler","duration in milliseconds":4.753,"children":[{"name":"Microsoft.Azure.Cosmos.Handlers.TransportHandler","duration in milliseconds":4.7511,"children":[{"name":"Microsoft.Azure.Cosmos.GatewayStoreModel Transport Request","duration in milliseconds":2.7920000000000003,"data":{"Client Side Request Stats":{"Id":"AggregatedClientSideRequestStatistics","ContactedReplicas":[],"RegionsContacted":[],"FailedReplicas":[],"AddressResolutionStatistics":[],"StoreResponseStatistics":[],"HttpResponseStats":[{"StartTimeUTC":"2026-09-08T12:01:18.2854258Z","DurationInMs":15.625300000000001,"RequestUri":"https://vitallog-eastus.documents.azure.com/dbs/vitallog/colls/ArchivedMaterialLog/docs","ResourceType":"Document","HttpMethod":"POST","ActivityId":"66ff3ed1-5044-46d3-ab54-10455b22c3e8","StatusCode":"BadRequest","ReasonPhrase":"Bad Request"}]},"Point Operation Statistics":{"Id":"PointOperationStatistics","ActivityId":"66ff3ed1-5044-46d3-ab54-10455b22c3e8","ResponseTimeUtc":"2026-09-08T12:01:18.3010511Z","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: 66ff3ed1-5044-46d3-ab54-10455b22c3e8, 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.034}]}