Sprinkler valve not turning on by automatic timer
You have done good testing. Almost certainly the electric solenoid at the valve is defective, with a small chance the wire has a short.
Many designs of them can be replaced (leaving the rest of the valve in place).