Search code examples
reporting-servicesssrs-2012

Report processing has been canceled by the user. (rsProcessingAborted)

I am getting below error message while run reports from SSRS server.

Report processing has been canceled by the user. (rsProcessingAborted)

In the SSRS report i am calling the SP and provided the same user permission to the SP(same used in the datasource) but i am getting rsProcessingAborted error message.

Please help me if anyone have idea about the issue

Already tried below things: - Updated dataset query time out to 1000 seconds - updated the SSRS site setting query execution timeout to 1000 seconds.

Solution

  • I have added system database(tempdb, msdb, master, modal) mapping to the SSRS user.

    Because i am creating the temp table inside the SP so we need the SSRS user permission to store temporary table in temp db and also require msdb.

    After changing above things it's working good.

    Thanks Guys for your comments.