Delete existing record is not working in "InsertIntoSqlDbAsync" method. about azureusageandbillingportal HOT 2 CLOSED

i resolved this issue already for my solution. delete query is wrong in this method . change delete query to this : "delete from dbo.AzureUsageRecords with(repeatableread, rowlock) where SubscriptionId = @subscriptionId and (UsageStartTime >= @usageStartTime and UsageEndTime <= @usageEndTime)" where code will look for date range between start and end. this will resolve issue. after replacing this you may get another issue of transaction when code try to delete record more than 20000 rows. it'll fail. so you may need to scale up azure sql db or delete those rows before you reload data using sql query.

from azureusageandbillingportal.

@RahulSolanki1487 you may make a pull request to have this one fixed.

from azureusageandbillingportal.