WebJobBillingData billingRequest 'StartDate' and 'EndDate' holds initial values

[daandm]

Hi,

I've got an issue with the billingRequest in the BillingData Webjob. The StartDate and EndDate won't update to the latest available dates. On July 11th 2017, the webjob ran for the first time and the StartDate was set to July 9th 2017 and the EndDate to July 11th 2017.

But since then, it won't update the Start and EndDate, so it keeps getting data for that initial date range.

An additional problem is that the webjob keeps inserting new rows to the database. The database contains at this moment 140.000+ usage rows, while there are only 600 unique ones.

Does anyone has a solution to fix these problems?

Thanks in advance!

Daandm

[daandm]

Update:

It's fixed! there was a problem with the billingdatarequest storagequeue.

1. Removed the queue in azure portal
2. Cleared the database
3. Added the queue back again