one of the Report which calls two Data sets ,
Data set1 Contains , 8 # temp Tables (#1,#2,#3 ) etc.
Dataset2 Contains , 8 # temp Tables (#1,#2,#3 ) etc.
Note: Both Datasets # TEmp Table Names are Same, Please let us know which is best way to replace #temptables.
I am getting Below Error, either in Dataset1 or Dataset2.
We Upgraded Sql Server to 2019, SSRS Server to 2014 from 2008
Query execution failed for dataset 'Dataset2'. --->
System.Data.SqlClient.SqlException: A severe error occurred on the current command.
The results, if any, should be discarded.
Operation cancelled by user.
processing!ReportServer_0-1!2580!09/27/2023-15:18:54:: i INFO: Some other thread has already aborted processing.
processing!ReportServer_0-1!2f9c!09/27/2023-15:18:54:: e ERROR:
An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException:
Query execution failed for dataset 'Dataset1'. ---> System.Data.SqlClient.SqlException:
The query processor ran out of internal resources and could not produce a query plan.
This is a rare event and only expected for extremely complex queries or queries that reference a very large number of
tables or partitions. Please simplify the query. If you believe you have received this message in error,
contact Customer Support Services for more information.
When we run query in SSMS Query is taking MAX 1 Min:30 SEC,
But report level we are getting above error.
Any suggestions highly appreciated.