SQL Server Performance

Query execution failed for data set 'dsdata..Incorrect syntax near dsdata

Discussion in 'SQL Server 2005 Reporting Services' started by atulgoswami, May 2, 2011.

  1. atulgoswami New Member

    Hello All,I am getting a weird error. I am using SQL Server 2005 SP3.I googled it and could not find anything as it is only saying "Incorrect syntax near 'dsdata'"..it is not telling ....what is incorrect?When i searched this error, i got something...incorrect parameter or oveflow or binary data truncated...I am thinking from where i should start troubleshooting...Is there any issue in RDL or SP?So far my analysis guess, there is issue in RDL code or at expression, where NULL conditions are not handled prperly.Any idea/suggestion would be of great help. Thanks in advanceAn error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for data set 'dsdata'. ---> System.Data.SqlClient.SqlException: Incorrect syntax near 'dsdata'. --When i checked the SSRS logs, it has following details----------------------------------------------------------------------------------------------------------e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for data set 'dsdata'., ;Info: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for data set 'dsdata'. ---> System.Data.SqlClient.SqlException: Incorrect syntax near 'dsdata'.e ERROR: An exception has occurred in data source 'dsdata'. Details: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for data set 'dsdata'. ---> System.Data.SqlClient.SqlException: Incorrect syntax near 'dsdata'.w3wp!processing!8!4/26/2011-13:14:41:: i INFO: Merge abort handler called for ID=-1. Aborting data sources ...w3wp!dataextension!8!4/26/2011-13:14:41:: w WARN: CommandWrapper.Cancel not called, connection is not valide ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing., ;Info: Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for data set 'dsdata'. ---> System.Data.SqlClient.SqlException: Incorrect syntax near 'dsdata'.w3wp!processing!8!4/26/2011-13:14:41:: w WARN: Data source 'DataSource': Report processing has been aborted.e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing., ;Info: Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for data set 'dsdata'. ---> System.Data.SqlClient.SqlException: Incorrect syntax near 'dsdata'.----------------------------------------------------------------------------------------------------------

Share This Page