In the past couple of months, my trans lost power two times while driving. Three days ago I got an engine light that says 'service engine soon'. I got the OBD read today and it says "Gear 6 incorrect ratio". For a test today, I changed the gear to manual and it shifts perfect all the way upto gear seven and downward. I did a couple of highway runs on automatic and also on manual and it shifts perfectly. Does anyone has any idea what I need to do? Thank you all.