Sharepoint Reporting services extentions not loading
-
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-SPRSExtensioncmdlet 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.GetReportingServiceExtensionNote: I then uninstalled both sql reporting services for Sharepoint and the addin and reinstalled.
Same issue still remains. Any suggestions welcome.
Many Thanks
Corinne
-
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 ModeSue
-
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 -
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
-
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 proxyIt'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 -
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
-
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.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply