{"Timestamp":"2025-08-26T08:18:27.2747889+00:00","Level":"Information","SourceContext":"OQSHA.IoT.Data.Aggregator.Workers.MapMyIndiaDrivesDataAggregator","Data":{"EventId":3093711627},"Message":"Registering Background Task - Map My India Drives Data Aggregator"}

{"Timestamp":"2025-08-26T08:18:27.3206341+00:00","Level":"Error","SourceContext":"Microsoft.Extensions.Hosting.Internal.Host","Data":{"EventId":732972521},"Message":"Hosting failed to start","Exception":"System.FormatException: The input string '-15.84' was not in a correct format.\r\n   at System.Number.ThrowFormatException[TChar](ReadOnlySpan`1 value)\r\n   at System.Convert.ToInt32(String value)\r\n   at OQSHA.IoT.Data.Aggregator.Workers.MapMyIndiaDrivesDataAggregator.StartAsync(CancellationToken cancellationToken) in D:\\work\\incident-reporter-api\\IncidentReporter\\OQSHA.IoT.Data.Aggregator\\Workers\\MapMyIndiaDrivesDataAggregator.cs:line 24\r\n   at Microsoft.Extensions.Hosting.Internal.Host.<StartAsync>b__15_1(IHostedService service, CancellationToken token)\r\n   at Microsoft.Extensions.Hosting.Internal.Host.ForeachService[T](IEnumerable`1 services, CancellationToken token, Boolean concurrent, Boolean abortOnFirstException, List`1 exceptions, Func`3 operation)"}

{"Timestamp":"2025-08-26T08:19:53.2113083+00:00","Level":"Information","SourceContext":"OQSHA.IoT.Data.Aggregator.Workers.MapMyIndiaDrivesDataAggregator","Data":{"EventId":3093711627},"Message":"Registering Background Task - Map My India Drives Data Aggregator"}

{"Timestamp":"2025-08-26T08:19:53.2474426+00:00","Level":"Information","SourceContext":"OQSHA.IoT.Data.Aggregator.Workers.MapMyIndiaDrivesDataAggregator","Data":{"EventId":1240239631},"Message":"Registered Background Task - Map My India Drives Data Aggregator"}

{"Timestamp":"2025-08-26T08:19:53.2483283+00:00","Level":"Information","SourceContext":"Microsoft.Hosting.Lifetime","Data":{"EventId":3702455892},"Message":"Application started. Press Ctrl+C to shut down."}

{"Timestamp":"2025-08-26T08:19:53.2484319+00:00","Level":"Information","SourceContext":"OQSHA.IoT.Data.Aggregator.Workers.MapMyIndiaDrivesDataAggregator","Data":{"EventId":2351011130},"Message":"MMI_DRIVE_DATA_AGGREGATOR - Initiating the Map My India device's drives data aggregation"}

{"Timestamp":"2025-08-26T08:19:53.2572843+00:00","Level":"Information","SourceContext":"Microsoft.Hosting.Lifetime","Data":{"EventId":3160021582},"Message":"Hosting environment: Production"}

{"Timestamp":"2025-08-26T08:19:53.2586835+00:00","Level":"Information","SourceContext":"Microsoft.Hosting.Lifetime","Data":{"EventId":3425104462},"Message":"Content root path: D:\\App-Data\\iis\\api.incidentreporter365.com\\Apps\\OQSHA.IoT.Data.Aggregator"}

{"Timestamp":"2025-08-26T08:19:54.5868525+00:00","Level":"Information","SourceContext":"OQSHA.IoT.Data.Aggregator.Jobs.MapMyIndiaDrivesDataAggregationJob","Data":{"EventId":3730466832},"Message":"MMI_DRIVE_DATA_AGGREGATOR - Searching for unprocessed IOT data records from 8/19/2025 6:19:54 AM to 8/26/2025 8:19:54 AM"}

{"Timestamp":"2025-08-26T08:19:55.2291653+00:00","Level":"Warning","SourceContext":"Microsoft.EntityFrameworkCore.Model.Validation","Data":{"EventId":2801879644},"Message":"The 'Status' property 'Status' on entity type 'UsageUnitsDBO' is configured with a database-generated default, but has no configured sentinel value. The database-generated default will always be used for inserts when the property has the value 'Inactive', since this is the CLR default for the 'Status' type. Consider using a nullable type, using a nullable backing field, or setting the sentinel value for the property to ensure the database default is used when, and only when, appropriate. See https://aka.ms/efcore-docs-default-values for more information."}

{"Timestamp":"2025-08-26T08:19:55.9647384+00:00","Level":"Information","SourceContext":"Microsoft.EntityFrameworkCore.Database.Command","Data":{"EventId":119789823},"Message":"Executed DbCommand (62ms) [Parameters=[@__fromDate_0='?' (DbType = DateTime), @__toDate_1='?' (DbType = DateTime), @__isProcessed_2='?' (DbType = SByte)], CommandType='Text', CommandTimeout='30']\r\nSELECT `t`.`asset_id` AS `AssetId`, `i`.`id`, `i`.`created_on`, `i`.`data`, `i`.`device_id`, `i`.`device_type`, `i`.`is_processed`, `i`.`modified_on`, `i`.`organisation_id`, `i`.`status`\r\nFROM `iot_data_records` AS `i`\r\nLEFT JOIN (\r\n    SELECT `a`.`asset_id`, `a`.`device_id`\r\n    FROM `asset_iot_devices` AS `a`\r\n    WHERE `a`.`status` = 1\r\n) AS `t` ON `i`.`device_id` = `t`.`device_id`\r\nWHERE (((`i`.`created_on` >= @__fromDate_0) AND (`i`.`created_on` <= @__toDate_1)) AND (`i`.`is_processed` = @__isProcessed_2)) AND (`i`.`status` = 1)\r\nORDER BY `i`.`created_on`"}

{"Timestamp":"2025-08-26T08:19:56.0785447+00:00","Level":"Information","SourceContext":"OQSHA.IoT.Data.Aggregator.Jobs.MapMyIndiaDrivesDataAggregationJob","Data":{"EventId":2390111110},"Message":"MMI_DRIVE_DATA_AGGREGATOR - Found a total of 39 unprocessed IOT data records"}

{"Timestamp":"2025-08-26T08:19:56.1311249+00:00","Level":"Information","SourceContext":"Microsoft.EntityFrameworkCore.Database.Command","Data":{"EventId":119789823},"Message":"Executed DbCommand (6ms) [Parameters=[@__ToLower_1='?' (Size = 4000)], CommandType='Text', CommandTimeout='30']\r\nSELECT `u`.`id`, `u`.`created_on`, `u`.`modified_on`, `u`.`organisation_id`, `u`.`status`, `u`.`unit`\r\nFROM `usage_units` AS `u`\r\nWHERE ((`u`.`organisation_id` = 250) AND (LOWER(TRIM(`u`.`unit`)) = @__ToLower_1)) AND (`u`.`status` = 1)"}

{"Timestamp":"2025-08-26T08:19:56.1610535+00:00","Level":"Information","SourceContext":"Microsoft.EntityFrameworkCore.Database.Command","Data":{"EventId":119789823},"Message":"Executed DbCommand (1ms) [Parameters=[@__ToLower_1='?' (Size = 4000)], CommandType='Text', CommandTimeout='30']\r\nSELECT `u`.`id`, `u`.`created_on`, `u`.`modified_on`, `u`.`organisation_id`, `u`.`status`, `u`.`unit`\r\nFROM `usage_units` AS `u`\r\nWHERE ((`u`.`organisation_id` = 250) AND (LOWER(TRIM(`u`.`unit`)) = @__ToLower_1)) AND (`u`.`status` = 1)"}

{"Timestamp":"2025-08-26T08:19:56.1985714+00:00","Level":"Information","SourceContext":"Microsoft.EntityFrameworkCore.Database.Command","Data":{"EventId":119789823},"Message":"Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30']\r\nSELECT `a`.`asset_id`, `a`.`id`, `a`.`asset_usage`, `a`.`organisation_id`, `a`.`recorded_on`, `a`.`unit_id`\r\nFROM `assets_usage` AS `a`\r\nWHERE `a`.`asset_id` IN (489, 490) AND (`a`.`unit_id` = 252)\r\nORDER BY `a`.`asset_id`"}

{"Timestamp":"2025-08-26T08:19:56.2242154+00:00","Level":"Information","SourceContext":"Microsoft.EntityFrameworkCore.Database.Command","Data":{"EventId":119789823},"Message":"Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30']\r\nSELECT `a`.`asset_id`, `a`.`id`, `a`.`asset_usage`, `a`.`organisation_id`, `a`.`recorded_on`, `a`.`unit_id`\r\nFROM `assets_usage` AS `a`\r\nWHERE `a`.`asset_id` IN (489, 490) AND (`a`.`unit_id` = 253)\r\nORDER BY `a`.`asset_id`"}

{"Timestamp":"2025-08-26T08:19:56.2245544+00:00","Level":"Information","SourceContext":"OQSHA.IoT.Data.Aggregator.Jobs.MapMyIndiaDrivesDataAggregationJob","Data":{"EventId":1678580837},"Message":"MMI_DRIVE_DATA_AGGREGATOR - Successfully retreived all the latest usage record values for the unprocessed IOT devices and their assets"}

{"Timestamp":"2025-08-26T08:19:56.2246126+00:00","Level":"Information","SourceContext":"OQSHA.IoT.Data.Aggregator.Jobs.MapMyIndiaDrivesDataAggregationJob","Data":{"EventId":1151134115},"Message":"MMI_DRIVE_DATA_AGGREGATOR - Started processing the MMI drives data"}

{"Timestamp":"2025-08-26T08:19:56.3985125+00:00","Level":"Information","SourceContext":"OQSHA.IoT.Data.Aggregator.Jobs.MapMyIndiaDrivesDataAggregationJob","Data":{"EventId":2685226301},"Message":"MMI_DRIVE_DATA_AGGREGATOR - Completed processing the MMI drives data"}

{"Timestamp":"2025-08-26T08:19:56.3987520+00:00","Level":"Information","SourceContext":"OQSHA.IoT.Data.Aggregator.Jobs.MapMyIndiaDrivesDataAggregationJob","Data":{"EventId":3664785984},"Message":"MMI_DRIVE_DATA_AGGREGATOR - Inserting 98 asset usage records to the database ..."}

