When you test the SQL in your data model, select the Data Engine Log button on same page. It has the details of your error.

What is your BIP version? Try a simple send to test email. View the report, use the action menu to send, choose email. Does it work?

First test your bursting report directly from BIP. Once it's working, use the same settings to call it with scheduleService.