when you click the notification that the shortcut failed, usually it launches the shortcut in question. My Overcast automation took me to the part that was failing.
You could also just try running the automation from shortcuts, see where it fails at.
If you havent already, I would setup the Change wallpaper automation into a shortcut, then run that shortcut on the automation, makes troubleshooting a bit easier.