{"Timestamp":"2025-08-26T08:19:56.6047885+00:00","Level":"Information","SourceContext":"Microsoft.EntityFrameworkCore.Database.Command","Data":{"EventId":119789823},"Message":"Executed DbCommand (3ms) [Parameters=[@p0='?' (DbType = Int32), @p1='?' (DbType = Decimal), @p2='?' (DbType = Int32), @p3='?' (DbType = DateTime), @p4='?' (DbType = Int32), @p5='?' (DbType = Int32), @p6='?' (DbType = Decimal), @p7='?' (DbType = Int32), @p8='?' (DbType = DateTime), @p9='?' (DbType = Int32), @p10='?' (DbType = Int32), @p11='?' (DbType = Decimal), @p12='?' (DbType = Int32), @p13='?' (DbType = DateTime), @p14='?' (DbType = Int32), @p15='?' (DbType = Int32), @p16='?' (DbType = Decimal), @p17='?' (DbType = Int32), @p18='?' (DbType = DateTime), @p19='?' (DbType = Int32), @p20='?' (DbType = Int32), @p21='?' (DbType = Decimal), @p22='?' (DbType = Int32), @p23='?' (DbType = DateTime), @p24='?' (DbType = Int32), @p25='?' (DbType = Int32), @p26='?' (DbType = Decimal), @p27='?' (DbType = Int32), @p28='?' (DbType = DateTime), @p29='?' (DbType = Int32), @p30='?' (DbType = Int32), @p31='?' (DbType = Decimal), @p32='?' (DbType = Int32), @p33='?' (DbType = DateTime), @p34='?' (DbType = Int32), @p35='?' (DbType = Int32), @p36='?' (DbType = Decimal), @p37='?' (DbType = Int32), @p38='?' (DbType = DateTime), @p39='?' (DbType = Int32), @p40='?' (DbType = Int32), @p41='?' (DbType = Decimal), @p42='?' (DbType = Int32), @p43='?' (DbType = DateTime), @p44='?' (DbType = Int32), @p45='?' (DbType = Int32), @p46='?' (DbType = Decimal), @p47='?' (DbType = Int32), @p48='?' (DbType = DateTime), @p49='?' (DbType = Int32), @p50='?' (DbType = Int32), @p51='?' (DbType = Decimal), @p52='?' (DbType = Int32), @p53='?' (DbType = DateTime), @p54='?' (DbType = Int32), @p55='?' (DbType = Int32), @p56='?' (DbType = Decimal), @p57='?' (DbType = Int32), @p58='?' (DbType = DateTime), @p59='?' (DbType = Int32), @p60='?' (DbType = Int32), @p61='?' (DbType = Decimal), @p62='?' (DbType = Int32), @p63='?' (DbType = DateTime), @p64='?' (DbType = Int32), @p65='?' (DbType = Int32), @p66='?' (DbType = Decimal), @p67='?' (DbType = Int32), @p68='?' (DbType = DateTime), @p69='?' (DbType = Int32), @p70='?' (DbType = Int32), @p71='?' (DbType = Decimal), @p72='?' (DbType = Int32), @p73='?' (DbType = DateTime), @p74='?' (DbType = Int32), @p75='?' (DbType = Int32), @p76='?' (DbType = Decimal), @p77='?' (DbType = Int32), @p78='?' (DbType = DateTime), @p79='?' (DbType = Int32), @p80='?' (DbType = Int32), @p81='?' (DbType = Decimal), @p82='?' (DbType = Int32), @p83='?' (DbType = DateTime), @p84='?' (DbType = Int32), @p85='?' (DbType = Int32), @p86='?' (DbType = Decimal), @p87='?' (DbType = Int32), @p88='?' (DbType = DateTime), @p89='?' (DbType = Int32), @p90='?' (DbType = Int32), @p91='?' (DbType = Decimal), @p92='?' (DbType = Int32), @p93='?' (DbType = DateTime), @p94='?' (DbType = Int32), @p95='?' (DbType = Int32), @p96='?' (DbType = Decimal), @p97='?' (DbType = Int32), @p98='?' (DbType = DateTime), @p99='?' (DbType = Int32), @p100='?' (DbType = Int32), @p101='?' (DbType = Decimal), @p102='?' (DbType = Int32), @p103='?' (DbType = DateTime), @p104='?' (DbType = Int32), @p105='?' (DbType = Int32), @p106='?' (DbType = Decimal), @p107='?' (DbType = Int32), @p108='?' (DbType = DateTime), @p109='?' (DbType = Int32), @p110='?' (DbType = Int32), @p111='?' (DbType = Decimal), @p112='?' (DbType = Int32), @p113='?' (DbType = DateTime), @p114='?' (DbType = Int32), @p115='?' (DbType = Int32), @p116='?' (DbType = Decimal), @p117='?' (DbType = Int32), @p118='?' (DbType = DateTime), @p119='?' (DbType = Int32), @p120='?' (DbType = Int32), @p121='?' (DbType = Decimal), @p122='?' (DbType = Int32), @p123='?' (DbType = DateTime), @p124='?' (DbType = Int32), @p125='?' (DbType = Int32), @p126='?' (DbType = Decimal), @p127='?' (DbType = Int32), @p128='?' (DbType = DateTime), @p129='?' (DbType = Int32), @p130='?' (DbType = Int32), @p131='?' (DbType = Decimal), @p132='?' (DbType = Int32), @p133='?' (DbType = DateTime), @p134='?' (DbType = Int32), @p135='?' (DbType = Int32), @p136='?' (DbType = Decimal), @p137='?' (DbType = Int32), @p138='?' (DbType = DateTime), @p139='?' (DbType = Int32), @p140='?' (DbType = Int32), @p141='?' (DbType = Decimal), @p142='?' (DbType = Int32), @p143='?' (DbType = DateTime), @p144='?' (DbType = Int32), @p145='?' (DbType = Int32), @p146='?' (DbType = Decimal), @p147='?' (DbType = Int32), @p148='?' (DbType = DateTime), @p149='?' (DbType = Int32), @p150='?' (DbType = Int32), @p151='?' (DbType = Decimal), @p152='?' (DbType = Int32), @p153='?' (DbType = DateTime), @p154='?' (DbType = Int32), @p155='?' (DbType = Int32), @p156='?' (DbType = Decimal), @p157='?' (DbType = Int32), @p158='?' (DbType = DateTime), @p159='?' (DbType = Int32), @p160='?' (DbType = Int32), @p161='?' (DbType = Decimal), @p162='?' (DbType = Int32), @p163='?' (DbType = DateTime), @p164='?' (DbType = Int32), @p165='?' (DbType = Int32), @p166='?' (DbType = Decimal), @p167='?' (DbType = Int32), @p168='?' (DbType = DateTime), @p169='?' (DbType = Int32), @p170='?' (DbType = Int32), @p171='?' (DbType = Decimal), @p172='?' (DbType = Int32), @p173='?' (DbType = DateTime), @p174='?' (DbType = Int32), @p175='?' (DbType = Int32), @p176='?' (DbType = Decimal), @p177='?' (DbType = Int32), @p178='?' (DbType = DateTime), @p179='?' (DbType = Int32), @p180='?' (DbType = Int32), @p181='?' (DbType = Decimal), @p182='?' (DbType = Int32), @p183='?' (DbType = DateTime), @p184='?' (DbType = Int32), @p185='?' (DbType = Int32), @p186='?' (DbType = Decimal), @p187='?' (DbType = Int32), @p188='?' (DbType = DateTime), @p189='?' (DbType = Int32), @p190='?' (DbType = Int32), @p191='?' (DbType = Decimal), @p192='?' (DbType = Int32), @p193='?' (DbType = DateTime), @p194='?' (DbType = Int32), @p195='?' (DbType = Int32), @p196='?' (DbType = Decimal), @p197='?' (DbType = Int32), @p198='?' (DbType = DateTime), @p199='?' (DbType = Int32), @p200='?' (DbType = Int32), @p201='?' (DbType = Decimal), @p202='?' (DbType = Int32), @p203='?' (DbType = DateTime), @p204='?' (DbType = Int32), @p205='?' (DbType = Int32), @p206='?' (DbType = Decimal), @p207='?' (DbType = Int32), @p208='?' (DbType = DateTime), @p209='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']\r\nINSERT INTO `assets_usage` (`asset_id`, `asset_usage`, `organisation_id`, `recorded_on`, `unit_id`)\r\nVALUES (@p0, @p1, @p2, @p3, @p4)\r\nRETURNING `id`;\r\nINSERT INTO `assets_usage` (`asset_id`, `asset_usage`, `organisation_id`, `recorded_on`, `unit_id`)\r\nVALUES (@p5, @p6, @p7, @p8, @p9)\r\nRETURNING `id`;\r\nINSERT INTO `assets_usage` (`asset_id`, `asset_usage`, `organisation_id`, `recorded_on`, `unit_id`)\r\nVALUES (@p10, @p11, @p12, @p13, @p14)\r\nRETURNING `id`;\r\nINSERT INTO `assets_usage` (`asset_id`, `asset_usage`, `organisation_id`, `recorded_on`, `unit_id`)\r\nVALUES (@p15, @p16, @p17, @p18, @p19)\r\nRETURNING `id`;\r\nINSERT INTO `assets_usage` (`asset_id`, `asset_usage`, `organisation_id`, `recorded_on`, `unit_id`)\r\nVALUES (@p20, @p21, @p22, @p23, @p24)\r\nRETURNING `id`;\r\nINSERT INTO `assets_usage` (`asset_id`, `asset_usage`, `organisation_id`, `recorded_on`, `unit_id`)\r\nVALUES (@p25, @p26, @p27, @p28, @p29)\r\nRETURNING `id`;\r\nINSERT INTO `assets_usage` (`asset_id`, `asset_usage`, `organisation_id`, `recorded_on`, `unit_id`)\r\nVALUES (@p30, @p31, @p32, @p33, @p34)\r\nRETURNING `id`;\r\nINSERT INTO `assets_usage` (`asset_id`, `asset_usage`, `organisation_id`, `recorded_on`, `unit_id`)\r\nVALUES (@p35, @p36, @p37, @p38, @p39)\r\nRETURNING `id`;\r\nINSERT INTO `assets_usage` (`asset_id`, `asset_usage`, `organisation_id`, `recorded_on`, `unit_id`)\r\nVALUES (@p40, @p41, @p42, @p43, @p44)\r\nRETURNING `id`;\r\nINSERT INTO `assets_usage` (`asset_id`, `asset_usage`, `organisation_id`, `recorded_on`, `unit_id`)\r\nVALUES (@p45, @p46, @p47, @p48, @p49)\r\nRETURNING `id`;\r\nINSERT INTO `assets_usage` (`asset_id`, `asset_usage`, `organisation_id`, `recorded_on`, `unit_id`)\r\nVALUES (@p50, @p51, @p52, @p53, @p54)\r\nRETURNING `id`;\r\nINSERT INTO `assets_usage` (`asset_id`, `asset_usage`, `organisation_id`, `recorded_on`, `unit_id`)\r\nVALUES (@p55, @p56, @p57, @p58, @p59)\r\nRETURNING `id`;\r\nINSERT INTO `assets_usage` (`asset_id`, `asset_usage`, `organisation_id`, `recorded_on`, `unit_id`)\r\nVALUES (@p60, @p61, @p62, @p63, @p64)\r\nRETURNING `id`;\r\nINSERT INTO `assets_usage` (`asset_id`, `asset_usage`, `organisation_id`, `recorded_on`, `unit_id`)\r\nVALUES (@p65, @p66, @p67, @p68, @p69)\r\nRETURNING `id`;\r\nINSERT INTO `assets_usage` (`asset_id`, `asset_usage`, `organisation_id`, `recorded_on`, `unit_id`)\r\nVALUES (@p70, @p71, @p72, @p73, @p74)\r\nRETURNING `id`;\r\nINSERT INTO `assets_usage` (`asset_id`, `asset_usage`, `organisation_id`, `recorded_on`, `unit_id`)\r\nVALUES (@p75, @p76, @p77, @p78, @p79)\r\nRETURNING `id`;\r\nINSERT INTO `assets_usage` (`asset_id`, `asset_usage`, `organisation_id`, `recorded_on`, `unit_id`)\r\nVALUES (@p80, @p81, @p82, @p83, @p84)\r\nRETURNING `id`;\r\nINSERT INTO `assets_usage` (`asset_id`, `asset_usage`, `organisation_id`, `recorded_on`, `unit_id`)\r\nVALUES (@p85, @p86, @p87, @p88, @p89)\r\nRETURNING `id`;\r\nINSERT INTO `assets_usage` (`asset_id`, `asset_usage`, `organisation_id`, `recorded_on`, `unit_id`)\r\nVALUES (@p90, @p91, @p92, @p93, @p94)\r\nRETURNING `id`;\r\nINSERT INTO `assets_usage` (`asset_id`, `asset_usage`, `organisation_id`, `recorded_on`, `unit_id`)\r\nVALUES (@p95, @p96, @p97, @p98, @p99)\r\nRETURNING `id`;\r\nINSERT INTO `assets_usage` (`asset_id`, `asset_usage`, `organisation_id`, `recorded_on`, `unit_id`)\r\nVALUES (@p100, @p101, @p102, @p103, @p104)\r\nRETURNING `id`;\r\nINSERT INTO `assets_usage` (`asset_id`, `asset_usage`, `organisation_id`, `recorded_on`, `unit_id`)\r\nVALUES (@p105, @p106, @p107, @p108, @p109)\r\nRETURNING `id`;\r\nINSERT INTO `assets_usage` (`asset_id`, `asset_usage`, `organisation_id`, `recorded_on`, `unit_id`)\r\nVALUES (@p110, @p111, @p112, @p113, @p114)\r\nRETURNING `id`;\r\nINSERT INTO `assets_usage` (`asset_id`, `asset_usage`, `organisation_id`, `recorded_on`, `unit_id`)\r\nVALUES (@p115, @p116, @p117, @p118, @p119)\r\nRETURNING `id`;\r\nINSERT INTO `assets_usage` (`asset_id`, `asset_usage`, `organisation_id`, `recorded_on`, `unit_id`)\r\nVALUES (@p120, @p121, @p122, @p123, @p124)\r\nRETURNING `id`;\r\nINSERT INTO `assets_usage` (`asset_id`, `asset_usage`, `organisation_id`, `recorded_on`, `unit_id`)\r\nVALUES (@p125, @p126, @p127, @p128, @p129)\r\nRETURNING `id`;\r\nINSERT INTO `assets_usage` (`asset_id`, `asset_usage`, `organisation_id`, `recorded_on`, `unit_id`)\r\nVALUES (@p130, @p131, @p132, @p133, @p134)\r\nRETURNING `id`;\r\nINSERT INTO `assets_usage` (`asset_id`, `asset_usage`, `organisation_id`, `recorded_on`, `unit_id`)\r\nVALUES (@p135, @p136, @p137, @p138, @p139)\r\nRETURNING `id`;\r\nINSERT INTO `assets_usage` (`asset_id`, `asset_usage`, `organisation_id`, `recorded_on`, `unit_id`)\r\nVALUES (@p140, @p141, @p142, @p143, @p144)\r\nRETURNING `id`;\r\nINSERT INTO `assets_usage` (`asset_id`, `asset_usage`, `organisation_id`, `recorded_on`, `unit_id`)\r\nVALUES (@p145, @p146, @p147, @p148, @p149)\r\nRETURNING `id`;\r\nINSERT INTO `assets_usage` (`asset_id`, `asset_usage`, `organisation_id`, `recorded_on`, `unit_id`)\r\nVALUES (@p150, @p151, @p152, @p153, @p154)\r\nRETURNING `id`;\r\nINSERT INTO `assets_usage` (`asset_id`, `asset_usage`, `organisation_id`, `recorded_on`, `unit_id`)\r\nVALUES (@p155, @p156, @p157, @p158, @p159)\r\nRETURNING `id`;\r\nINSERT INTO `assets_usage` (`asset_id`, `asset_usage`, `organisation_id`, `recorded_on`, `unit_id`)\r\nVALUES (@p160, @p161, @p162, @p163, @p164)\r\nRETURNING `id`;\r\nINSERT INTO `assets_usage` (`asset_id`, `asset_usage`, `organisation_id`, `recorded_on`, `unit_id`)\r\nVALUES (@p165, @p166, @p167, @p168, @p169)\r\nRETURNING `id`;\r\nINSERT INTO `assets_usage` (`asset_id`, `asset_usage`, `organisation_id`, `recorded_on`, `unit_id`)\r\nVALUES (@p170, @p171, @p172, @p173, @p174)\r\nRETURNING `id`;\r\nINSERT INTO `assets_usage` (`asset_id`, `asset_usage`, `organisation_id`, `recorded_on`, `unit_id`)\r\nVALUES (@p175, @p176, @p177, @p178, @p179)\r\nRETURNING `id`;\r\nINSERT INTO `assets_usage` (`asset_id`, `asset_usage`, `organisation_id`, `recorded_on`, `unit_id`)\r\nVALUES (@p180, @p181, @p182, @p183, @p184)\r\nRETURNING `id`;\r\nINSERT INTO `assets_usage` (`asset_id`, `asset_usage`, `organisation_id`, `recorded_on`, `unit_id`)\r\nVALUES (@p185, @p186, @p187, @p188, @p189)\r\nRETURNING `id`;\r\nINSERT INTO `assets_usage` (`asset_id`, `asset_usage`, `organisation_id`, `recorded_on`, `unit_id`)\r\nVALUES (@p190, @p191, @p192, @p193, @p194)\r\nRETURNING `id`;\r\nINSERT INTO `assets_usage` (`asset_id`, `asset_usage`, `organisation_id`, `recorded_on`, `unit_id`)\r\nVALUES (@p195, @p196, @p197, @p198, @p199)\r\nRETURNING `id`;\r\nINSERT INTO `assets_usage` (`asset_id`, `asset_usage`, `organisation_id`, `recorded_on`, `unit_id`)\r\nVALUES (@p200, @p201, @p202, @p203, @p204)\r\nRETURNING `id`;\r\nINSERT INTO `assets_usage` (`asset_id`, `asset_usage`, `organisation_id`, `recorded_on`, `unit_id`)\r\nVALUES (@p205, @p206, @p207, @p208, @p209)\r\nRETURNING `id`;"}

{"Timestamp":"2025-08-26T08:19:56.6406273+00:00","Level":"Information","SourceContext":"Microsoft.EntityFrameworkCore.Database.Command","Data":{"EventId":119789823},"Message":"Executed DbCommand (14ms) [Parameters=[@p0='?' (DbType = Int32), @p1='?' (DbType = Decimal), @p2='?' (DbType = Int32), @p3='?' (DbType = DateTime), @p4='?' (DbType = Int32), @p5='?' (DbType = Int32), @p6='?' (DbType = Decimal), @p7='?' (DbType = Int32), @p8='?' (DbType = DateTime), @p9='?' (DbType = Int32), @p10='?' (DbType = Int32), @p11='?' (DbType = Decimal), @p12='?' (DbType = Int32), @p13='?' (DbType = DateTime), @p14='?' (DbType = Int32), @p15='?' (DbType = Int32), @p16='?' (DbType = Decimal), @p17='?' (DbType = Int32), @p18='?' (DbType = DateTime), @p19='?' (DbType = Int32), @p20='?' (DbType = Int32), @p21='?' (DbType = Decimal), @p22='?' (DbType = Int32), @p23='?' (DbType = DateTime), @p24='?' (DbType = Int32), @p25='?' (DbType = Int32), @p26='?' (DbType = Decimal), @p27='?' (DbType = Int32), @p28='?' (DbType = DateTime), @p29='?' (DbType = Int32), @p30='?' (DbType = Int32), @p31='?' (DbType = Decimal), @p32='?' (DbType = Int32), @p33='?' (DbType = DateTime), @p34='?' (DbType = Int32), @p35='?' (DbType = Int32), @p36='?' (DbType = Decimal), @p37='?' (DbType = Int32), @p38='?' (DbType = DateTime), @p39='?' (DbType = Int32), @p40='?' (DbType = Int32), @p41='?' (DbType = Decimal), @p42='?' (DbType = Int32), @p43='?' (DbType = DateTime), @p44='?' (DbType = Int32), @p45='?' (DbType = Int32), @p46='?' (DbType = Decimal), @p47='?' (DbType = Int32), @p48='?' (DbType = DateTime), @p49='?' (DbType = Int32), @p50='?' (DbType = Int32), @p51='?' (DbType = Decimal), @p52='?' (DbType = Int32), @p53='?' (DbType = DateTime), @p54='?' (DbType = Int32), @p55='?' (DbType = Int32), @p56='?' (DbType = Decimal), @p57='?' (DbType = Int32), @p58='?' (DbType = DateTime), @p59='?' (DbType = Int32), @p60='?' (DbType = Int32), @p61='?' (DbType = Decimal), @p62='?' (DbType = Int32), @p63='?' (DbType = DateTime), @p64='?' (DbType = Int32), @p65='?' (DbType = Int32), @p66='?' (DbType = Decimal), @p67='?' (DbType = Int32), @p68='?' (DbType = DateTime), @p69='?' (DbType = Int32), @p70='?' (DbType = Int32), @p71='?' (DbType = Decimal), @p72='?' (DbType = Int32), @p73='?' (DbType = DateTime), @p74='?' (DbType = Int32), @p75='?' (DbType = Int32), @p76='?' (DbType = Decimal), @p77='?' (DbType = Int32), @p78='?' (DbType = DateTime), @p79='?' (DbType = Int32), @p80='?' (DbType = Int32), @p81='?' (DbType = Decimal), @p82='?' (DbType = Int32), @p83='?' (DbType = DateTime), @p84='?' (DbType = Int32), @p85='?' (DbType = Int32), @p86='?' (DbType = Decimal), @p87='?' (DbType = Int32), @p88='?' (DbType = DateTime), @p89='?' (DbType = Int32), @p90='?' (DbType = Int32), @p91='?' (DbType = Decimal), @p92='?' (DbType = Int32), @p93='?' (DbType = DateTime), @p94='?' (DbType = Int32), @p95='?' (DbType = Int32), @p96='?' (DbType = Decimal), @p97='?' (DbType = Int32), @p98='?' (DbType = DateTime), @p99='?' (DbType = Int32), @p100='?' (DbType = Int32), @p101='?' (DbType = Decimal), @p102='?' (DbType = Int32), @p103='?' (DbType = DateTime), @p104='?' (DbType = Int32), @p105='?' (DbType = Int32), @p106='?' (DbType = Decimal), @p107='?' (DbType = Int32), @p108='?' (DbType = DateTime), @p109='?' (DbType = Int32), @p110='?' (DbType = Int32), @p111='?' (DbType = Decimal), @p112='?' (DbType = Int32), @p113='?' (DbType = DateTime), @p114='?' (DbType = Int32), @p115='?' (DbType = Int32), @p116='?' (DbType = Decimal), @p117='?' (DbType = Int32), @p118='?' (DbType = DateTime), @p119='?' (DbType = Int32), @p120='?' (DbType = Int32), @p121='?' (DbType = Decimal), @p122='?' (DbType = Int32), @p123='?' (DbType = DateTime), @p124='?' (DbType = Int32), @p125='?' (DbType = Int32), @p126='?' (DbType = Decimal), @p127='?' (DbType = Int32), @p128='?' (DbType = DateTime), @p129='?' (DbType = Int32), @p130='?' (DbType = Int32), @p131='?' (DbType = Decimal), @p132='?' (DbType = Int32), @p133='?' (DbType = DateTime), @p134='?' (DbType = Int32), @p135='?' (DbType = Int32), @p136='?' (DbType = Decimal), @p137='?' (DbType = Int32), @p138='?' (DbType = DateTime), @p139='?' (DbType = Int32), @p140='?' (DbType = Int32), @p141='?' (DbType = Decimal), @p142='?' (DbType = Int32), @p143='?' (DbType = DateTime), @p144='?' (DbType = Int32), @p145='?' (DbType = Int32), @p146='?' (DbType = Decimal), @p147='?' (DbType = Int32), @p148='?' (DbType = DateTime), @p149='?' (DbType = Int32), @p150='?' (DbType = Int32), @p151='?' (DbType = Decimal), @p152='?' (DbType = Int32), @p153='?' (DbType = DateTime), @p154='?' (DbType = Int32), @p155='?' (DbType = Int32), @p156='?' (DbType = Decimal), @p157='?' (DbType = Int32), @p158='?' (DbType = DateTime), @p159='?' (DbType = Int32), @p160='?' (DbType = Int32), @p161='?' (DbType = Decimal), @p162='?' (DbType = Int32), @p163='?' (DbType = DateTime), @p164='?' (DbType = Int32), @p165='?' (DbType = Int32), @p166='?' (DbType = Decimal), @p167='?' (DbType = Int32), @p168='?' (DbType = DateTime), @p169='?' (DbType = Int32), @p170='?' (DbType = Int32), @p171='?' (DbType = Decimal), @p172='?' (DbType = Int32), @p173='?' (DbType = DateTime), @p174='?' (DbType = Int32), @p175='?' (DbType = Int32), @p176='?' (DbType = Decimal), @p177='?' (DbType = Int32), @p178='?' (DbType = DateTime), @p179='?' (DbType = Int32), @p180='?' (DbType = Int32), @p181='?' (DbType = Decimal), @p182='?' (DbType = Int32), @p183='?' (DbType = DateTime), @p184='?' (DbType = Int32), @p185='?' (DbType = Int32), @p186='?' (DbType = Decimal), @p187='?' (DbType = Int32), @p188='?' (DbType = DateTime), @p189='?' (DbType = Int32), @p190='?' (DbType = Int32), @p191='?' (DbType = Decimal), @p192='?' (DbType = Int32), @p193='?' (DbType = DateTime), @p194='?' (DbType = Int32), @p195='?' (DbType = Int32), @p196='?' (DbType = Decimal), @p197='?' (DbType = Int32), @p198='?' (DbType = DateTime), @p199='?' (DbType = Int32), @p200='?' (DbType = Int32), @p201='?' (DbType = Decimal), @p202='?' (DbType = Int32), @p203='?' (DbType = DateTime), @p204='?' (DbType = Int32), @p205='?' (DbType = Int32), @p206='?' (DbType = Decimal), @p207='?' (DbType = Int32), @p208='?' (DbType = DateTime), @p209='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']\r\nINSERT INTO `assets_usage` (`asset_id`, `asset_usage`, `organisation_id`, `recorded_on`, `unit_id`)\r\nVALUES (@p0, @p1, @p2, @p3, @p4)\r\nRETURNING `id`;\r\nINSERT INTO `assets_usage` (`asset_id`, `asset_usage`, `organisation_id`, `recorded_on`, `unit_id`)\r\nVALUES (@p5, @p6, @p7, @p8, @p9)\r\nRETURNING `id`;\r\nINSERT INTO `assets_usage` (`asset_id`, `asset_usage`, `organisation_id`, `recorded_on`, `unit_id`)\r\nVALUES (@p10, @p11, @p12, @p13, @p14)\r\nRETURNING `id`;\r\nINSERT INTO `assets_usage` (`asset_id`, `asset_usage`, `organisation_id`, `recorded_on`, `unit_id`)\r\nVALUES (@p15, @p16, @p17, @p18, @p19)\r\nRETURNING `id`;\r\nINSERT INTO `assets_usage` (`asset_id`, `asset_usage`, `organisation_id`, `recorded_on`, `unit_id`)\r\nVALUES (@p20, @p21, @p22, @p23, @p24)\r\nRETURNING `id`;\r\nINSERT INTO `assets_usage` (`asset_id`, `asset_usage`, `organisation_id`, `recorded_on`, `unit_id`)\r\nVALUES (@p25, @p26, @p27, @p28, @p29)\r\nRETURNING `id`;\r\nINSERT INTO `assets_usage` (`asset_id`, `asset_usage`, `organisation_id`, `recorded_on`, `unit_id`)\r\nVALUES (@p30, @p31, @p32, @p33, @p34)\r\nRETURNING `id`;\r\nINSERT INTO `assets_usage` (`asset_id`, `asset_usage`, `organisation_id`, `recorded_on`, `unit_id`)\r\nVALUES (@p35, @p36, @p37, @p38, @p39)\r\nRETURNING `id`;\r\nINSERT INTO `assets_usage` (`asset_id`, `asset_usage`, `organisation_id`, `recorded_on`, `unit_id`)\r\nVALUES (@p40, @p41, @p42, @p43, @p44)\r\nRETURNING `id`;\r\nINSERT INTO `assets_usage` (`asset_id`, `asset_usage`, `organisation_id`, `recorded_on`, `unit_id`)\r\nVALUES (@p45, @p46, @p47, @p48, @p49)\r\nRETURNING `id`;\r\nINSERT INTO `assets_usage` (`asset_id`, `asset_usage`, `organisation_id`, `recorded_on`, `unit_id`)\r\nVALUES (@p50, @p51, @p52, @p53, @p54)\r\nRETURNING `id`;\r\nINSERT INTO `assets_usage` (`asset_id`, `asset_usage`, `organisation_id`, `recorded_on`, `unit_id`)\r\nVALUES (@p55, @p56, @p57, @p58, @p59)\r\nRETURNING `id`;\r\nINSERT INTO `assets_usage` (`asset_id`, `asset_usage`, `organisation_id`, `recorded_on`, `unit_id`)\r\nVALUES (@p60, @p61, @p62, @p63, @p64)\r\nRETURNING `id`;\r\nINSERT INTO `assets_usage` (`asset_id`, `asset_usage`, `organisation_id`, `recorded_on`, `unit_id`)\r\nVALUES (@p65, @p66, @p67, @p68, @p69)\r\nRETURNING `id`;\r\nINSERT INTO `assets_usage` (`asset_id`, `asset_usage`, `organisation_id`, `recorded_on`, `unit_id`)\r\nVALUES (@p70, @p71, @p72, @p73, @p74)\r\nRETURNING `id`;\r\nINSERT INTO `assets_usage` (`asset_id`, `asset_usage`, `organisation_id`, `recorded_on`, `unit_id`)\r\nVALUES (@p75, @p76, @p77, @p78, @p79)\r\nRETURNING `id`;\r\nINSERT INTO `assets_usage` (`asset_id`, `asset_usage`, `organisation_id`, `recorded_on`, `unit_id`)\r\nVALUES (@p80, @p81, @p82, @p83, @p84)\r\nRETURNING `id`;\r\nINSERT INTO `assets_usage` (`asset_id`, `asset_usage`, `organisation_id`, `recorded_on`, `unit_id`)\r\nVALUES (@p85, @p86, @p87, @p88, @p89)\r\nRETURNING `id`;\r\nINSERT INTO `assets_usage` (`asset_id`, `asset_usage`, `organisation_id`, `recorded_on`, `unit_id`)\r\nVALUES (@p90, @p91, @p92, @p93, @p94)\r\nRETURNING `id`;\r\nINSERT INTO `assets_usage` (`asset_id`, `asset_usage`, `organisation_id`, `recorded_on`, `unit_id`)\r\nVALUES (@p95, @p96, @p97, @p98, @p99)\r\nRETURNING `id`;\r\nINSERT INTO `assets_usage` (`asset_id`, `asset_usage`, `organisation_id`, `recorded_on`, `unit_id`)\r\nVALUES (@p100, @p101, @p102, @p103, @p104)\r\nRETURNING `id`;\r\nINSERT INTO `assets_usage` (`asset_id`, `asset_usage`, `organisation_id`, `recorded_on`, `unit_id`)\r\nVALUES (@p105, @p106, @p107, @p108, @p109)\r\nRETURNING `id`;\r\nINSERT INTO `assets_usage` (`asset_id`, `asset_usage`, `organisation_id`, `recorded_on`, `unit_id`)\r\nVALUES (@p110, @p111, @p112, @p113, @p114)\r\nRETURNING `id`;\r\nINSERT INTO `assets_usage` (`asset_id`, `asset_usage`, `organisation_id`, `recorded_on`, `unit_id`)\r\nVALUES (@p115, @p116, @p117, @p118, @p119)\r\nRETURNING `id`;\r\nINSERT INTO `assets_usage` (`asset_id`, `asset_usage`, `organisation_id`, `recorded_on`, `unit_id`)\r\nVALUES (@p120, @p121, @p122, @p123, @p124)\r\nRETURNING `id`;\r\nINSERT INTO `assets_usage` (`asset_id`, `asset_usage`, `organisation_id`, `recorded_on`, `unit_id`)\r\nVALUES (@p125, @p126, @p127, @p128, @p129)\r\nRETURNING `id`;\r\nINSERT INTO `assets_usage` (`asset_id`, `asset_usage`, `organisation_id`, `recorded_on`, `unit_id`)\r\nVALUES (@p130, @p131, @p132, @p133, @p134)\r\nRETURNING `id`;\r\nINSERT INTO `assets_usage` (`asset_id`, `asset_usage`, `organisation_id`, `recorded_on`, `unit_id`)\r\nVALUES (@p135, @p136, @p137, @p138, @p139)\r\nRETURNING `id`;\r\nINSERT INTO `assets_usage` (`asset_id`, `asset_usage`, `organisation_id`, `recorded_on`, `unit_id`)\r\nVALUES (@p140, @p141, @p142, @p143, @p144)\r\nRETURNING `id`;\r\nINSERT INTO `assets_usage` (`asset_id`, `asset_usage`, `organisation_id`, `recorded_on`, `unit_id`)\r\nVALUES (@p145, @p146, @p147, @p148, @p149)\r\nRETURNING `id`;\r\nINSERT INTO `assets_usage` (`asset_id`, `asset_usage`, `organisation_id`, `recorded_on`, `unit_id`)\r\nVALUES (@p150, @p151, @p152, @p153, @p154)\r\nRETURNING `id`;\r\nINSERT INTO `assets_usage` (`asset_id`, `asset_usage`, `organisation_id`, `recorded_on`, `unit_id`)\r\nVALUES (@p155, @p156, @p157, @p158, @p159)\r\nRETURNING `id`;\r\nINSERT INTO `assets_usage` (`asset_id`, `asset_usage`, `organisation_id`, `recorded_on`, `unit_id`)\r\nVALUES (@p160, @p161, @p162, @p163, @p164)\r\nRETURNING `id`;\r\nINSERT INTO `assets_usage` (`asset_id`, `asset_usage`, `organisation_id`, `recorded_on`, `unit_id`)\r\nVALUES (@p165, @p166, @p167, @p168, @p169)\r\nRETURNING `id`;\r\nINSERT INTO `assets_usage` (`asset_id`, `asset_usage`, `organisation_id`, `recorded_on`, `unit_id`)\r\nVALUES (@p170, @p171, @p172, @p173, @p174)\r\nRETURNING `id`;\r\nINSERT INTO `assets_usage` (`asset_id`, `asset_usage`, `organisation_id`, `recorded_on`, `unit_id`)\r\nVALUES (@p175, @p176, @p177, @p178, @p179)\r\nRETURNING `id`;\r\nINSERT INTO `assets_usage` (`asset_id`, `asset_usage`, `organisation_id`, `recorded_on`, `unit_id`)\r\nVALUES (@p180, @p181, @p182, @p183, @p184)\r\nRETURNING `id`;\r\nINSERT INTO `assets_usage` (`asset_id`, `asset_usage`, `organisation_id`, `recorded_on`, `unit_id`)\r\nVALUES (@p185, @p186, @p187, @p188, @p189)\r\nRETURNING `id`;\r\nINSERT INTO `assets_usage` (`asset_id`, `asset_usage`, `organisation_id`, `recorded_on`, `unit_id`)\r\nVALUES (@p190, @p191, @p192, @p193, @p194)\r\nRETURNING `id`;\r\nINSERT INTO `assets_usage` (`asset_id`, `asset_usage`, `organisation_id`, `recorded_on`, `unit_id`)\r\nVALUES (@p195, @p196, @p197, @p198, @p199)\r\nRETURNING `id`;\r\nINSERT INTO `assets_usage` (`asset_id`, `asset_usage`, `organisation_id`, `recorded_on`, `unit_id`)\r\nVALUES (@p200, @p201, @p202, @p203, @p204)\r\nRETURNING `id`;\r\nINSERT INTO `assets_usage` (`asset_id`, `asset_usage`, `organisation_id`, `recorded_on`, `unit_id`)\r\nVALUES (@p205, @p206, @p207, @p208, @p209)\r\nRETURNING `id`;"}

{"Timestamp":"2025-08-26T08:19:56.6508825+00:00","Level":"Information","SourceContext":"Microsoft.EntityFrameworkCore.Database.Command","Data":{"EventId":119789823},"Message":"Executed DbCommand (1ms) [Parameters=[@p0='?' (DbType = Int32), @p1='?' (DbType = Decimal), @p2='?' (DbType = Int32), @p3='?' (DbType = DateTime), @p4='?' (DbType = Int32), @p5='?' (DbType = Int32), @p6='?' (DbType = Decimal), @p7='?' (DbType = Int32), @p8='?' (DbType = DateTime), @p9='?' (DbType = Int32), @p10='?' (DbType = Int32), @p11='?' (DbType = Decimal), @p12='?' (DbType = Int32), @p13='?' (DbType = DateTime), @p14='?' (DbType = Int32), @p15='?' (DbType = Int32), @p16='?' (DbType = Decimal), @p17='?' (DbType = Int32), @p18='?' (DbType = DateTime), @p19='?' (DbType = Int32), @p20='?' (DbType = Int32), @p21='?' (DbType = Decimal), @p22='?' (DbType = Int32), @p23='?' (DbType = DateTime), @p24='?' (DbType = Int32), @p25='?' (DbType = Int32), @p26='?' (DbType = Decimal), @p27='?' (DbType = Int32), @p28='?' (DbType = DateTime), @p29='?' (DbType = Int32), @p30='?' (DbType = Int32), @p31='?' (DbType = Decimal), @p32='?' (DbType = Int32), @p33='?' (DbType = DateTime), @p34='?' (DbType = Int32), @p35='?' (DbType = Int32), @p36='?' (DbType = Decimal), @p37='?' (DbType = Int32), @p38='?' (DbType = DateTime), @p39='?' (DbType = Int32), @p40='?' (DbType = Int32), @p41='?' (DbType = Decimal), @p42='?' (DbType = Int32), @p43='?' (DbType = DateTime), @p44='?' (DbType = Int32), @p45='?' (DbType = Int32), @p46='?' (DbType = Decimal), @p47='?' (DbType = Int32), @p48='?' (DbType = DateTime), @p49='?' (DbType = Int32), @p50='?' (DbType = Int32), @p51='?' (DbType = Decimal), @p52='?' (DbType = Int32), @p53='?' (DbType = DateTime), @p54='?' (DbType = Int32), @p55='?' (DbType = Int32), @p56='?' (DbType = Decimal), @p57='?' (DbType = Int32), @p58='?' (DbType = DateTime), @p59='?' (DbType = Int32), @p60='?' (DbType = Int32), @p61='?' (DbType = Decimal), @p62='?' (DbType = Int32), @p63='?' (DbType = DateTime), @p64='?' (DbType = Int32), @p65='?' (DbType = Int32), @p66='?' (DbType = Decimal), @p67='?' (DbType = Int32), @p68='?' (DbType = DateTime), @p69='?' (DbType = Int32), @p72='?' (DbType = Int32), @p70='?' (DbType = SByte), @p71='?' (DbType = DateTime), @p75='?' (DbType = Int32), @p73='?' (DbType = SByte), @p74='?' (DbType = DateTime), @p78='?' (DbType = Int32), @p76='?' (DbType = SByte), @p77='?' (DbType = DateTime), @p81='?' (DbType = Int32), @p79='?' (DbType = SByte), @p80='?' (DbType = DateTime), @p84='?' (DbType = Int32), @p82='?' (DbType = SByte), @p83='?' (DbType = DateTime), @p87='?' (DbType = Int32), @p85='?' (DbType = SByte), @p86='?' (DbType = DateTime), @p90='?' (DbType = Int32), @p88='?' (DbType = SByte), @p89='?' (DbType = DateTime), @p93='?' (DbType = Int32), @p91='?' (DbType = SByte), @p92='?' (DbType = DateTime), @p96='?' (DbType = Int32), @p94='?' (DbType = SByte), @p95='?' (DbType = DateTime), @p99='?' (DbType = Int32), @p97='?' (DbType = SByte), @p98='?' (DbType = DateTime), @p102='?' (DbType = Int32), @p100='?' (DbType = SByte), @p101='?' (DbType = DateTime), @p105='?' (DbType = Int32), @p103='?' (DbType = SByte), @p104='?' (DbType = DateTime), @p108='?' (DbType = Int32), @p106='?' (DbType = SByte), @p107='?' (DbType = DateTime), @p111='?' (DbType = Int32), @p109='?' (DbType = SByte), @p110='?' (DbType = DateTime), @p114='?' (DbType = Int32), @p112='?' (DbType = SByte), @p113='?' (DbType = DateTime), @p117='?' (DbType = Int32), @p115='?' (DbType = SByte), @p116='?' (DbType = DateTime), @p120='?' (DbType = Int32), @p118='?' (DbType = SByte), @p119='?' (DbType = DateTime), @p123='?' (DbType = Int32), @p121='?' (DbType = SByte), @p122='?' (DbType = DateTime), @p126='?' (DbType = Int32), @p124='?' (DbType = SByte), @p125='?' (DbType = DateTime), @p129='?' (DbType = Int32), @p127='?' (DbType = SByte), @p128='?' (DbType = DateTime), @p132='?' (DbType = Int32), @p130='?' (DbType = SByte), @p131='?' (DbType = DateTime), @p135='?' (DbType = Int32), @p133='?' (DbType = SByte), @p134='?' (DbType = DateTime), @p138='?' (DbType = Int32), @p136='?' (DbType = SByte), @p137='?' (DbType = DateTime), @p141='?' (DbType = Int32), @p139='?' (DbType = SByte), @p140='?' (DbType = DateTime), @p144='?' (DbType = Int32), @p142='?' (DbType = SByte), @p143='?' (DbType = DateTime), @p147='?' (DbType = Int32), @p145='?' (DbType = SByte), @p146='?' (DbType = DateTime), @p150='?' (DbType = Int32), @p148='?' (DbType = SByte), @p149='?' (DbType = DateTime), @p153='?' (DbType = Int32), @p151='?' (DbType = SByte), @p152='?' (DbType = DateTime)], CommandType='Text', CommandTimeout='30']\r\nINSERT INTO `assets_usage` (`asset_id`, `asset_usage`, `organisation_id`, `recorded_on`, `unit_id`)\r\nVALUES (@p0, @p1, @p2, @p3, @p4)\r\nRETURNING `id`;\r\nINSERT INTO `assets_usage` (`asset_id`, `asset_usage`, `organisation_id`, `recorded_on`, `unit_id`)\r\nVALUES (@p5, @p6, @p7, @p8, @p9)\r\nRETURNING `id`;\r\nINSERT INTO `assets_usage` (`asset_id`, `asset_usage`, `organisation_id`, `recorded_on`, `unit_id`)\r\nVALUES (@p10, @p11, @p12, @p13, @p14)\r\nRETURNING `id`;\r\nINSERT INTO `assets_usage` (`asset_id`, `asset_usage`, `organisation_id`, `recorded_on`, `unit_id`)\r\nVALUES (@p15, @p16, @p17, @p18, @p19)\r\nRETURNING `id`;\r\nINSERT INTO `assets_usage` (`asset_id`, `asset_usage`, `organisation_id`, `recorded_on`, `unit_id`)\r\nVALUES (@p20, @p21, @p22, @p23, @p24)\r\nRETURNING `id`;\r\nINSERT INTO `assets_usage` (`asset_id`, `asset_usage`, `organisation_id`, `recorded_on`, `unit_id`)\r\nVALUES (@p25, @p26, @p27, @p28, @p29)\r\nRETURNING `id`;\r\nINSERT INTO `assets_usage` (`asset_id`, `asset_usage`, `organisation_id`, `recorded_on`, `unit_id`)\r\nVALUES (@p30, @p31, @p32, @p33, @p34)\r\nRETURNING `id`;\r\nINSERT INTO `assets_usage` (`asset_id`, `asset_usage`, `organisation_id`, `recorded_on`, `unit_id`)\r\nVALUES (@p35, @p36, @p37, @p38, @p39)\r\nRETURNING `id`;\r\nINSERT INTO `assets_usage` (`asset_id`, `asset_usage`, `organisation_id`, `recorded_on`, `unit_id`)\r\nVALUES (@p40, @p41, @p42, @p43, @p44)\r\nRETURNING `id`;\r\nINSERT INTO `assets_usage` (`asset_id`, `asset_usage`, `organisation_id`, `recorded_on`, `unit_id`)\r\nVALUES (@p45, @p46, @p47, @p48, @p49)\r\nRETURNING `id`;\r\nINSERT INTO `assets_usage` (`asset_id`, `asset_usage`, `organisation_id`, `recorded_on`, `unit_id`)\r\nVALUES (@p50, @p51, @p52, @p53, @p54)\r\nRETURNING `id`;\r\nINSERT INTO `assets_usage` (`asset_id`, `asset_usage`, `organisation_id`, `recorded_on`, `unit_id`)\r\nVALUES (@p55, @p56, @p57, @p58, @p59)\r\nRETURNING `id`;\r\nINSERT INTO `assets_usage` (`asset_id`, `asset_usage`, `organisation_id`, `recorded_on`, `unit_id`)\r\nVALUES (@p60, @p61, @p62, @p63, @p64)\r\nRETURNING `id`;\r\nINSERT INTO `assets_usage` (`asset_id`, `asset_usage`, `organisation_id`, `recorded_on`, `unit_id`)\r\nVALUES (@p65, @p66, @p67, @p68, @p69)\r\nRETURNING `id`;\r\nUPDATE `iot_data_records` SET `is_processed` = @p70, `modified_on` = @p71\r\nWHERE `id` = @p72;\r\nSELECT ROW_COUNT();\r\n\r\nUPDATE `iot_data_records` SET `is_processed` = @p73, `modified_on` = @p74\r\nWHERE `id` = @p75;\r\nSELECT ROW_COUNT();\r\n\r\nUPDATE `iot_data_records` SET `is_processed` = @p76, `modified_on` = @p77\r\nWHERE `id` = @p78;\r\nSELECT ROW_COUNT();\r\n\r\nUPDATE `iot_data_records` SET `is_processed` = @p79, `modified_on` = @p80\r\nWHERE `id` = @p81;\r\nSELECT ROW_COUNT();\r\n\r\nUPDATE `iot_data_records` SET `is_processed` = @p82, `modified_on` = @p83\r\nWHERE `id` = @p84;\r\nSELECT ROW_COUNT();\r\n\r\nUPDATE `iot_data_records` SET `is_processed` = @p85, `modified_on` = @p86\r\nWHERE `id` = @p87;\r\nSELECT ROW_COUNT();\r\n\r\nUPDATE `iot_data_records` SET `is_processed` = @p88, `modified_on` = @p89\r\nWHERE `id` = @p90;\r\nSELECT ROW_COUNT();\r\n\r\nUPDATE `iot_data_records` SET `is_processed` = @p91, `modified_on` = @p92\r\nWHERE `id` = @p93;\r\nSELECT ROW_COUNT();\r\n\r\nUPDATE `iot_data_records` SET `is_processed` = @p94, `modified_on` = @p95\r\nWHERE `id` = @p96;\r\nSELECT ROW_COUNT();\r\n\r\nUPDATE `iot_data_records` SET `is_processed` = @p97, `modified_on` = @p98\r\nWHERE `id` = @p99;\r\nSELECT ROW_COUNT();\r\n\r\nUPDATE `iot_data_records` SET `is_processed` = @p100, `modified_on` = @p101\r\nWHERE `id` = @p102;\r\nSELECT ROW_COUNT();\r\n\r\nUPDATE `iot_data_records` SET `is_processed` = @p103, `modified_on` = @p104\r\nWHERE `id` = @p105;\r\nSELECT ROW_COUNT();\r\n\r\nUPDATE `iot_data_records` SET `is_processed` = @p106, `modified_on` = @p107\r\nWHERE `id` = @p108;\r\nSELECT ROW_COUNT();\r\n\r\nUPDATE `iot_data_records` SET `is_processed` = @p109, `modified_on` = @p110\r\nWHERE `id` = @p111;\r\nSELECT ROW_COUNT();\r\n\r\nUPDATE `iot_data_records` SET `is_processed` = @p112, `modified_on` = @p113\r\nWHERE `id` = @p114;\r\nSELECT ROW_COUNT();\r\n\r\nUPDATE `iot_data_records` SET `is_processed` = @p115, `modified_on` = @p116\r\nWHERE `id` = @p117;\r\nSELECT ROW_COUNT();\r\n\r\nUPDATE `iot_data_records` SET `is_processed` = @p118, `modified_on` = @p119\r\nWHERE `id` = @p120;\r\nSELECT ROW_COUNT();\r\n\r\nUPDATE `iot_data_records` SET `is_processed` = @p121, `modified_on` = @p122\r\nWHERE `id` = @p123;\r\nSELECT ROW_COUNT();\r\n\r\nUPDATE `iot_data_records` SET `is_processed` = @p124, `modified_on` = @p125\r\nWHERE `id` = @p126;\r\nSELECT ROW_COUNT();\r\n\r\nUPDATE `iot_data_records` SET `is_processed` = @p127, `modified_on` = @p128\r\nWHERE `id` = @p129;\r\nSELECT ROW_COUNT();\r\n\r\nUPDATE `iot_data_records` SET `is_processed` = @p130, `modified_on` = @p131\r\nWHERE `id` = @p132;\r\nSELECT ROW_COUNT();\r\n\r\nUPDATE `iot_data_records` SET `is_processed` = @p133, `modified_on` = @p134\r\nWHERE `id` = @p135;\r\nSELECT ROW_COUNT();\r\n\r\nUPDATE `iot_data_records` SET `is_processed` = @p136, `modified_on` = @p137\r\nWHERE `id` = @p138;\r\nSELECT ROW_COUNT();\r\n\r\nUPDATE `iot_data_records` SET `is_processed` = @p139, `modified_on` = @p140\r\nWHERE `id` = @p141;\r\nSELECT ROW_COUNT();\r\n\r\nUPDATE `iot_data_records` SET `is_processed` = @p142, `modified_on` = @p143\r\nWHERE `id` = @p144;\r\nSELECT ROW_COUNT();\r\n\r\nUPDATE `iot_data_records` SET `is_processed` = @p145, `modified_on` = @p146\r\nWHERE `id` = @p147;\r\nSELECT ROW_COUNT();\r\n\r\nUPDATE `iot_data_records` SET `is_processed` = @p148, `modified_on` = @p149\r\nWHERE `id` = @p150;\r\nSELECT ROW_COUNT();\r\n\r\nUPDATE `iot_data_records` SET `is_processed` = @p151, `modified_on` = @p152\r\nWHERE `id` = @p153;\r\nSELECT ROW_COUNT();"}

