So I got the wiring harness temp sensor and the speed sensor for the tranny. There were two of them on the inside, I only replaced the one near the torque converter.
The error code was 59 stalling speed. After they replaced the wiring harness and the speed sensor they deleted the errors from the ecu and it did not came back.

The car had the same problems, drive and sport will engage the gear but it will rev but will slip, until you force it. Manual works fine all gears.

Any advice before I go to the dealership to do a better diagnostic with the computer?