Has anyone delt with is issue p1747

Ill drive my car after awhile the car will go through gear fualt
Limp mode - I have to pull over shut car off the Restart it that will work sometime then yours times that won't work I have to pull battery cable off for a while - really getting on my nerves- is there a reason for this or can someone suggest something to look at -

 

Based on what I have read here it sounds like your TCM or one of your solenoids in the transmission pan is no longer good.

 

Is ther a way to repair it or diagnose it ?