Payroll Flow - BI Report - Bursting - Template not generated

Hi folks,

I'm generating a payroll report and pushing it on SFTP using bursting. Template, filename and path is derived via bursting .This report is attached to a Payroll flow.

When I submit the flow, flow gets completed successfully but one of the Generate output subprocess fails in error. In BI - Report job history - Process is completed successfully but no file is generated and hence not posted to SFTP also.

When i pass the parameters to bursting query manually, it works and generates output file.

Busting fails when it is called via Flow.

Please help.