We are using SDL Tridion 2011 SP1. We are publishing component using automatic activity in workflow. The item showing success in publishing queue but there was not DCP created on webserver. Minimum approval status is set on publishing target. There is no successful processed item in publish transaction.
Here's some things I would check to try and figure out where your problem lies.
- Does a Dynamic Presentation publish when not attached to workflow
- Is your workflow attempting to publish a component that is higher up in the BP structure that isn't associated with a publishing target
- Is your storage configuration storing the DCP somewhere unexpected (file system somewhere)
Perhaps you could go through these items and if un resolved, start a new question when you get closer to the issue.