When this happened to me, I just booted into the standard Switch Horizon OS (don't think it matters if you're using the hacked version or stock as installed on sysMMC, in my case) and calibrated the joysticks through settings.
Went back to Hekate and was able to dump my Joycons successfully.
Went back to Hekate and was able to dump my Joycons successfully.
