Update, I didn't get to take look myself but Nissan is fixing it.
They sent it in to a gearbox specialist as they struggled to even "see" it wasn't working...anyways, $3700 to replace the solenoid. $2800 for new gearbox, I told them fit a new box.
BTW, they say they had to open my gearbox to ...