Sharepoint Reporting services extentions not loading

Question

Sharepoint Reporting services extentions not loading

corinne_crawford

SSC Eights!

Points: 944
More actions
April 20, 2017 at 10:15 pm

#401976

Hi All,
We have an issue with a development sharepoint server and reporting services addin.
We tried adding the SQL 2016 add-in as this is listed as supported by Sharepoint 2013 however try as we might we couldn't get it to work.
We then took a snapshot of the server (Yes I wish I'd done one before step 1 :crying:) and added SharePoint 2016 reporting services component and did a number of other things to try and get It working. After our devs gave up I reverted to the snapshot and then uninstalled 2016 add-in and installed 2012 add-in.
We run the Install-SPRSService and Install-SPRSServiceProxy
We setup the report database config etc as per normal but when I try and run a report I get an error that "An attempt has been made to use a data extension 'SQL' that is either not registered for this report server or is not supported in this edition of Reporting Services.;"
Checking the report service log I see "INFO: No extension to load."
Being SP2013 we now use powershell to check extensions. I get the service application GUID via Get-SPRSServiceApplication
then run
Get-SPRSExtension
cmdlet Get-SPRSExtension at command pipeline position 1
Supply values for the following parameters:
Identity: 7135f6df-7e7b-4253-9cc9-3660b1810fff
Get-SPRSExtension : Object reference not set to an instance of an object.
At line:1 char:1
+ Get-SPRSExtension
+ ~~~~~~~~~~~~~~~~~
    + CategoryInfo          : InvalidData: (Microsoft.Repor...erviceExtension:
   GetReportingServiceExtension) [Get-SPRSExtension], NullReferenceException
    + FullyQualifiedErrorId : Microsoft.ReportingServices.SharePoint.PowerShel
   l.GetReportingServiceExtension
Note: I then uninstalled both sql reporting services for Sharepoint and the addin and reinstalled.
Same issue still remains. Any suggestions welcome.
Many Thanks
Corinne

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Sue_H SSC Guru Points: 90860 More actions · Answer 1

It's hard to tell exactly what you are doing where, there aren't too many details and we would have no idea what the number of things you have done would be.
You may want to just follow the exact steps listed in Microsoft's documentation - even if you want to eventually install it in a different way, just follow their document for now:
Install The First Report Server in SharePoint Mode

Sue

corinne_crawford SSC Eights! Points: 944 More actions · Answer 2

Hi Sue,

I have installed and configured as per the documentation the issue is that some system settings are being retained from the original reporting services install which I think may be causing my issue for example the original reporting services application gets auto recreated when I do the install.

Setting in current application after install show the webapps associated

When I try to create a new of course I can't associate to the current web apps.

The issue I have is reporting services is not loading the reporting extensions. Which is shown in the reporting services logs on startup of reporting services
Checking the report service log I see "INFO: No extension to load."
Possible a registry entry or dll has become corrupt ???

Thanks
P.S Sorry for delayed response been a lot of public holidays in Australia over the past few weeks and only just got back to try this again

Sue_H SSC Guru Points: 90860 More actions · Answer 3

I'm a bit confused. From what you said here

When I try to create a new of course I can't associate to the current web apps.

When you went to create new what? Is this for the part when you create the service app by going to Manage Services --> New?
Was SQL Server Reporting Services Service Application listed?
Did you complete the step for Create SQL Server Reporting Services Service Application?
It's after this step that you associate the web applications.
Were all of the web applications already associated with a Reporting Services service application - did you get a warning to that effect? I can't see all of the screen on your screenshot.
So I'm not really following as you said you got through all of the steps but you couldn't create a new something?

Sue

corinne_crawford SSC Eights! Points: 944 More actions · Answer 4

Hi Sue,

I do steps 1 and 2 as per procedure in the link you sent
1. Install SQL reporting services for Share point and the add-in
2. Run the install SSPSService and proxy

It's step 3 where I have my issues to create a new reporting services application. As this is not a 1st/fresh install there is somewhere in sharepoint that is retaining the original settings. So yes all of the web apps seem to be already associated to the Original reporting service application.
Under the original reporting application I see both of our current web apps greyed out and ticked. With a message that reads there are no web applications available to associate with this report service application.

If I create a new reporting services application both web apps are greyed out and not ticked i.e. I can not select them. With the same message as above.

Please understand in this case I'm an accidental share point admin. I'm just a DBA being thrown in the deep end so I appreciate your help and sorry if I'm not explaining myself well.

Thanks
Corinne

Sue_H SSC Guru Points: 90860 More actions · Answer 5

No worries - I just couldn't understand where you had the issues. I only know the basics of Sharepoint myself. A DBA who had to accidentally fix some Sharepoint things, as well as install, more times that I can remember. Too many places think it's the same thing since Sharepoint uses pieces of SQL Server.

Thanks for the extra details. From the sounds of it, it's not a problem with old dlls, registry entries or anything like that. Pretty sure it's just the Web associations - it sounds like they are still pointed at the old Reporting Services Application. So after you create a new Reporting Services Application and go through and get to the part for Web Application Association, go to Application management -> Service Applications -> Configure Service Application Associations. Then I think it's a drop down where you select Web Applications. Then you get a list of the Web Apps, select the association you want to change, remove the check for the old Reporting Services and add the New Reporting Services application.
So it's a matter of removing the old associations and updating them to the newly created Reporting Services application.
After you redo the associations, you get some type confirmation page. And then you can go through the rest of that article. Hopefully anyway.

Sue

corinne_crawford SSC Eights! Points: 944 More actions · Answer 6

Hi Sue,

Many thanks I have managed to get past this issue with your assistance and no longer get the error about no extensions to load in the reporting services log.
I'm now getting permission issues :hehe: but I'm sure I can sort that out or post a new thread if I get caught.

Once again thanks for your help here.