Monday, February 20, 2012

Problem with datasource on Report Builder

I've got a strange problem with ReportBuilder. I've created a DataSource name Config and a Model name Customers. We been using this model for month and everything was working fine. Now when we try to create a new report we cannot run it. When Report Builder is running i select the "Customer" model. Then i put some fields on the report. When i try to run it i've got an error saying that it cannot create the command for datasource1. What i don't understand is why the error occured in Datasource1 and not in my datasource config ?

When i open the Report Manger and click on the model "Customer" the datasource use by this model is Config. So the problem is not because they're is a mistake in the configuration. I've tried to rebuild my model and datasource then deployed them but i still have the same problem.

Any idea of what the problem is ? I can't figure outThis is the exact error i get:

An error has occurred during report processing. (rsProcessingAborted)
Cannot create command for datasource1. (rsErrorCreatingCommand)
An

attempt has been made to use a data extension 'SQL' that is not

registered for this report server. (rsSemanticQueryExtensionNotFound)|||

Can you please try restarting your IISservices (an iisreset on the Webserver hosting reporting services) to see if you get a different behavior?

Thank you.

Ramu_MSFT

This posting is provided "AS IS" with no warranties, and confers no rights.
.

|||Thanks ! I've tried to restart IIS and reboot our server but we still have the same problem.

No comments:

Post a Comment