2025-12-21 18:23:42 | Log4Net | Error in getArchivedmaterialsbyprofileid: Response status code does not indicate success: BadRequest (400); Substatus: 0; ActivityId: 9d4e47d2-b588-4eb5-9ef3-c56e6fb96592; Reason: ({"code":"BadRequest","message":"{\"errors\":[{\"severity\":\"Error\",\"location\":{\"start\":153,\"end\":154},\"code\":\"SC1001\",\"message\":\"Syntax error, incorrect syntax near 'B'.\"}]}\r\nActivityId: 9d4e47d2-b588-4eb5-9ef3-c56e6fb96592, 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: 9d4e47d2-b588-4eb5-9ef3-c56e6fb96592; Reason: ({"code":"BadRequest","message":"{\"errors\":[{\"severity\":\"Error\",\"location\":{\"start\":153,\"end\":154},\"code\":\"SC1001\",\"message\":\"Syntax error, incorrect syntax near 'B'.\"}]}\r\nActivityId: 9d4e47d2-b588-4eb5-9ef3-c56e6fb96592, 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":"2025-12-21T18:23:41.945Z","duration in milliseconds":110.7711,"data":{"Client Configuration":{"Client Created Time Utc":"2025-12-21T18:23:41.9454725Z","MachineId":"hashedMachineName:ad1ef921-d161-42eb-9d95-9bba1990a59e","NumberOfClientsCreated":236,"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":4},"Synchronization Context":"System.Web.AspNetSynchronizationContext","Query Correlated ActivityId":"dd71684a-5ec0-4bb4-af6b-b8857a246c6f"},"children":[{"name":"Create Query Pipeline","duration in milliseconds":100.17020000000001,"children":[{"name":"Get Container Properties","duration in milliseconds":36.4209,"children":[{"name":"Get Collection Cache","duration in milliseconds":16.9315,"children":[{"name":"Waiting for Initialization of client to complete","duration in milliseconds":16.928900000000002}]},{"name":"Read Collection","duration in milliseconds":19.382,"data":{"Client Side Request Stats":{"Id":"AggregatedClientSideRequestStatistics","ContactedReplicas":[],"RegionsContacted":[],"FailedReplicas":[],"AddressResolutionStatistics":[],"StoreResponseStatistics":[],"HttpResponseStats":[{"StartTimeUTC":"2025-12-21T18:23:41.9610974Z","DurationInMs":31.3197,"RequestUri":"https://vitallog-eastus.documents.azure.com/dbs/vitallog/colls/ArchivedMaterialLog","ResourceType":"Collection","HttpMethod":"GET","ActivityId":"5ad45ad3-f8b4-43ff-a7ce-b3e4ba9ba7ce","StatusCode":"OK"}]}}}]},{"name":"Parse Query","duration in milliseconds":6.6685000000000008},{"name":"Gateway QueryPlan","duration in milliseconds":0.4466},{"name":"Microsoft.Azure.Cosmos.Handlers.RequestInvokerHandler","duration in milliseconds":55.4718,"children":[{"name":"Microsoft.Azure.Cosmos.Handlers.DiagnosticsHandler","duration in milliseconds":55.377,"data":{"System Info":{"systemHistory":[{"dateUtc":"2025-12-21T18:22:43.9334877Z","cpu":1.248,"memory":13266772.000,"threadInfo":{"isThreadStarving":"False","threadWaitIntervalInMs":0.1368,"availableThreads":8190,"minThreads":4,"maxThreads":8191},"numberOfOpenTcpConnection":0},{"dateUtc":"2025-12-21T18:22:53.9493384Z","cpu":3.861,"memory":12706444.000,"threadInfo":{"isThreadStarving":"False","threadWaitIntervalInMs":0.1222,"availableThreads":8190,"minThreads":4,"maxThreads":8191},"numberOfOpenTcpConnection":0},{"dateUtc":"2025-12-21T18:23:03.9651807Z","cpu":4.407,"memory":13058100.000,"threadInfo":{"isThreadStarving":"False","threadWaitIntervalInMs":0.1282,"availableThreads":8190,"minThreads":4,"maxThreads":8191},"numberOfOpenTcpConnection":0},{"dateUtc":"2025-12-21T18:23:13.9809359Z","cpu":2.808,"memory":13176568.000,"threadInfo":{"isThreadStarving":"False","threadWaitIntervalInMs":0.136,"availableThreads":8190,"minThreads":4,"maxThreads":8191},"numberOfOpenTcpConnection":0},{"dateUtc":"2025-12-21T18:23:23.9967490Z","cpu":1.014,"memory":13245280.000,"threadInfo":{"isThreadStarving":"False","threadWaitIntervalInMs":0.1308,"availableThreads":8190,"minThreads":4,"maxThreads":8191},"numberOfOpenTcpConnection":0},{"dateUtc":"2025-12-21T18:23:34.0125809Z","cpu":0.624,"memory":13248244.000,"threadInfo":{"isThreadStarving":"False","threadWaitIntervalInMs":0.1339,"availableThreads":8190,"minThreads":4,"maxThreads":8191},"numberOfOpenTcpConnection":0}]}},"children":[{"name":"Microsoft.Azure.Cosmos.Handlers.TelemetryHandler","duration in milliseconds":55.3585,"children":[{"name":"Microsoft.Azure.Cosmos.Handlers.RetryHandler","duration in milliseconds":55.354600000000005,"children":[{"name":"Microsoft.Azure.Cosmos.Handlers.RouterHandler","duration in milliseconds":35.437200000000004,"children":[{"name":"Microsoft.Azure.Cosmos.Handlers.TransportHandler","duration in milliseconds":35.4321,"children":[{"name":"Microsoft.Azure.Cosmos.GatewayStoreModel Transport Request","duration in milliseconds":23.9825,"data":{"Client Side Request Stats":{"Id":"AggregatedClientSideRequestStatistics","ContactedReplicas":[],"RegionsContacted":[],"FailedReplicas":[],"AddressResolutionStatistics":[],"StoreResponseStatistics":[],"HttpResponseStats":[{"StartTimeUTC":"2025-12-21T18:23:41.9924171Z","DurationInMs":15.655000000000001,"RequestUri":"https://vitallog-eastus.documents.azure.com/dbs/vitallog/colls/ArchivedMaterialLog/docs","ResourceType":"Document","HttpMethod":"POST","ActivityId":"9d4e47d2-b588-4eb5-9ef3-c56e6fb96592","StatusCode":"BadRequest","ReasonPhrase":"Bad Request"}]},"Point Operation Statistics":{"Id":"PointOperationStatistics","ActivityId":"9d4e47d2-b588-4eb5-9ef3-c56e6fb96592","ResponseTimeUtc":"2025-12-21T18:23:42.0237492Z","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 'B'.\\\"}]}\\r\\nActivityId: 9d4e47d2-b588-4eb5-9ef3-c56e6fb96592, 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.2227}]}