Following on with what Tom mentioned, try the same steps without the UPS plugged into the Mac's USB port.

Removing USB devices from a sleeping Mac will definitely wake it up.