{"Timestamp":"2025-08-26T08:19:56.6573293+00:00","Level":"Information","SourceContext":"Microsoft.EntityFrameworkCore.Database.Command","Data":{"EventId":119789823},"Message":"Executed DbCommand (1ms) [Parameters=[@p2='?' (DbType = Int32), @p0='?' (DbType = SByte), @p1='?' (DbType = DateTime), @p5='?' (DbType = Int32), @p3='?' (DbType = SByte), @p4='?' (DbType = DateTime), @p8='?' (DbType = Int32), @p6='?' (DbType = SByte), @p7='?' (DbType = DateTime), @p11='?' (DbType = Int32), @p9='?' (DbType = SByte), @p10='?' (DbType = DateTime), @p14='?' (DbType = Int32), @p12='?' (DbType = SByte), @p13='?' (DbType = DateTime), @p17='?' (DbType = Int32), @p15='?' (DbType = SByte), @p16='?' (DbType = DateTime), @p20='?' (DbType = Int32), @p18='?' (DbType = SByte), @p19='?' (DbType = DateTime), @p23='?' (DbType = Int32), @p21='?' (DbType = SByte), @p22='?' (DbType = DateTime), @p26='?' (DbType = Int32), @p24='?' (DbType = SByte), @p25='?' (DbType = DateTime), @p29='?' (DbType = Int32), @p27='?' (DbType = SByte), @p28='?' (DbType = DateTime), @p32='?' (DbType = Int32), @p30='?' (DbType = SByte), @p31='?' (DbType = DateTime)], CommandType='Text', CommandTimeout='30']\r\nUPDATE `iot_data_records` SET `is_processed` = @p0, `modified_on` = @p1\r\nWHERE `id` = @p2;\r\nSELECT ROW_COUNT();\r\n\r\nUPDATE `iot_data_records` SET `is_processed` = @p3, `modified_on` = @p4\r\nWHERE `id` = @p5;\r\nSELECT ROW_COUNT();\r\n\r\nUPDATE `iot_data_records` SET `is_processed` = @p6, `modified_on` = @p7\r\nWHERE `id` = @p8;\r\nSELECT ROW_COUNT();\r\n\r\nUPDATE `iot_data_records` SET `is_processed` = @p9, `modified_on` = @p10\r\nWHERE `id` = @p11;\r\nSELECT ROW_COUNT();\r\n\r\nUPDATE `iot_data_records` SET `is_processed` = @p12, `modified_on` = @p13\r\nWHERE `id` = @p14;\r\nSELECT ROW_COUNT();\r\n\r\nUPDATE `iot_data_records` SET `is_processed` = @p15, `modified_on` = @p16\r\nWHERE `id` = @p17;\r\nSELECT ROW_COUNT();\r\n\r\nUPDATE `iot_data_records` SET `is_processed` = @p18, `modified_on` = @p19\r\nWHERE `id` = @p20;\r\nSELECT ROW_COUNT();\r\n\r\nUPDATE `iot_data_records` SET `is_processed` = @p21, `modified_on` = @p22\r\nWHERE `id` = @p23;\r\nSELECT ROW_COUNT();\r\n\r\nUPDATE `iot_data_records` SET `is_processed` = @p24, `modified_on` = @p25\r\nWHERE `id` = @p26;\r\nSELECT ROW_COUNT();\r\n\r\nUPDATE `iot_data_records` SET `is_processed` = @p27, `modified_on` = @p28\r\nWHERE `id` = @p29;\r\nSELECT ROW_COUNT();\r\n\r\nUPDATE `iot_data_records` SET `is_processed` = @p30, `modified_on` = @p31\r\nWHERE `id` = @p32;\r\nSELECT ROW_COUNT();"}

