March 21, 2024 at 9:53 am
Today I can see my job running SSRS Report using stored procedure inside and failing in first attempt with below error , but in 2nd attempt the job runs fine. Please help me to solve this issue and what could be the reason behis this failure.
Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for dataset 'dataset1'. ---> System.Exception: For more information about this error navigate to the report server on the local server machine, or enable remote errors
March 21, 2024 at 3:31 pm
Could be that your datasource requires some startup-time. SQL Database with auto close option?
March 27, 2024 at 7:15 pm
Can you post the query from dataset1? It is saying there is an error in the query for dataset1 in the SSRS report.
MCSE SQL Server 2012\2014\2016
April 1, 2024 at 1:31 pm
Did you try running the report on the server to get a more detailed error message?
April 1, 2024 at 3:15 pm
Could be that your datasource requires some startup-time. SQL Database with auto close option?
This is exactly what I was thinking, too.
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply