URGENT - DataSet processing ISSUE
Datasource : Cube + SQL DB
Dataset: Cube + SQL DB
Table on the report: Most columns filled from Cube DB. Added one more column connected T-SQL DB.
Before adding T-SQL dataset, report was showing perfectly on the site.
After adding T-SQL dataset and connected to table in the new column, I am getting error for this NewDataset (T-SQL)
SSRS previews report perfectly.
When I deploy it online, I am getting
An error has occurred during report processing. (rsProcessingAborted)
Query execution failed for dataset 'NewDataset'. (rsErrorExecutingCommand)
For more information about this error navigate to the report server on the local server machine, or enable remote errors
What can I do to fix this?
August 31st, 2012 11:43am
Hi there,
Ensure that the report is pointed to the proper data source, and credentials are set properly.
Also take a look at trace logs for detials about the error.
http://msdn.microsoft.com/en-us/library/ms157403.aspx
cheers,
AndrewAndrew Sears, T4G Limited, http://www.performancepointing.com
Free Windows Admin Tool Kit Click here and download it now
August 31st, 2012 1:38pm
Hi SRS02,
From your description, do you mean a stored procedure by saying the T-SQL dataset? This is a common error message, and the issue may be caused by various factors. At this time, I suggest that you refer to the following suggestions:
Please makek sure the SQL Server data source has been deployed to the report server.When we use a stored procedure as the data source to design a report, it is no need to set the permission specially if we create the report in Report Designer. However, if we need to deploy the report to a report server, we need to set the "Public"
permission on this stored procedure first. For the detailed steps, please see:
Grant Permissions on a Stored Procedure.On the report manager, check the connection strings and credentials of the data sources. If you configure the data source to use Windows Integrated Security currently, please switch it to stored credentials to see if it works.
If this is an urgent issue, you could contact Microsoft Customer Support Services (CSS) via telephone so that a dedicated Support Professional can assist you in a more efficient manner. Please understand that contacting phone support will be a charged call,
but it will be free if this is a product issue. To obtain the phone numbers for specific technology request please take a look at the web site listed below:
http://support.microsoft.com/default.aspx?scid=fh;EN-US;PHONENUMBERS
Regards,
Mike YinMike Yin
TechNet Community Support
September 8th, 2012 9:46pm