Registering Background Task - Map My India Drives Data Aggregator


Hosting failed to start

System.FormatException: The input string '-15.84' was not in a correct format.
   at System.Number.ThrowFormatException[TChar](ReadOnlySpan`1 value)
   at System.Convert.ToInt32(String value)
   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
   at Microsoft.Extensions.Hosting.Internal.Host.<StartAsync>b__15_1(IHostedService service, CancellationToken token)
   at Microsoft.Extensions.Hosting.Internal.Host.ForeachService[T](IEnumerable`1 services, CancellationToken token, Boolean concurrent, Boolean abortOnFirstException, List`1 exceptions, Func`3 operation)


Registered Background Task - Map My India Drives Data Aggregator


Application started. Press Ctrl+C to shut down.


MMI_DRIVE_DATA_AGGREGATOR - Initiating the Map My India device's drives data aggregation


Hosting environment: Production


Content root path: D:\App-Data\iis\api.incidentreporter365.com\Apps\OQSHA.IoT.Data.Aggregator


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


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.


Executed DbCommand (62ms) [Parameters=[@__fromDate_0='?' (DbType = DateTime), @__toDate_1='?' (DbType = DateTime), @__isProcessed_2='?' (DbType = SByte)], CommandType='Text', CommandTimeout='30']
SELECT `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`
FROM `iot_data_records` AS `i`
LEFT JOIN (
    SELECT `a`.`asset_id`, `a`.`device_id`
    FROM `asset_iot_devices` AS `a`
    WHERE `a`.`status` = 1
) AS `t` ON `i`.`device_id` = `t`.`device_id`
WHERE (((`i`.`created_on` >= @__fromDate_0) AND (`i`.`created_on` <= @__toDate_1)) AND (`i`.`is_processed` = @__isProcessed_2)) AND (`i`.`status` = 1)
ORDER BY `i`.`created_on`


MMI_DRIVE_DATA_AGGREGATOR - Found a total of 39 unprocessed IOT data records


Executed DbCommand (6ms) [Parameters=[@__ToLower_1='?' (Size = 4000)], CommandType='Text', CommandTimeout='30']
SELECT `u`.`id`, `u`.`created_on`, `u`.`modified_on`, `u`.`organisation_id`, `u`.`status`, `u`.`unit`
FROM `usage_units` AS `u`
WHERE ((`u`.`organisation_id` = 250) AND (LOWER(TRIM(`u`.`unit`)) = @__ToLower_1)) AND (`u`.`status` = 1)


Executed DbCommand (1ms) [Parameters=[@__ToLower_1='?' (Size = 4000)], CommandType='Text', CommandTimeout='30']
SELECT `u`.`id`, `u`.`created_on`, `u`.`modified_on`, `u`.`organisation_id`, `u`.`status`, `u`.`unit`
FROM `usage_units` AS `u`
WHERE ((`u`.`organisation_id` = 250) AND (LOWER(TRIM(`u`.`unit`)) = @__ToLower_1)) AND (`u`.`status` = 1)


Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT `a`.`asset_id`, `a`.`id`, `a`.`asset_usage`, `a`.`organisation_id`, `a`.`recorded_on`, `a`.`unit_id`
FROM `assets_usage` AS `a`
WHERE `a`.`asset_id` IN (489, 490) AND (`a`.`unit_id` = 252)
ORDER BY `a`.`asset_id`


Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT `a`.`asset_id`, `a`.`id`, `a`.`asset_usage`, `a`.`organisation_id`, `a`.`recorded_on`, `a`.`unit_id`
FROM `assets_usage` AS `a`
WHERE `a`.`asset_id` IN (489, 490) AND (`a`.`unit_id` = 253)
ORDER BY `a`.`asset_id`


MMI_DRIVE_DATA_AGGREGATOR - Successfully retreived all the latest usage record values for the unprocessed IOT devices and their assets


MMI_DRIVE_DATA_AGGREGATOR - Started processing the MMI drives data


MMI_DRIVE_DATA_AGGREGATOR - Completed processing the MMI drives data


MMI_DRIVE_DATA_AGGREGATOR - Inserting 98 asset usage records to the database ...


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


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


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']
INSERT INTO `assets_usage` (`asset_id`, `asset_usage`, `organisation_id`, `recorded_on`, `unit_id`)
VALUES (@p0, @p1, @p2, @p3, @p4)
RETURNING `id`;
INSERT INTO `assets_usage` (`asset_id`, `asset_usage`, `organisation_id`, `recorded_on`, `unit_id`)
VALUES (@p5, @p6, @p7, @p8, @p9)
RETURNING `id`;
INSERT INTO `assets_usage` (`asset_id`, `asset_usage`, `organisation_id`, `recorded_on`, `unit_id`)
VALUES (@p10, @p11, @p12, @p13, @p14)
RETURNING `id`;
INSERT INTO `assets_usage` (`asset_id`, `asset_usage`, `organisation_id`, `recorded_on`, `unit_id`)
VALUES (@p15, @p16, @p17, @p18, @p19)
RETURNING `id`;
INSERT INTO `assets_usage` (`asset_id`, `asset_usage`, `organisation_id`, `recorded_on`, `unit_id`)
VALUES (@p20, @p21, @p22, @p23, @p24)
RETURNING `id`;
INSERT INTO `assets_usage` (`asset_id`, `asset_usage`, `organisation_id`, `recorded_on`, `unit_id`)
VALUES (@p25, @p26, @p27, @p28, @p29)
RETURNING `id`;
INSERT INTO `assets_usage` (`asset_id`, `asset_usage`, `organisation_id`, `recorded_on`, `unit_id`)
VALUES (@p30, @p31, @p32, @p33, @p34)
RETURNING `id`;
INSERT INTO `assets_usage` (`asset_id`, `asset_usage`, `organisation_id`, `recorded_on`, `unit_id`)
VALUES (@p35, @p36, @p37, @p38, @p39)
RETURNING `id`;
INSERT INTO `assets_usage` (`asset_id`, `asset_usage`, `organisation_id`, `recorded_on`, `unit_id`)
VALUES (@p40, @p41, @p42, @p43, @p44)
RETURNING `id`;
INSERT INTO `assets_usage` (`asset_id`, `asset_usage`, `organisation_id`, `recorded_on`, `unit_id`)
VALUES (@p45, @p46, @p47, @p48, @p49)
RETURNING `id`;
INSERT INTO `assets_usage` (`asset_id`, `asset_usage`, `organisation_id`, `recorded_on`, `unit_id`)
VALUES (@p50, @p51, @p52, @p53, @p54)
RETURNING `id`;
INSERT INTO `assets_usage` (`asset_id`, `asset_usage`, `organisation_id`, `recorded_on`, `unit_id`)
VALUES (@p55, @p56, @p57, @p58, @p59)
RETURNING `id`;
INSERT INTO `assets_usage` (`asset_id`, `asset_usage`, `organisation_id`, `recorded_on`, `unit_id`)
VALUES (@p60, @p61, @p62, @p63, @p64)
RETURNING `id`;
INSERT INTO `assets_usage` (`asset_id`, `asset_usage`, `organisation_id`, `recorded_on`, `unit_id`)
VALUES (@p65, @p66, @p67, @p68, @p69)
RETURNING `id`;
UPDATE `iot_data_records` SET `is_processed` = @p70, `modified_on` = @p71
WHERE `id` = @p72;
SELECT ROW_COUNT();

UPDATE `iot_data_records` SET `is_processed` = @p73, `modified_on` = @p74
WHERE `id` = @p75;
SELECT ROW_COUNT();

UPDATE `iot_data_records` SET `is_processed` = @p76, `modified_on` = @p77
WHERE `id` = @p78;
SELECT ROW_COUNT();

UPDATE `iot_data_records` SET `is_processed` = @p79, `modified_on` = @p80
WHERE `id` = @p81;
SELECT ROW_COUNT();

UPDATE `iot_data_records` SET `is_processed` = @p82, `modified_on` = @p83
WHERE `id` = @p84;
SELECT ROW_COUNT();

UPDATE `iot_data_records` SET `is_processed` = @p85, `modified_on` = @p86
WHERE `id` = @p87;
SELECT ROW_COUNT();

UPDATE `iot_data_records` SET `is_processed` = @p88, `modified_on` = @p89
WHERE `id` = @p90;
SELECT ROW_COUNT();

UPDATE `iot_data_records` SET `is_processed` = @p91, `modified_on` = @p92
WHERE `id` = @p93;
SELECT ROW_COUNT();

UPDATE `iot_data_records` SET `is_processed` = @p94, `modified_on` = @p95
WHERE `id` = @p96;
SELECT ROW_COUNT();

UPDATE `iot_data_records` SET `is_processed` = @p97, `modified_on` = @p98
WHERE `id` = @p99;
SELECT ROW_COUNT();

UPDATE `iot_data_records` SET `is_processed` = @p100, `modified_on` = @p101
WHERE `id` = @p102;
SELECT ROW_COUNT();

UPDATE `iot_data_records` SET `is_processed` = @p103, `modified_on` = @p104
WHERE `id` = @p105;
SELECT ROW_COUNT();

UPDATE `iot_data_records` SET `is_processed` = @p106, `modified_on` = @p107
WHERE `id` = @p108;
SELECT ROW_COUNT();

UPDATE `iot_data_records` SET `is_processed` = @p109, `modified_on` = @p110
WHERE `id` = @p111;
SELECT ROW_COUNT();

UPDATE `iot_data_records` SET `is_processed` = @p112, `modified_on` = @p113
WHERE `id` = @p114;
SELECT ROW_COUNT();

UPDATE `iot_data_records` SET `is_processed` = @p115, `modified_on` = @p116
WHERE `id` = @p117;
SELECT ROW_COUNT();

UPDATE `iot_data_records` SET `is_processed` = @p118, `modified_on` = @p119
WHERE `id` = @p120;
SELECT ROW_COUNT();

UPDATE `iot_data_records` SET `is_processed` = @p121, `modified_on` = @p122
WHERE `id` = @p123;
SELECT ROW_COUNT();

UPDATE `iot_data_records` SET `is_processed` = @p124, `modified_on` = @p125
WHERE `id` = @p126;
SELECT ROW_COUNT();

UPDATE `iot_data_records` SET `is_processed` = @p127, `modified_on` = @p128
WHERE `id` = @p129;
SELECT ROW_COUNT();

UPDATE `iot_data_records` SET `is_processed` = @p130, `modified_on` = @p131
WHERE `id` = @p132;
SELECT ROW_COUNT();

UPDATE `iot_data_records` SET `is_processed` = @p133, `modified_on` = @p134
WHERE `id` = @p135;
SELECT ROW_COUNT();

UPDATE `iot_data_records` SET `is_processed` = @p136, `modified_on` = @p137
WHERE `id` = @p138;
SELECT ROW_COUNT();

UPDATE `iot_data_records` SET `is_processed` = @p139, `modified_on` = @p140
WHERE `id` = @p141;
SELECT ROW_COUNT();

UPDATE `iot_data_records` SET `is_processed` = @p142, `modified_on` = @p143
WHERE `id` = @p144;
SELECT ROW_COUNT();

UPDATE `iot_data_records` SET `is_processed` = @p145, `modified_on` = @p146
WHERE `id` = @p147;
SELECT ROW_COUNT();

UPDATE `iot_data_records` SET `is_processed` = @p148, `modified_on` = @p149
WHERE `id` = @p150;
SELECT ROW_COUNT();

UPDATE `iot_data_records` SET `is_processed` = @p151, `modified_on` = @p152
WHERE `id` = @p153;
SELECT ROW_COUNT();


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']
UPDATE `iot_data_records` SET `is_processed` = @p0, `modified_on` = @p1
WHERE `id` = @p2;
SELECT ROW_COUNT();

UPDATE `iot_data_records` SET `is_processed` = @p3, `modified_on` = @p4
WHERE `id` = @p5;
SELECT ROW_COUNT();

UPDATE `iot_data_records` SET `is_processed` = @p6, `modified_on` = @p7
WHERE `id` = @p8;
SELECT ROW_COUNT();

UPDATE `iot_data_records` SET `is_processed` = @p9, `modified_on` = @p10
WHERE `id` = @p11;
SELECT ROW_COUNT();

UPDATE `iot_data_records` SET `is_processed` = @p12, `modified_on` = @p13
WHERE `id` = @p14;
SELECT ROW_COUNT();

UPDATE `iot_data_records` SET `is_processed` = @p15, `modified_on` = @p16
WHERE `id` = @p17;
SELECT ROW_COUNT();

UPDATE `iot_data_records` SET `is_processed` = @p18, `modified_on` = @p19
WHERE `id` = @p20;
SELECT ROW_COUNT();

UPDATE `iot_data_records` SET `is_processed` = @p21, `modified_on` = @p22
WHERE `id` = @p23;
SELECT ROW_COUNT();

UPDATE `iot_data_records` SET `is_processed` = @p24, `modified_on` = @p25
WHERE `id` = @p26;
SELECT ROW_COUNT();

UPDATE `iot_data_records` SET `is_processed` = @p27, `modified_on` = @p28
WHERE `id` = @p29;
SELECT ROW_COUNT();

UPDATE `iot_data_records` SET `is_processed` = @p30, `modified_on` = @p31
WHERE `id` = @p32;
SELECT ROW_COUNT();


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']
UPDATE `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
WHERE `id` = @p8;
SELECT ROW_COUNT();

UPDATE `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
WHERE `id` = @p17;
SELECT ROW_COUNT();

UPDATE `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
WHERE `id` = @p26;
SELECT ROW_COUNT();

UPDATE `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
WHERE `id` = @p35;
SELECT ROW_COUNT();

UPDATE `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
WHERE `id` = @p44;
SELECT ROW_COUNT();

UPDATE `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
WHERE `id` = @p53;
SELECT ROW_COUNT();

UPDATE `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
WHERE `id` = @p62;
SELECT ROW_COUNT();

UPDATE `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
WHERE `id` = @p71;
SELECT ROW_COUNT();

UPDATE `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
WHERE `id` = @p80;
SELECT ROW_COUNT();

UPDATE `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
WHERE `id` = @p89;
SELECT ROW_COUNT();

UPDATE `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
WHERE `id` = @p98;
SELECT ROW_COUNT();

UPDATE `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
WHERE `id` = @p107;
SELECT ROW_COUNT();

UPDATE `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
WHERE `id` = @p116;
SELECT ROW_COUNT();

UPDATE `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
WHERE `id` = @p125;
SELECT ROW_COUNT();

UPDATE `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
WHERE `id` = @p134;
SELECT ROW_COUNT();

UPDATE `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
WHERE `id` = @p143;
SELECT ROW_COUNT();

UPDATE `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
WHERE `id` = @p152;
SELECT ROW_COUNT();

UPDATE `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
WHERE `id` = @p161;
SELECT ROW_COUNT();

UPDATE `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
WHERE `id` = @p170;
SELECT ROW_COUNT();

UPDATE `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
WHERE `id` = @p179;
SELECT ROW_COUNT();

UPDATE `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
WHERE `id` = @p188;
SELECT ROW_COUNT();

UPDATE `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
WHERE `id` = @p197;
SELECT ROW_COUNT();

UPDATE `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
WHERE `id` = @p206;
SELECT ROW_COUNT();

UPDATE `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
WHERE `id` = @p215;
SELECT ROW_COUNT();

UPDATE `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
WHERE `id` = @p224;
SELECT ROW_COUNT();

UPDATE `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
WHERE `id` = @p233;
SELECT ROW_COUNT();

UPDATE `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
WHERE `id` = @p242;
SELECT ROW_COUNT();

UPDATE `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
WHERE `id` = @p251;
SELECT ROW_COUNT();

UPDATE `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
WHERE `id` = @p260;
SELECT ROW_COUNT();

UPDATE `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
WHERE `id` = @p269;
SELECT ROW_COUNT();

UPDATE `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
WHERE `id` = @p278;
SELECT ROW_COUNT();

UPDATE `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
WHERE `id` = @p287;
SELECT ROW_COUNT();

UPDATE `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
WHERE `id` = @p296;
SELECT ROW_COUNT();

UPDATE `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
WHERE `id` = @p305;
SELECT ROW_COUNT();

UPDATE `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
WHERE `id` = @p314;
SELECT ROW_COUNT();

UPDATE `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
WHERE `id` = @p323;
SELECT ROW_COUNT();

UPDATE `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
WHERE `id` = @p332;
SELECT ROW_COUNT();

UPDATE `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
WHERE `id` = @p341;
SELECT ROW_COUNT();

UPDATE `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
WHERE `id` = @p350;
SELECT ROW_COUNT();


MMI_DRIVE_DATA_AGGREGATOR - Database update successful the transaction has been committed


MMI_DRIVE_DATA_AGGREGATOR - completed execution of the Map My India device's drives data aggregation


Application is shutting down...