With Cognos 10 it's possible to bring data from an external source and add it to a package. When you do that it allows you to save the new package and give it a new name. For example, you may want to bring in a spreadsheet with factors to multiply an attribute by. In my case, I had a spreadsheet with customers, sales performance data and contact information. I wrote my report with the external data, and everything works fine. I then added the bursting option and tried to send the emails - at which point I got this error:
Googling the error codes RQP-DEF-0068 and UDA-SQL-0593 didn't reveal anything so I needed to the help of Simpson Associates. The fix for the problem came down to the way that the external file was referenced in the new package. When I first attached the file I clicked the Browse button and navigated to the file:
To make the report work I needed to click on the Browse button and enter the full UNC path for the file
It's also important to make sure that the "Allow the server to automatically load the file" option is ticked. Once that had been done the report ran properly and burst the emails as expected.