{"Timestamp":"2025-08-26T08:19:56.6943631+00:00","Level":"Information","SourceContext":"Microsoft.EntityFrameworkCore.Database.Command","Data":{"EventId":119789823},"Message":"Executed DbCommand (5ms) [Parameters=[@p8='?' (DbType = Int32), @p0='?' (DbType = DateTime), @p1='?' (Size = 4000), @p2='?' (DbType = Int32), @p3='?' (DbType = Int32), @p4='?' (DbType = SByte), @p5='?' (DbType = DateTime), @p6='?' (DbType = Int32), @p7='?' (DbType = SByte), @p17='?' (DbType = Int32), @p9='?' (DbType = DateTime), @p10='?' (Size = 4000), @p11='?' (DbType = Int32), @p12='?' (DbType = Int32), @p13='?' (DbType = SByte), @p14='?' (DbType = DateTime), @p15='?' (DbType = Int32), @p16='?' (DbType = SByte), @p26='?' (DbType = Int32), @p18='?' (DbType = DateTime), @p19='?' (Size = 4000), @p20='?' (DbType = Int32), @p21='?' (DbType = Int32), @p22='?' (DbType = SByte), @p23='?' (DbType = DateTime), @p24='?' (DbType = Int32), @p25='?' (DbType = SByte), @p35='?' (DbType = Int32), @p27='?' (DbType = DateTime), @p28='?' (Size = 4000), @p29='?' (DbType = Int32), @p30='?' (DbType = Int32), @p31='?' (DbType = SByte), @p32='?' (DbType = DateTime), @p33='?' (DbType = Int32), @p34='?' (DbType = SByte), @p44='?' (DbType = Int32), @p36='?' (DbType = DateTime), @p37='?' (Size = 4000), @p38='?' (DbType = Int32), @p39='?' (DbType = Int32), @p40='?' (DbType = SByte), @p41='?' (DbType = DateTime), @p42='?' (DbType = Int32), @p43='?' (DbType = SByte), @p53='?' (DbType = Int32), @p45='?' (DbType = DateTime), @p46='?' (Size = 4000), @p47='?' (DbType = Int32), @p48='?' (DbType = Int32), @p49='?' (DbType = SByte), @p50='?' (DbType = DateTime), @p51='?' (DbType = Int32), @p52='?' (DbType = SByte), @p62='?' (DbType = Int32), @p54='?' (DbType = DateTime), @p55='?' (Size = 4000), @p56='?' (DbType = Int32), @p57='?' (DbType = Int32), @p58='?' (DbType = SByte), @p59='?' (DbType = DateTime), @p60='?' (DbType = Int32), @p61='?' (DbType = SByte), @p71='?' (DbType = Int32), @p63='?' (DbType = DateTime), @p64='?' (Size = 4000), @p65='?' (DbType = Int32), @p66='?' (DbType = Int32), @p67='?' (DbType = SByte), @p68='?' (DbType = DateTime), @p69='?' (DbType = Int32), @p70='?' (DbType = SByte), @p80='?' (DbType = Int32), @p72='?' (DbType = DateTime), @p73='?' (Size = 4000), @p74='?' (DbType = Int32), @p75='?' (DbType = Int32), @p76='?' (DbType = SByte), @p77='?' (DbType = DateTime), @p78='?' (DbType = Int32), @p79='?' (DbType = SByte), @p89='?' (DbType = Int32), @p81='?' (DbType = DateTime), @p82='?' (Size = 4000), @p83='?' (DbType = Int32), @p84='?' (DbType = Int32), @p85='?' (DbType = SByte), @p86='?' (DbType = DateTime), @p87='?' (DbType = Int32), @p88='?' (DbType = SByte), @p98='?' (DbType = Int32), @p90='?' (DbType = DateTime), @p91='?' (Size = 4000), @p92='?' (DbType = Int32), @p93='?' (DbType = Int32), @p94='?' (DbType = SByte), @p95='?' (DbType = DateTime), @p96='?' (DbType = Int32), @p97='?' (DbType = SByte), @p107='?' (DbType = Int32), @p99='?' (DbType = DateTime), @p100='?' (Size = 4000), @p101='?' (DbType = Int32), @p102='?' (DbType = Int32), @p103='?' (DbType = SByte), @p104='?' (DbType = DateTime), @p105='?' (DbType = Int32), @p106='?' (DbType = SByte), @p116='?' (DbType = Int32), @p108='?' (DbType = DateTime), @p109='?' (Size = 4000), @p110='?' (DbType = Int32), @p111='?' (DbType = Int32), @p112='?' (DbType = SByte), @p113='?' (DbType = DateTime), @p114='?' (DbType = Int32), @p115='?' (DbType = SByte), @p125='?' (DbType = Int32), @p117='?' (DbType = DateTime), @p118='?' (Size = 4000), @p119='?' (DbType = Int32), @p120='?' (DbType = Int32), @p121='?' (DbType = SByte), @p122='?' (DbType = DateTime), @p123='?' (DbType = Int32), @p124='?' (DbType = SByte), @p134='?' (DbType = Int32), @p126='?' (DbType = DateTime), @p127='?' (Size = 4000), @p128='?' (DbType = Int32), @p129='?' (DbType = Int32), @p130='?' (DbType = SByte), @p131='?' (DbType = DateTime), @p132='?' (DbType = Int32), @p133='?' (DbType = SByte), @p143='?' (DbType = Int32), @p135='?' (DbType = DateTime), @p136='?' (Size = 4000), @p137='?' (DbType = Int32), @p138='?' (DbType = Int32), @p139='?' (DbType = SByte), @p140='?' (DbType = DateTime), @p141='?' (DbType = Int32), @p142='?' (DbType = SByte), @p152='?' (DbType = Int32), @p144='?' (DbType = DateTime), @p145='?' (Size = 4000), @p146='?' (DbType = Int32), @p147='?' (DbType = Int32), @p148='?' (DbType = SByte), @p149='?' (DbType = DateTime), @p150='?' (DbType = Int32), @p151='?' (DbType = SByte), @p161='?' (DbType = Int32), @p153='?' (DbType = DateTime), @p154='?' (Size = 4000), @p155='?' (DbType = Int32), @p156='?' (DbType = Int32), @p157='?' (DbType = SByte), @p158='?' (DbType = DateTime), @p159='?' (DbType = Int32), @p160='?' (DbType = SByte), @p170='?' (DbType = Int32), @p162='?' (DbType = DateTime), @p163='?' (Size = 4000), @p164='?' (DbType = Int32), @p165='?' (DbType = Int32), @p166='?' (DbType = SByte), @p167='?' (DbType = DateTime), @p168='?' (DbType = Int32), @p169='?' (DbType = SByte), @p179='?' (DbType = Int32), @p171='?' (DbType = DateTime), @p172='?' (Size = 4000), @p173='?' (DbType = Int32), @p174='?' (DbType = Int32), @p175='?' (DbType = SByte), @p176='?' (DbType = DateTime), @p177='?' (DbType = Int32), @p178='?' (DbType = SByte), @p188='?' (DbType = Int32), @p180='?' (DbType = DateTime), @p181='?' (Size = 4000), @p182='?' (DbType = Int32), @p183='?' (DbType = Int32), @p184='?' (DbType = SByte), @p185='?' (DbType = DateTime), @p186='?' (DbType = Int32), @p187='?' (DbType = SByte), @p197='?' (DbType = Int32), @p189='?' (DbType = DateTime), @p190='?' (Size = 4000), @p191='?' (DbType = Int32), @p192='?' (DbType = Int32), @p193='?' (DbType = SByte), @p194='?' (DbType = DateTime), @p195='?' (DbType = Int32), @p196='?' (DbType = SByte), @p206='?' (DbType = Int32), @p198='?' (DbType = DateTime), @p199='?' (Size = 4000), @p200='?' (DbType = Int32), @p201='?' (DbType = Int32), @p202='?' (DbType = SByte), @p203='?' (DbType = DateTime), @p204='?' (DbType = Int32), @p205='?' (DbType = SByte), @p215='?' (DbType = Int32), @p207='?' (DbType = DateTime), @p208='?' (Size = 4000), @p209='?' (DbType = Int32), @p210='?' (DbType = Int32), @p211='?' (DbType = SByte), @p212='?' (DbType = DateTime), @p213='?' (DbType = Int32), @p214='?' (DbType = SByte), @p224='?' (DbType = Int32), @p216='?' (DbType = DateTime), @p217='?' (Size = 4000), @p218='?' (DbType = Int32), @p219='?' (DbType = Int32), @p220='?' (DbType = SByte), @p221='?' (DbType = DateTime), @p222='?' (DbType = Int32), @p223='?' (DbType = SByte), @p233='?' (DbType = Int32), @p225='?' (DbType = DateTime), @p226='?' (Size = 4000), @p227='?' (DbType = Int32), @p228='?' (DbType = Int32), @p229='?' (DbType = SByte), @p230='?' (DbType = DateTime), @p231='?' (DbType = Int32), @p232='?' (DbType = SByte), @p242='?' (DbType = Int32), @p234='?' (DbType = DateTime), @p235='?' (Size = 4000), @p236='?' (DbType = Int32), @p237='?' (DbType = Int32), @p238='?' (DbType = SByte), @p239='?' (DbType = DateTime), @p240='?' (DbType = Int32), @p241='?' (DbType = SByte), @p251='?' (DbType = Int32), @p243='?' (DbType = DateTime), @p244='?' (Size = 4000), @p245='?' (DbType = Int32), @p246='?' (DbType = Int32), @p247='?' (DbType = SByte), @p248='?' (DbType = DateTime), @p249='?' (DbType = Int32), @p250='?' (DbType = SByte), @p260='?' (DbType = Int32), @p252='?' (DbType = DateTime), @p253='?' (Size = 4000), @p254='?' (DbType = Int32), @p255='?' (DbType = Int32), @p256='?' (DbType = SByte), @p257='?' (DbType = DateTime), @p258='?' (DbType = Int32), @p259='?' (DbType = SByte), @p269='?' (DbType = Int32), @p261='?' (DbType = DateTime), @p262='?' (Size = 4000), @p263='?' (DbType = Int32), @p264='?' (DbType = Int32), @p265='?' (DbType = SByte), @p266='?' (DbType = DateTime), @p267='?' (DbType = Int32), @p268='?' (DbType = SByte), @p278='?' (DbType = Int32), @p270='?' (DbType = DateTime), @p271='?' (Size = 4000), @p272='?' (DbType = Int32), @p273='?' (DbType = Int32), @p274='?' (DbType = SByte), @p275='?' (DbType = DateTime), @p276='?' (DbType = Int32), @p277='?' (DbType = SByte), @p287='?' (DbType = Int32), @p279='?' (DbType = DateTime), @p280='?' (Size = 4000), @p281='?' (DbType = Int32), @p282='?' (DbType = Int32), @p283='?' (DbType = SByte), @p284='?' (DbType = DateTime), @p285='?' (DbType = Int32), @p286='?' (DbType = SByte), @p296='?' (DbType = Int32), @p288='?' (DbType = DateTime), @p289='?' (Size = 4000), @p290='?' (DbType = Int32), @p291='?' (DbType = Int32), @p292='?' (DbType = SByte), @p293='?' (DbType = DateTime), @p294='?' (DbType = Int32), @p295='?' (DbType = SByte), @p305='?' (DbType = Int32), @p297='?' (DbType = DateTime), @p298='?' (Size = 4000), @p299='?' (DbType = Int32), @p300='?' (DbType = Int32), @p301='?' (DbType = SByte), @p302='?' (DbType = DateTime), @p303='?' (DbType = Int32), @p304='?' (DbType = SByte), @p314='?' (DbType = Int32), @p306='?' (DbType = DateTime), @p307='?' (Size = 4000), @p308='?' (DbType = Int32), @p309='?' (DbType = Int32), @p310='?' (DbType = SByte), @p311='?' (DbType = DateTime), @p312='?' (DbType = Int32), @p313='?' (DbType = SByte), @p323='?' (DbType = Int32), @p315='?' (DbType = DateTime), @p316='?' (Size = 4000), @p317='?' (DbType = Int32), @p318='?' (DbType = Int32), @p319='?' (DbType = SByte), @p320='?' (DbType = DateTime), @p321='?' (DbType = Int32), @p322='?' (DbType = SByte), @p332='?' (DbType = Int32), @p324='?' (DbType = DateTime), @p325='?' (Size = 4000), @p326='?' (DbType = Int32), @p327='?' (DbType = Int32), @p328='?' (DbType = SByte), @p329='?' (DbType = DateTime), @p330='?' (DbType = Int32), @p331='?' (DbType = SByte), @p341='?' (DbType = Int32), @p333='?' (DbType = DateTime), @p334='?' (Size = 4000), @p335='?' (DbType = Int32), @p336='?' (DbType = Int32), @p337='?' (DbType = SByte), @p338='?' (DbType = DateTime), @p339='?' (DbType = Int32), @p340='?' (DbType = SByte), @p350='?' (DbType = Int32), @p342='?' (DbType = DateTime), @p343='?' (Size = 4000), @p344='?' (DbType = Int32), @p345='?' (DbType = Int32), @p346='?' (DbType = SByte), @p347='?' (DbType = DateTime), @p348='?' (DbType = Int32), @p349='?' (DbType = SByte)], CommandType='Text', CommandTimeout='30']\r\nUPDATE `iot_data_records` SET `created_on` = @p0, `data` = @p1, `device_id` = @p2, `device_type` = @p3, `is_processed` = @p4, `modified_on` = @p5, `organisation_id` = @p6, `status` = @p7\r\nWHERE `id` = @p8;\r\nSELECT ROW_COUNT();\r\n\r\nUPDATE `iot_data_records` SET `created_on` = @p9, `data` = @p10, `device_id` = @p11, `device_type` = @p12, `is_processed` = @p13, `modified_on` = @p14, `organisation_id` = @p15, `status` = @p16\r\nWHERE `id` = @p17;\r\nSELECT ROW_COUNT();\r\n\r\nUPDATE `iot_data_records` SET `created_on` = @p18, `data` = @p19, `device_id` = @p20, `device_type` = @p21, `is_processed` = @p22, `modified_on` = @p23, `organisation_id` = @p24, `status` = @p25\r\nWHERE `id` = @p26;\r\nSELECT ROW_COUNT();\r\n\r\nUPDATE `iot_data_records` SET `created_on` = @p27, `data` = @p28, `device_id` = @p29, `device_type` = @p30, `is_processed` = @p31, `modified_on` = @p32, `organisation_id` = @p33, `status` = @p34\r\nWHERE `id` = @p35;\r\nSELECT ROW_COUNT();\r\n\r\nUPDATE `iot_data_records` SET `created_on` = @p36, `data` = @p37, `device_id` = @p38, `device_type` = @p39, `is_processed` = @p40, `modified_on` = @p41, `organisation_id` = @p42, `status` = @p43\r\nWHERE `id` = @p44;\r\nSELECT ROW_COUNT();\r\n\r\nUPDATE `iot_data_records` SET `created_on` = @p45, `data` = @p46, `device_id` = @p47, `device_type` = @p48, `is_processed` = @p49, `modified_on` = @p50, `organisation_id` = @p51, `status` = @p52\r\nWHERE `id` = @p53;\r\nSELECT ROW_COUNT();\r\n\r\nUPDATE `iot_data_records` SET `created_on` = @p54, `data` = @p55, `device_id` = @p56, `device_type` = @p57, `is_processed` = @p58, `modified_on` = @p59, `organisation_id` = @p60, `status` = @p61\r\nWHERE `id` = @p62;\r\nSELECT ROW_COUNT();\r\n\r\nUPDATE `iot_data_records` SET `created_on` = @p63, `data` = @p64, `device_id` = @p65, `device_type` = @p66, `is_processed` = @p67, `modified_on` = @p68, `organisation_id` = @p69, `status` = @p70\r\nWHERE `id` = @p71;\r\nSELECT ROW_COUNT();\r\n\r\nUPDATE `iot_data_records` SET `created_on` = @p72, `data` = @p73, `device_id` = @p74, `device_type` = @p75, `is_processed` = @p76, `modified_on` = @p77, `organisation_id` = @p78, `status` = @p79\r\nWHERE `id` = @p80;\r\nSELECT ROW_COUNT();\r\n\r\nUPDATE `iot_data_records` SET `created_on` = @p81, `data` = @p82, `device_id` = @p83, `device_type` = @p84, `is_processed` = @p85, `modified_on` = @p86, `organisation_id` = @p87, `status` = @p88\r\nWHERE `id` = @p89;\r\nSELECT ROW_COUNT();\r\n\r\nUPDATE `iot_data_records` SET `created_on` = @p90, `data` = @p91, `device_id` = @p92, `device_type` = @p93, `is_processed` = @p94, `modified_on` = @p95, `organisation_id` = @p96, `status` = @p97\r\nWHERE `id` = @p98;\r\nSELECT ROW_COUNT();\r\n\r\nUPDATE `iot_data_records` SET `created_on` = @p99, `data` = @p100, `device_id` = @p101, `device_type` = @p102, `is_processed` = @p103, `modified_on` = @p104, `organisation_id` = @p105, `status` = @p106\r\nWHERE `id` = @p107;\r\nSELECT ROW_COUNT();\r\n\r\nUPDATE `iot_data_records` SET `created_on` = @p108, `data` = @p109, `device_id` = @p110, `device_type` = @p111, `is_processed` = @p112, `modified_on` = @p113, `organisation_id` = @p114, `status` = @p115\r\nWHERE `id` = @p116;\r\nSELECT ROW_COUNT();\r\n\r\nUPDATE `iot_data_records` SET `created_on` = @p117, `data` = @p118, `device_id` = @p119, `device_type` = @p120, `is_processed` = @p121, `modified_on` = @p122, `organisation_id` = @p123, `status` = @p124\r\nWHERE `id` = @p125;\r\nSELECT ROW_COUNT();\r\n\r\nUPDATE `iot_data_records` SET `created_on` = @p126, `data` = @p127, `device_id` = @p128, `device_type` = @p129, `is_processed` = @p130, `modified_on` = @p131, `organisation_id` = @p132, `status` = @p133\r\nWHERE `id` = @p134;\r\nSELECT ROW_COUNT();\r\n\r\nUPDATE `iot_data_records` SET `created_on` = @p135, `data` = @p136, `device_id` = @p137, `device_type` = @p138, `is_processed` = @p139, `modified_on` = @p140, `organisation_id` = @p141, `status` = @p142\r\nWHERE `id` = @p143;\r\nSELECT ROW_COUNT();\r\n\r\nUPDATE `iot_data_records` SET `created_on` = @p144, `data` = @p145, `device_id` = @p146, `device_type` = @p147, `is_processed` = @p148, `modified_on` = @p149, `organisation_id` = @p150, `status` = @p151\r\nWHERE `id` = @p152;\r\nSELECT ROW_COUNT();\r\n\r\nUPDATE `iot_data_records` SET `created_on` = @p153, `data` = @p154, `device_id` = @p155, `device_type` = @p156, `is_processed` = @p157, `modified_on` = @p158, `organisation_id` = @p159, `status` = @p160\r\nWHERE `id` = @p161;\r\nSELECT ROW_COUNT();\r\n\r\nUPDATE `iot_data_records` SET `created_on` = @p162, `data` = @p163, `device_id` = @p164, `device_type` = @p165, `is_processed` = @p166, `modified_on` = @p167, `organisation_id` = @p168, `status` = @p169\r\nWHERE `id` = @p170;\r\nSELECT ROW_COUNT();\r\n\r\nUPDATE `iot_data_records` SET `created_on` = @p171, `data` = @p172, `device_id` = @p173, `device_type` = @p174, `is_processed` = @p175, `modified_on` = @p176, `organisation_id` = @p177, `status` = @p178\r\nWHERE `id` = @p179;\r\nSELECT ROW_COUNT();\r\n\r\nUPDATE `iot_data_records` SET `created_on` = @p180, `data` = @p181, `device_id` = @p182, `device_type` = @p183, `is_processed` = @p184, `modified_on` = @p185, `organisation_id` = @p186, `status` = @p187\r\nWHERE `id` = @p188;\r\nSELECT ROW_COUNT();\r\n\r\nUPDATE `iot_data_records` SET `created_on` = @p189, `data` = @p190, `device_id` = @p191, `device_type` = @p192, `is_processed` = @p193, `modified_on` = @p194, `organisation_id` = @p195, `status` = @p196\r\nWHERE `id` = @p197;\r\nSELECT ROW_COUNT();\r\n\r\nUPDATE `iot_data_records` SET `created_on` = @p198, `data` = @p199, `device_id` = @p200, `device_type` = @p201, `is_processed` = @p202, `modified_on` = @p203, `organisation_id` = @p204, `status` = @p205\r\nWHERE `id` = @p206;\r\nSELECT ROW_COUNT();\r\n\r\nUPDATE `iot_data_records` SET `created_on` = @p207, `data` = @p208, `device_id` = @p209, `device_type` = @p210, `is_processed` = @p211, `modified_on` = @p212, `organisation_id` = @p213, `status` = @p214\r\nWHERE `id` = @p215;\r\nSELECT ROW_COUNT();\r\n\r\nUPDATE `iot_data_records` SET `created_on` = @p216, `data` = @p217, `device_id` = @p218, `device_type` = @p219, `is_processed` = @p220, `modified_on` = @p221, `organisation_id` = @p222, `status` = @p223\r\nWHERE `id` = @p224;\r\nSELECT ROW_COUNT();\r\n\r\nUPDATE `iot_data_records` SET `created_on` = @p225, `data` = @p226, `device_id` = @p227, `device_type` = @p228, `is_processed` = @p229, `modified_on` = @p230, `organisation_id` = @p231, `status` = @p232\r\nWHERE `id` = @p233;\r\nSELECT ROW_COUNT();\r\n\r\nUPDATE `iot_data_records` SET `created_on` = @p234, `data` = @p235, `device_id` = @p236, `device_type` = @p237, `is_processed` = @p238, `modified_on` = @p239, `organisation_id` = @p240, `status` = @p241\r\nWHERE `id` = @p242;\r\nSELECT ROW_COUNT();\r\n\r\nUPDATE `iot_data_records` SET `created_on` = @p243, `data` = @p244, `device_id` = @p245, `device_type` = @p246, `is_processed` = @p247, `modified_on` = @p248, `organisation_id` = @p249, `status` = @p250\r\nWHERE `id` = @p251;\r\nSELECT ROW_COUNT();\r\n\r\nUPDATE `iot_data_records` SET `created_on` = @p252, `data` = @p253, `device_id` = @p254, `device_type` = @p255, `is_processed` = @p256, `modified_on` = @p257, `organisation_id` = @p258, `status` = @p259\r\nWHERE `id` = @p260;\r\nSELECT ROW_COUNT();\r\n\r\nUPDATE `iot_data_records` SET `created_on` = @p261, `data` = @p262, `device_id` = @p263, `device_type` = @p264, `is_processed` = @p265, `modified_on` = @p266, `organisation_id` = @p267, `status` = @p268\r\nWHERE `id` = @p269;\r\nSELECT ROW_COUNT();\r\n\r\nUPDATE `iot_data_records` SET `created_on` = @p270, `data` = @p271, `device_id` = @p272, `device_type` = @p273, `is_processed` = @p274, `modified_on` = @p275, `organisation_id` = @p276, `status` = @p277\r\nWHERE `id` = @p278;\r\nSELECT ROW_COUNT();\r\n\r\nUPDATE `iot_data_records` SET `created_on` = @p279, `data` = @p280, `device_id` = @p281, `device_type` = @p282, `is_processed` = @p283, `modified_on` = @p284, `organisation_id` = @p285, `status` = @p286\r\nWHERE `id` = @p287;\r\nSELECT ROW_COUNT();\r\n\r\nUPDATE `iot_data_records` SET `created_on` = @p288, `data` = @p289, `device_id` = @p290, `device_type` = @p291, `is_processed` = @p292, `modified_on` = @p293, `organisation_id` = @p294, `status` = @p295\r\nWHERE `id` = @p296;\r\nSELECT ROW_COUNT();\r\n\r\nUPDATE `iot_data_records` SET `created_on` = @p297, `data` = @p298, `device_id` = @p299, `device_type` = @p300, `is_processed` = @p301, `modified_on` = @p302, `organisation_id` = @p303, `status` = @p304\r\nWHERE `id` = @p305;\r\nSELECT ROW_COUNT();\r\n\r\nUPDATE `iot_data_records` SET `created_on` = @p306, `data` = @p307, `device_id` = @p308, `device_type` = @p309, `is_processed` = @p310, `modified_on` = @p311, `organisation_id` = @p312, `status` = @p313\r\nWHERE `id` = @p314;\r\nSELECT ROW_COUNT();\r\n\r\nUPDATE `iot_data_records` SET `created_on` = @p315, `data` = @p316, `device_id` = @p317, `device_type` = @p318, `is_processed` = @p319, `modified_on` = @p320, `organisation_id` = @p321, `status` = @p322\r\nWHERE `id` = @p323;\r\nSELECT ROW_COUNT();\r\n\r\nUPDATE `iot_data_records` SET `created_on` = @p324, `data` = @p325, `device_id` = @p326, `device_type` = @p327, `is_processed` = @p328, `modified_on` = @p329, `organisation_id` = @p330, `status` = @p331\r\nWHERE `id` = @p332;\r\nSELECT ROW_COUNT();\r\n\r\nUPDATE `iot_data_records` SET `created_on` = @p333, `data` = @p334, `device_id` = @p335, `device_type` = @p336, `is_processed` = @p337, `modified_on` = @p338, `organisation_id` = @p339, `status` = @p340\r\nWHERE `id` = @p341;\r\nSELECT ROW_COUNT();\r\n\r\nUPDATE `iot_data_records` SET `created_on` = @p342, `data` = @p343, `device_id` = @p344, `device_type` = @p345, `is_processed` = @p346, `modified_on` = @p347, `organisation_id` = @p348, `status` = @p349\r\nWHERE `id` = @p350;\r\nSELECT ROW_COUNT();"}

{"Timestamp":"2025-08-26T08:19:56.7082005+00:00","Level":"Information","SourceContext":"OQSHA.IoT.Data.Aggregator.Jobs.MapMyIndiaDrivesDataAggregationJob","Data":{"EventId":3758316828},"Message":"MMI_DRIVE_DATA_AGGREGATOR - Database update successful the transaction has been committed"}

{"Timestamp":"2025-08-26T08:19:56.7117957+00:00","Level":"Information","SourceContext":"OQSHA.IoT.Data.Aggregator.Workers.MapMyIndiaDrivesDataAggregator","Data":{"EventId":1372110093},"Message":"MMI_DRIVE_DATA_AGGREGATOR - completed execution of the Map My India device's drives data aggregation"}

{"Timestamp":"2025-08-26T08:20:20.6829382+00:00","Level":"Information","SourceContext":"Microsoft.Hosting.Lifetime","Data":{"EventId":2431986744},"Message":"Application is shutting down..."}

