daily_betfair_mappings has empty bf_race_id for today

Question

Seem to be blank strings. Strange because bf_runner_id is there.

I've tried reimporting, but it didn't help.

Please can it be fixed?

Also, is this a common problem?

Answer 1

The daily betfair mappings are now fixed and should be fine for the foreseeable future.

However, please note that today's mappings were resolved at 8.44, so any data downloaded for today's racing - 31/03/26 - before then will not be correct.  To be sure that you have the correct mappings, ensure that all data from today is clear before you run the updater.  To delete any existing mappings, run the folllowing:

delete from daily_betfair_mappings where date=curdate();

Then run the updater and all should be fine. 

Answer 2

Hi - yes we are aware of the issue.  

It’s not a common problem but occurs when there are issues with the Betfair API or servers Betwise side.  

In this case the issue is likely to persist until Tuesday (so Sunday and Monday mappings will be missing) but should be fixed late Monday for Tuesday declarations.  

Will update here once resolved.

Comments

It seemed to be fixed yesterday, but today half the events have bf_race_ids and half don't, and I'm getting this error on import

"Fetching data from: https://www.betwise.co.uk/smartform_data/3814/VP2TFHF6LASB/1774914001/daily_betfair_mappings.sql
could not execute SQL statement:
Error 1062 (23000): Duplicate entry '1529271-4147890' for key 'daily_betfair_mappings.PRIMARY'
Could not fetch latest timestamp for feed historic:
Error 1100 (HY000): Table 'historic_races' was not locked with LOCK TABLES"

---

Hi - the resolution is per the additional answer above - to avoid the issue you’re seeing today’s partial data (which came just after midnight) first needs to be deleted before running the smartform updater.as it’s since been replaced):


Best answer
The daily betfair mappings are now fixed and should be fine for the foreseeable future.

However, please note that today's mappings were resolved at 8.44, so any data downloaded for today's racing - 31/03/26 - before then will not be correct.  To be sure that you have the correct mappings, ensure that all data from today is clear before you run the updater.  To delete any existing mappings, run the folllowing:

delete from daily_betfair_mappings where date=curdate();

Then run the updater and all should be fine.

---

Ok thanks, that works. Is it possible to retrieve data for the 29th and 30th or is it lost?

---

The data for daily_betfair_mappings for Sunday and Monday will not be available since this is a daily update, however the relevant betfair IDs (for race and runner) mapped to corresponding Smartform IDs can still be retrieved from historic_betfair_win_prices, which provides that mapping as well as early prices and BSP for each runner in each race.