Have you cleaned out the plug and connector at the transmission? Mine used to occasionally get filled with water from rain/car splashes and I would get trans limp mode until I pulled the plug and cleaned out the water.

__________________
2011 E70 • N55 (me)
2012 E70 • N63 (wife)