2026-04-06 16:18:48 | Log4Net | Error in getArchivedmaterialsbyprofileid: Response status code does not indicate success: BadRequest (400); Substatus: 0; ActivityId: b23f9db0-3d20-4399-a24f-e4a539789e81; Reason: ({"code":"BadRequest","message":"{\"errors\":[{\"severity\":\"Error\",\"location\":{\"start\":144,\"end\":145},\"code\":\"SC1010\",\"message\":\"Syntax error, invalid token '!'.\"}]}\r\nActivityId: b23f9db0-3d20-4399-a24f-e4a539789e81, 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: b23f9db0-3d20-4399-a24f-e4a539789e81; Reason: ({"code":"BadRequest","message":"{\"errors\":[{\"severity\":\"Error\",\"location\":{\"start\":144,\"end\":145},\"code\":\"SC1010\",\"message\":\"Syntax error, invalid token '!'.\"}]}\r\nActivityId: b23f9db0-3d20-4399-a24f-e4a539789e81, 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-04-06T16:18:48.247Z","duration in milliseconds":130.9073,"data":{"Client Configuration":{"Client Created Time Utc":"2026-04-06T16:18:48.2479190Z","MachineId":"hashedMachineName:6e58dd45-9e7e-c021-0268-275960ac67c8","NumberOfClientsCreated":28018,"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":"bde30f18-dd70-4572-a044-0305c9c34858"},"children":[{"name":"Create Query Pipeline","duration in milliseconds":108.5655,"children":[{"name":"Get Container Properties","duration in milliseconds":35.4889,"children":[{"name":"Get Collection Cache","duration in milliseconds":15.2706,"children":[{"name":"Waiting for Initialization of client to complete","duration in milliseconds":15.2611}]},{"name":"Read Collection","duration in milliseconds":20.0501,"data":{"Client Side Request Stats":{"Id":"AggregatedClientSideRequestStatistics","ContactedReplicas":[],"RegionsContacted":[],"FailedReplicas":[],"AddressResolutionStatistics":[],"StoreResponseStatistics":[],"HttpResponseStats":[{"StartTimeUTC":"2026-04-06T16:18:48.2635403Z","DurationInMs":15.6233,"RequestUri":"https://vitallog-eastus.documents.azure.com/dbs/vitallog/colls/ArchivedMaterialLog","ResourceType":"Collection","HttpMethod":"GET","ActivityId":"b906ae27-dfd7-459f-9a39-41392aa115c2","StatusCode":"OK"}]}}}]},{"name":"Parse Query","duration in milliseconds":8.9781000000000013},{"name":"Gateway QueryPlan","duration in milliseconds":0.6497},{"name":"Microsoft.Azure.Cosmos.Handlers.RequestInvokerHandler","duration in milliseconds":61.1582,"children":[{"name":"Microsoft.Azure.Cosmos.Handlers.DiagnosticsHandler","duration in milliseconds":61.049200000000006,"data":{"System Info":{"systemHistory":[{"dateUtc":"2026-04-06T16:17:57.9023409Z","cpu":0.859,"memory":5308352.000,"threadInfo":{"isThreadStarving":"False","threadWaitIntervalInMs":0.2331,"availableThreads":8190,"minThreads":2,"maxThreads":8191},"numberOfOpenTcpConnection":0},{"dateUtc":"2026-04-06T16:18:07.9187720Z","cpu":0.624,"memory":5312748.000,"threadInfo":{"isThreadStarving":"False","threadWaitIntervalInMs":0.0933,"availableThreads":8190,"minThreads":2,"maxThreads":8191},"numberOfOpenTcpConnection":0},{"dateUtc":"2026-04-06T16:18:17.9211639Z","cpu":0.938,"memory":5312324.000,"threadInfo":{"isThreadStarving":"False","threadWaitIntervalInMs":0.2271,"availableThreads":8190,"minThreads":2,"maxThreads":8191},"numberOfOpenTcpConnection":0},{"dateUtc":"2026-04-06T16:18:27.9223248Z","cpu":9.844,"memory":5267044.000,"threadInfo":{"isThreadStarving":"False","threadWaitIntervalInMs":0.1045,"availableThreads":8190,"minThreads":2,"maxThreads":8191},"numberOfOpenTcpConnection":0},{"dateUtc":"2026-04-06T16:18:37.9373248Z","cpu":3.744,"memory":5250712.000,"threadInfo":{"isThreadStarving":"False","threadWaitIntervalInMs":0.1679,"availableThreads":8190,"minThreads":2,"maxThreads":8191},"numberOfOpenTcpConnection":0},{"dateUtc":"2026-04-06T16:18:47.9474202Z","cpu":3.042,"memory":5249552.000,"threadInfo":{"isThreadStarving":"False","threadWaitIntervalInMs":0.2815,"availableThreads":8190,"minThreads":2,"maxThreads":8191},"numberOfOpenTcpConnection":0}]}},"children":[{"name":"Microsoft.Azure.Cosmos.Handlers.TelemetryHandler","duration in milliseconds":61.0262,"children":[{"name":"Microsoft.Azure.Cosmos.Handlers.RetryHandler","duration in milliseconds":61.016000000000005,"children":[{"name":"Microsoft.Azure.Cosmos.Handlers.RouterHandler","duration in milliseconds":36.042500000000004,"children":[{"name":"Microsoft.Azure.Cosmos.Handlers.TransportHandler","duration in milliseconds":36.0369,"children":[{"name":"Microsoft.Azure.Cosmos.GatewayStoreModel Transport Request","duration in milliseconds":23.514100000000003,"data":{"Client Side Request Stats":{"Id":"AggregatedClientSideRequestStatistics","ContactedReplicas":[],"RegionsContacted":[],"FailedReplicas":[],"AddressResolutionStatistics":[],"StoreResponseStatistics":[],"HttpResponseStats":[{"StartTimeUTC":"2026-04-06T16:18:48.2947943Z","DurationInMs":0,"RequestUri":"https://vitallog-eastus.documents.azure.com/dbs/vitallog/colls/ArchivedMaterialLog/docs","ResourceType":"Document","HttpMethod":"POST","ActivityId":"b23f9db0-3d20-4399-a24f-e4a539789e81","StatusCode":"BadRequest","ReasonPhrase":"Bad Request"}]},"Point Operation Statistics":{"Id":"PointOperationStatistics","ActivityId":"b23f9db0-3d20-4399-a24f-e4a539789e81","ResponseTimeUtc":"2026-04-06T16:18:48.3260378Z","StatusCode":400,"SubStatusCode":0,"RequestCharge":0,"RequestUri":"dbs/vitallog/colls/ArchivedMaterialLog","ErrorMessage":"Microsoft.Azure.Documents.DocumentClientException: {\"code\":\"BadRequest\",\"message\":\"{\\\"errors\\\":[{\\\"severity\\\":\\\"Error\\\",\\\"location\\\":{\\\"start\\\":144,\\\"end\\\":145},\\\"code\\\":\\\"SC1010\\\",\\\"message\\\":\\\"Syntax error, invalid token '!'.\\\"}]}\\r\\nActivityId: b23f9db0-3d20-4399-a24f-e4a539789e81, 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.3855}]}