It's entirely possible that the now very tired battery is causing the trans fail safe. Have you monitored the alternator output voltage while it's running?

BTW, resetting the trans adaptation with the throttle is a myth....

__________________
Wayne
2005 BMW X5 3.0d (b 02/05)
2001 BMW F650GS Dakar (b 06/01)