none
Reporting in SCCM 2012 not working properly RRS feed

  • Question

  • New Install sccm 2012 and sql 2008r2 sp1 CU6

    single parent server and single sql 2008r2 sp1 server with reporting services installed and working

    from the sccm 2012 site server I installed the reporting services point on the sql 2008r2 server successfully. When I go to http://sql08r2/reports it does show reports, when I go to monitoring on the site server under reports it returns, "no items found" when I right click and try to create a report I get "at least one report category must exist before a report can be created"

    As far as I can tell all other SCCM 2012 Configuration Manager & Operation Manager features are working at this point.

    I am also getting alerts about SMS_SRS_Reporting_Point SMS_enroll_Web.

    Here is the Message I consistantly get in srsrp.log:

    Timed Out...~  $$<SMS_SRS_REPORTING_POINT><07-23-2012 14:18:37.966+300><thread=5508 (0x1584)>
    Reporting Services URL from Registry [https://XXXXX.amctec.local/ReportServer/ReportService2005.asmx]~  $$<SMS_SRS_REPORTING_POINT><07-23-2012 14:18:37.966+300><thread=5508 (0x1584)>
    System.Web.Services.Protocols.SoapException: An error occurred when invoking the authorization extension. ---> Microsoft.ReportingServices.Diagnostics.Utilities.AuthorizationExtensionException: An error occurred when invoking the authorization extension. ---> System.ServiceModel.FaultException`1[[System.ServiceModel.ExceptionDetail, System.ServiceModel, Version=3.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]: Value does not fall within the expected range.~   at Microsoft.ReportingServices.WebServer.ReportingService2005Impl.GetItemType(String Item, ItemTypeEnum& Type)~   at Microsoft.ReportingServices.WebServer.ReportingService2005.GetItemType(String Item, ItemTypeEnum& Type)  $$<SMS_SRS_REPORTING_POINT><07-23-2012 14:18:38.097+300><thread=5508 (0x1584)>

    Any Ideas?

    Monday, July 23, 2012 7:37 PM

Answers

All replies

  • What is the health status under Monitoring -> System Status -> Site Status -> Reporting services point?


    Monday, July 23, 2012 7:41 PM
  • Status Critical for Reporting services.

    I have one error when showing messages the rest are milestone messages:

    "The report server service is not running on Reporting Service Pointserver "XXXXX.amctec.local"; start the service to enable reporting."

    Monday, July 23, 2012 7:52 PM
  • Is that service running? Also check if CU6 is really installed. It should show up as 10.50.2811 in SQL Management Studio once you connect.

    Another thing would be to hover your mouse over the error. SCCM will give you a list of possible issues associated with the error.



    Monday, July 23, 2012 8:02 PM
  • Please restart the Reporting services and If Web reports are working coorectly, can you please refresh\Relaunch the SCCM admin console?
    Monday, July 23, 2012 8:03 PM
  • Yes, 10.50.2811 Also Refreshed and Relunched the SCCM admin console. Many times actually.

    Monday, July 23, 2012 8:19 PM
  • Did you install the ConfigMgr RP on the same SSRS instance as Operations Manager reporting?

    Jason | http://blog.configmgrftw.com | Twitter @JasonSandys

    • Proposed as answer by skywalker123 Tuesday, July 24, 2012 7:32 PM
    • Unproposed as answer by skywalker123 Tuesday, July 24, 2012 7:32 PM
    Monday, July 23, 2012 8:47 PM
  • Forgive my ignorance but how do I check it in Operations Manager? Under Reporting Services Point Properties I used the default… MSSQLServer

    Is this what you were asking?

    Monday, July 23, 2012 9:01 PM
  • Yes, did you use this same SSRS instance for ConfigMgr reporting?

    If so, bad joo-joos because OpsMgr takes over permissions completely and makes it impossible for other applications to do much including ConfigMgr. You'll need to install another instance of SSRS for ConfigMgr reporting.


    Jason | http://blog.configmgrftw.com | Twitter @JasonSandys

    • Proposed as answer by skywalker123 Tuesday, July 24, 2012 7:32 PM
    Monday, July 23, 2012 11:32 PM
  • You were correct I was using the same SSRS Instance. I created a second instance for Operations Manager and tested. SCOM Reporting is working properly in Operations Manager. However, Configuration Manager is not. Do I need to create a new SSRS instance for it? I read online were Configuration Manager reporting prefers the default instance. Any Ideas how to get the  Configuration Manager reporting instance working?

    Thank You for the push in the right direction I feel like I am on my way...

    Ron

    Tuesday, July 24, 2012 2:54 PM
  • It's not so much that COnfigMgr requires the default instance, see this for more details: http://blogs.technet.com/b/configmgrteam/archive/2009/05/14/faq-sql-reporting-services-integration-with-system-center-configuration-manager-2007-r2.aspx.

    Once OpsMgr "pollutes" an SSRS instance, it's toast without a lot of work -- I'm sure there's a way to reset the permissioning, but I don't know what it is off hand. You may be able to uninstall and reinstall the instance.


    Jason | http://blog.configmgrftw.com | Twitter @JasonSandys

    • Marked as answer by rliss13 Wednesday, July 25, 2012 1:27 PM
    Tuesday, July 24, 2012 8:51 PM
  • Issue was resolved by abandoning the default SSRS Instance and creating a new one for the Configuration Manager. I did the standard Reporting Services Configuration Manager setup for the new instance. Used Configuration Manager Setup to point to the new instance then created a new Reporting services point.

    Wednesday, July 25, 2012 1:27 PM