Speaking from experience, first disassemble the harness connector at the transmission and thoroughly clean the pins and sockets with contact cleaner. Reassemble with dielectric grease and check your transmission operation again. It's amazing, the havoc a dirty connector can play with the unit.

2002 X5 3.0 257,000 miles (GM transmission - original fluid)
2004 325i 114,000 miles