It seems that while the phone can use data from either SIM The hotspot can only connect to the internet via the SIM in slot 1.
Not a problem now I have discovered this but I thought I would flag this to save others the same problems I had.
It would be good if an error message was displayed if the hotspot is activated while data through SIM 2 is selected.