locked
Error while installing CRM Reporting extension RRS feed

  • Question

  • Hi I have the following error while installing CRM Reporting extension. Can you please help.

    Thank you


    The Redeemed 77

    Thursday, October 30, 2014 9:42 PM

All replies

  • hi,

    are you trying to share a ssrs instance with two CRM installed?. Please clarify.

    regards

    Jithesh

    Thursday, October 30, 2014 9:54 PM
  • Hi,

    What does the error message say? It might be that you are trying to use the same service account for both the CRM and the SSRS which is not allowed IIRC.

    Regards


    Rickard Norström Developer CRM-Konsulterna
    http://www.crmkonsulterna.se
    Swedish Dynamics CRM Forum: http://www.crmforum.se
    My Blog: http://rickardnorstrom.blogspot.se

    Friday, October 31, 2014 11:17 AM
  • Hi Hitesh,

    I am trying to install crm reporting extension on the db server server where I also have reporting service running. I previously had reporting extension for crm 2011 installed on that server but I uninstalled it first before trying to install reporting extension for crm 2013. Please let me know if there is any specific clarification you would like me to give.

    Thanks your help


    The Redeemed 77

    Friday, October 31, 2014 1:30 PM
  • Hi,

    Could you copy the entire error message from the screen dump above? We can only see part of the error.

    Regards


    Rickard Norström Developer CRM-Konsulterna
    http://www.crmkonsulterna.se
    Swedish Dynamics CRM Forum: http://www.crmforum.se
    My Blog: http://rickardnorstrom.blogspot.se

    Friday, October 31, 2014 1:32 PM
  • Hi Richard,

    Below are the details of the error I am getting.

    Thanks for you help


    The Redeemed 77

    Friday, October 31, 2014 1:32 PM
  • Hi,

    Have you checked if you are using the same account running SSRS as you are running the AppPool for CRM (or any of the sex service accounts in CRM)

    Regards


    Rickard Norström Developer CRM-Konsulterna
    http://www.crmkonsulterna.se
    Swedish Dynamics CRM Forum: http://www.crmforum.se
    My Blog: http://rickardnorstrom.blogspot.se

    Friday, October 31, 2014 1:34 PM
  • Yes. I am using a different account for ssrs and another one for appPool

    The Redeemed 77

    Friday, October 31, 2014 4:25 PM
  • please login to your ssrs server and check if your ssrs execution account and the current installation id is same. It is complaining about that.

    regards

    Jithesh

    Saturday, November 1, 2014 5:11 AM
  • There are five other accounts that are part of the installation, are all six crm service accounts different from the SSRS-service account (sandbox, asynch, monitor, vss writer, deployment web service and application service)

    /Regards


    Rickard Norström Developer CRM-Konsulterna
    http://www.crmkonsulterna.se
    Swedish Dynamics CRM Forum: http://www.crmforum.se
    My Blog: http://rickardnorstrom.blogspot.se

    Saturday, November 1, 2014 10:02 AM
  • Hi Rickard,

    Yes all the crm service accounts are different from the SSRS service account

    Regards


    The Redeemed 77

    Sunday, November 2, 2014 3:13 AM
  • Hi,

    That seems a bit strange. Do you have the possibility to create a new account and use that as the reporting services account? Something strange is happening and that would be one way of removing possible errors.

    Regards


    Rickard Norström Developer CRM-Konsulterna
    http://www.crmkonsulterna.se
    Swedish Dynamics CRM Forum: http://www.crmforum.se
    My Blog: http://rickardnorstrom.blogspot.se

    Monday, November 3, 2014 2:44 AM
  • Just to double check, the execution account highlighted below is different from any of the CRM service account?

    Monday, November 3, 2014 3:00 AM
  • Hi, No it's the service account at the top that is checked. I don't tink I use the execution account at all on my CRM insallations.

    Regards


    Rickard Norström Developer CRM-Konsulterna
    http://www.crmkonsulterna.se
    Swedish Dynamics CRM Forum: http://www.crmforum.se
    My Blog: http://rickardnorstrom.blogspot.se

    Monday, November 3, 2014 3:04 AM
  • After I change the logon SSRS account to Local System account I was able to get pass that error and the installation started correctly.

    However I get an error during installation. I ignored it and the installation completed successfully but I am wondering what that error means. I can't download the screenshot of the error but below is the error form the error log.

    09:51:13|  Error| System.Exception: Publishing CRM reports failed. ---> Microsoft.Crm.CrmException: Could not publish report 'Neglected Cases' due to the following error:  Error occurred while fetching the report. ---> Microsoft.Crm.CrmReportingException: Error occurred while fetching the report. ---> System.Web.Services.Protocols.SoapException: System.Web.Services.Protocols.SoapException: The report server cannot decrypt the symmetric key that is used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content. ---> Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDisabledException: The report server cannot decrypt the symmetric key that is used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content. ---> System.Runtime.InteropServices.COMException: Keyset does not exist (Exception from HRESULT: 0x80090016)
       at Microsoft.ReportingServices.WebServer.ReportingService2005Impl.GetItemType(String Item, ItemTypeEnum& Type)
       at Microsoft.ReportingServices.WebServer.ReportingService2005.GetItemType(String Item, ItemTypeEnum& Type)
       at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
       at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
       at Microsoft.Crm.ReportingServices2005.ReportingService2005.GetItemType(String Item)
       at Microsoft.Crm.Reporting.RuntimeReportServer.UploadReport(String path, Byte[] reportDefinition, String name, String description, Boolean overwriteExistingReport)
       --- End of inner exception stack trace ---
       at Microsoft.Crm.Reporting.RuntimeReportServer.UploadReport(String path, Byte[] reportDefinition, String name, String description, Boolean overwriteExistingReport)
       at Microsoft.Crm.Reporting.RuntimeReportServer.UploadReport(SRSReport report, String reportNameOnSrs, String name, String description, Boolean isSharedReport, Boolean overwriteExistingReport)
       at Microsoft.Crm.ObjectModel.ReportServiceInternal`1.UploadSRSReport(Guid reportId, String reportNameOnSrs, String name, String description, SRSReport srsReport, ExecutionContext context, Boolean isCustomReport, Boolean overwriteExistingReport)
       at Microsoft.Crm.ObjectModel.ReportServiceInternal`1.CreateInternal(IBusinessEntity entity, Boolean isScheduledReport, ExecutionContext context)
       at Microsoft.Crm.Reporting.ReportPublisher.UploadReportInternal(IBusinessEntity report, Int32[] relatedEntitiesArray, Int32[] categoriesArray, Int32[] visibilitiesArray, Guid organizationId, Boolean isProvisioning)
       at Microsoft.Crm.Reporting.ReportSetupPublisher.UploadReportInternal(IBusinessEntity report, Int32[] relatedEntitiesArray, Int32[] categoriesArray, Int32[] visibilitiesArray, Guid organizationId, Boolean isProvisioning)
       at Microsoft.Crm.Reporting.ReportPublisher.UploadReport(String reportFolder, String reportName, String fileName, String description, Int32 languageCode, Int32[] categoriesArray, Int32[] relatedEntitiesArray, Int32[] visibilitiesArray, Object parentId, Guid signatureId, Version version, Guid organizationId, Hashtable reportsPublished, String reportNameOnSrs, Boolean isProvisioning)
       at Microsoft.Crm.Reporting.ReportPublisher.UploadReports(Guid organizationId, String reportFolder, Int32 languageCode, Int32 matchCategoryNumber, Int32 addCategoryNumber, IProgressEventSource progress, Boolean isProvisioning)
       --- End of inner exception stack trace ---
       at Microsoft.Crm.Reporting.ReportSetupPublisher.OnPublishFail(Exception exception, String message)
       at Microsoft.Crm.Reporting.ReportPublisher.UploadReports(Guid organizationId, String reportFolder, Int32 languageCode, Int32 matchCategoryNumber, Int32 addCategoryNumber, IProgressEventSource progress, Boolean isProvisioning)
       at Microsoft.Crm.Setup.Server.Utility.ReportsUtility.UploadReports(String orgUniqueName, String reportFolder, Int32 languageCode, Int32 matchCategoryNumber, Int32 addCategoryNumber, IProgressEventSource progress)
       at Microsoft.Crm.Tools.Admin.RSPublishAction.PublishReports(String organizationUniqueName)
       at Microsoft.Crm.Tools.Admin.RSPublishAction.Do()
       at Microsoft.Crm.Setup.Common.CrmAction.ExecuteAction(CrmAction action, IDictionary parameters, Boolean undo)
       --- End of inner exception stack trace ---, Error, AbortRetryIgnore, Option1


    The Redeemed 77

    Monday, November 3, 2014 3:38 PM
  • Ok, that's another issue. When you changed service account you should have got a warning about backing up encryption keys. What is happening now is that you have a service account which cannot read the encryption keys since it's done with another account. If you don't have any other systems using that reporting service you can just delete them and start fresh since you just installed your CRM.

    Regards


    Rickard Norström Developer CRM-Konsulterna
    http://www.crmkonsulterna.se
    Swedish Dynamics CRM Forum: http://www.crmforum.se
    My Blog: http://rickardnorstrom.blogspot.se

    Tuesday, November 4, 2014 12:16 PM