Did you try looking at the the data flow landing page or instances of Pega-DM-DDF-Work ? Every failed campaign will leave these instances for further troubleshooting. For example P-20 which creates a PR-56 would have left a instance named PR-56 in the system. That instance of Pega-DM-DDF-Work could be opened and there are various data flow component level failures capture to see more details. In your case the output component that uses the data-set to write to the batch table would have failed with a SQL exception.