SQL Alternative to cursor: extension

Showing posts with label extension. Show all posts

Thursday, March 8, 2012

An error has occurred during report processing

Hi,
I've been working through Teo Lachev's 'Custom DataSet Data Extension for
Microsoft Reporting Services' (http://makeashorterlink.com/?V1F02505A)
I've built and deployed the DataSet Extension as specifed in the
documentation. I've also adjusted the security config files to insert the new
code group.
I've successfully created the Data Source and the DataSet.
However, I'm getting the following problems from within the report designer.
1) In the Data tab: When I attach the EntitySalesOrder.xsd to the
@.DataSource parameter *nothing* is added to the fields toolbar.
2) When I click the preview tab I get the following error dialog:
"An error has occurred during report processing. Query execution failed for
data set 'DataSet1. DataSource parameter not specified."
I'm running SQL Server Reporting Service SP1 [I've double checked :) ]
Any ideas or pointer would be much appreciated. Thanks>
> I've been working through Teo Lachev's 'Custom DataSet Data Extension for
> Microsoft Reporting Services' (http://makeashorterlink.com/?V1F02505A)
> I've built and deployed the DataSet Extension as specifed in the
> documentation. I've also adjusted the security config files to insert the new
> code group.
> I've successfully created the Data Source and the DataSet.
> However, I'm getting the following problems from within the report designer.
> 1) In the Data tab: When I attach the EntitySalesOrder.xsd to the
> @.DataSource parameter *nothing* is added to the fields toolbar.
> 2) When I click the preview tab I get the following error dialog:
> "An error has occurred during report processing. Query execution failed for
> data set 'DataSet1. DataSource parameter not specified."
> I'm running SQL Server Reporting Service SP1 [I've double checked :) ]
> Any ideas or pointer would be much appreciated. Thanks
>
After checking some previous posts I can confirm that I'm running the latest
SP1 on my box.
I've tried connecting to a couple of different .xsd files but am still
getting the same error:
"An error has occurred during report processing. Query execution failed for
data set 'DataSet1. DataSource parameter not specified."
Does anyone have further pointers I could check?
Thanks
Hans|||Hans Gruber" <Hans Gruber@.discussions.microsoft.com> wrote in message
news:20D93706-74F5-4BF1-9680-7FC6077EFEBD@.microsoft.com...
> Hi,
>
> I've been working through Teo Lachev's 'Custom DataSet Data Extension for
> Microsoft Reporting Services' (http://makeashorterlink.com/?V1F02505A)
> I've built and deployed the DataSet Extension as specifed in the
> documentation. I've also adjusted the security config files to insert the
new
> code group.
> I've successfully created the Data Source and the DataSet.
> However, I'm getting the following problems from within the report
designer.
> 1) In the Data tab: When I attach the EntitySalesOrder.xsd to the
> @.DataSource parameter *nothing* is added to the fields toolbar.
> 2) When I click the preview tab I get the following error dialog:
> "An error has occurred during report processing. Query execution failed
for
> data set 'DataSet1. DataSource parameter not specified."
> I'm running SQL Server Reporting Service SP1 [I've double checked :) ]
> Any ideas or pointer would be much appreciated. Thanks
>
I've been getting the exact same error.
Is there anyone from Microsoft who can help with this?

Wednesday, March 7, 2012

An attempt has been made to use a rendering extension that is not registered for this repo

Hai All,

I have tried to render a Report in my Server to HTML Format.But i got an Error "An attempt has been made to use a rendering extension that is not registered for this report server".I tried using the URL.the Report is worlking fine.But i can't able to render it.

Please Enlighten me.

Thanx,

Karthik.A

Hai All,

I fixed this problem.

I treid to render the Report into HTML Format.

But there's no way to render it to HTML .

But we can render to MHTML.

Thanx,

Karthik.A

An attempt has been made to use a data extension OLEDB that is not registered for this report se

I am using SQL Server 2005 Express along with the other Express reporting tools (VS Express). I am trying to report against an oracle database. I can design and preview the report however when I attempt to 'deploy' the report to a report server that is on the same machine I am developing on, I get the above error. Is this because I am running an Express version of SQL Server or is this an error?

Thanks,

Sam

Yes, the Express Edition only allows connections to local data sources with a limited set of data extensions. Not all types of data sources are supported in the Express Edition.

-- Robert

An attempt has been made to use a data extension OLEDB that is not registered for this repor

Thanks,

Sam

Yes, the Express Edition only allows connections to local data sources with a limited set of data extensions. Not all types of data sources are supported in the Express Edition.

-- Robert

An attempt has been made to use a data extension 'DLLName' that is not registered for this

Hello,

I've created my own data extension which uses ADODB.NET (OleDB Provider) and connects to the named SQL instance. During the development phase of the report I can connect to my data source, retrieve data from it and display it in the report preview with no problems. But as soon as I want to deploy this report and my data source I get the message: “An attempt has been made to use a data extension 'DLLName' that is not registered for this report server.". I went thru all *.config files and set up them up as per instructions how to. I can see my extension in the combo box during designing my report which tells me that this is done correctly. I can create the report in the preview as well. But whatever I do, when I want to deploy it I'm always getting this message.

I've come across one post where it says that Reporting Services are limited to the default, unnamed instance of SQL Server (local). I don't think it should matter to me in this case because I'm using my OleDB Provider to connect to the database. Report doesn't know anything about it. It gets data from my extension, not directly from the database. But I've tried switching from my named instance to (local) just to see if it is going to work, but no luck.

I'd appreciate somebody giving me some suggestions on this issue.

Thanks...

did you update rssrvpolicy.config to grant fulltrust to your extension? Usually this error message appears when report server gets an exception when loading the extension, and this usually happens when extension is not trusted or it fails in constructor. The fact that it works in report designer (which runs everything in fulltrust by default) most likely means that extension is not getting fulltrust when loaded on server.|||

Yes I did. Here is the code from the rssrvpolicy.config:

</CodeGroup>

But it still doens't work. I still am getting the same message when I try to deploy my report.

Any suggestions would be appreciated.