How can I debug an Automator workflow?
Enable the Automator Log

Automator's Log panel should display more detailed error information. You can show it by clicking the Log item in the View menu (or pressing ⌥⌘L).