The short answer is you need to pull the fault codes in the transmission module & post them on here for anyone to be able to assist you further. Otherwise we’d all just be guessing

__________________
Current vehicles
2001 325XI
2006 X5 3.0
2004 X5 3.0