locked
SrsDataConnector 2011 on SQL 2012 Reporting Services setup fails with "Instance Name needs to be escaped" RRS feed

  • Question

  • Hello,

    Trying to setup  Dynamics CRM Connector for SQL Server Reporting Services (version 5.0.9688.583) on SQL 2012 for CRM 2011 ver 5.0.9690.3731  freshly installed.
    Single box for this deployment needed only for CRM V4.0 to CRM 2013 migration.

    Reporting Services configured and access to http://servername/ReportServer is OK from installation account. We're using default instance of SQL.

    Data Connector setup is used with SQL server as servername and it finds reporting services instance MSSQLSERVER.

    Systems check fails with
    "Reports will not be published for some organizations because the Report Server instances used by these organizations differ from the instance selected during Microsoft Dynamics CRM Reporting Extensions Setup."
    and "Unable to validate SQL Server Reporting Services Report Server installation. Please check that it is correctly installed on the local machine."

    Looking at setup log confirms that SRS Data Connector setup fails when validating Reporting Services instance

    07:59:35|   Info| Base Language Id of SHCRM11_MSCRM: 1033.
    07:59:35|Warning| Instance Name needs to be escaped. Management Exception: Invalid namespace
    07:59:35|   Info| Escaped Instance Name is RS_MSSQLSERVER
    07:59:35|Warning| Invalid name space error...
    07:59:35|Warning| Could not find a local RS instance corresponding to the reporting url http://servername/reportserver for organization SHCRM11
    07:59:35|   Info| ActivatePage(SsrsInstancePage)
    07:59:36|Warning| Instance Name needs to be escaped. Management Exception: Invalid namespace
    07:59:36|   Info| Escaped Instance Name is RS_MSSQLSERVER
    07:59:36|Warning| Invalid name space error...
    07:59:36|   Info| ActivatePage(InstallLocationPage)

    A Procmon session shows at same time numerous queries to SQL configuration:

    07:59:35.5067299 Microsoft.Crm.Setup.SrsDataConnector.exe 2900 RegQueryValue HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names\SQL\MSSQLSERVER SUCCESS Type: REG_SZ, Length: 40, Data: MSSQL11.MSSQLSERVER
    second attempt a bit later:
    07:59:35.5222511 Microsoft.Crm.Setup.SrsDataConnector.exe 2900 RegQueryValue HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names\SQL\MSSQLSERVER SUCCESS Type: REG_SZ, Length: 40, Data: MSSQL11.MSSQLSERVER

    I applied SQL 2012 SP1; did not change problem.

    Help welcome


    /Patrice


    • Edited by PmNet-CH-FR Tuesday, January 21, 2014 7:46 AM
    Tuesday, January 21, 2014 7:36 AM

Answers

  • Reports got published using PublishReports.exe from Tools directory

    /Patrice

    • Marked as answer by PmNet-CH-FR Tuesday, January 21, 2014 10:05 AM
    Tuesday, January 21, 2014 10:04 AM
  • FYI I was using original DVD kit.

    Need to install the Reporting Extensions from the downloadable version http://www.microsoft.com/en-us/download/details.aspx?id=27822

    Then system checks are green and Reporting Extensions get installed.

    I'm now working on Reports publishing error at end of component setup; will open another thread if noting found on:

    :11:43|   Info| CrmAction execution time; RSPublishAction; 00:00:02.9030000
    10:11:43|  Error| System.Exception: Publishing CRM reports failed. ---> Microsoft.Crm.CrmException: Could not publish report 'Neglected Cases' due to the following error: 
    An error occurred while trying to add the report to Microsoft Dynamics CRM. Try adding the report again. If this problem persists, contact your system administrator. ---> Microsoft.Crm.CrmReportingException: An error occurred while trying to add the report to Microsoft Dynamics CRM. Try adding the report again. If this problem persists, contact your system administrator. ---> System.Web.Services.Protocols.SoapException: System.Web.Services.Protocols.SoapException: The item '/SharedReports/5.0.xxxx' cannot be found. ---> Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: The item '/SharedReports/5.0.xxxx' cannot be found.
       at Microsoft.ReportingServices.Library.ReportingService2005Impl.CreateReport(String Report, String Parent, Boolean Overwrite, Byte[] Definition, Property[] Properties, Guid batchId, Warning[]& Warnings)
       at Microsoft.ReportingServices.WebServer.ReportingService2005.CreateReport(String Report, String Parent, Boolean Overwrite, Byte[] Definition, Property[] Properties, Warning[]& Warnings)
       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.CreateReport(String Report, String Parent, Boolean Overwrite, Byte[] Definition, Property[] Properties)
       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
    10:11:45|   Info| InputResult: Ignore
    10:11:45|   Info| CrmAction execution time; RSPublishAction; 00:00:01.9080000
    10:11:45|  Error| Installer Complete: PublishReportsOperation - Error encountered

    Regards


    /Patrice

    • Marked as answer by PmNet-CH-FR Tuesday, January 21, 2014 10:05 AM
    Tuesday, January 21, 2014 9:42 AM

All replies

  • Hi,

    Are you able to access your reporting server in browser...check once !!

    SQL Server Reporting Services

    Specific Microsoft SQL Server Reporting Services editions are used for reporting functionality.

    Any one of the following Microsoft SQL Server editions is required and must be installed on Windows Server 2008 (x64 SP2 or R2) versions or Windows Server 2012 64-bit-based computers, running, and available for Microsoft Dynamics CRM:

    • Microsoft SQL Server 2008, Standard Edition, x64 SP1 or R2
    • Microsoft SQL Server 2008, Enterprise Edition, x64 SP1 or R2
    • Microsoft SQL Server 2008 Datacenter x64 SP1 or R2
    • Microsoft SQL Server 2008 Developer x64 SP1 or R2 (for non-production environments only)
    • *Microsoft SQL Server 2012, Enterprise, 64-bit
    • *Microsoft SQL Server 2012, Business Intelligence, 64-bit
    • *Microsoft SQL Server 2012, Standard, 64-bit

    you can see server 2012 is marked with (*)


    Vinay Kumar.


    Tuesday, January 21, 2014 7:43 AM
  • Hi,

    that's first thing I checked. Both /reportserver and /reports are OK from installation account.

    This configuration is supported - should I open an incident?


    /Patrice


    • Edited by PmNet-CH-FR Tuesday, January 21, 2014 8:21 AM
    Tuesday, January 21, 2014 7:49 AM
  • Hi,

    Before moving forward, check is reporting services is running on network server or local. 



    Vinay Kumar.

    Tuesday, January 21, 2014 9:01 AM
  • FYI I was using original DVD kit.

    Need to install the Reporting Extensions from the downloadable version http://www.microsoft.com/en-us/download/details.aspx?id=27822

    Then system checks are green and Reporting Extensions get installed.

    I'm now working on Reports publishing error at end of component setup; will open another thread if noting found on:

    :11:43|   Info| CrmAction execution time; RSPublishAction; 00:00:02.9030000
    10:11:43|  Error| System.Exception: Publishing CRM reports failed. ---> Microsoft.Crm.CrmException: Could not publish report 'Neglected Cases' due to the following error: 
    An error occurred while trying to add the report to Microsoft Dynamics CRM. Try adding the report again. If this problem persists, contact your system administrator. ---> Microsoft.Crm.CrmReportingException: An error occurred while trying to add the report to Microsoft Dynamics CRM. Try adding the report again. If this problem persists, contact your system administrator. ---> System.Web.Services.Protocols.SoapException: System.Web.Services.Protocols.SoapException: The item '/SharedReports/5.0.xxxx' cannot be found. ---> Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: The item '/SharedReports/5.0.xxxx' cannot be found.
       at Microsoft.ReportingServices.Library.ReportingService2005Impl.CreateReport(String Report, String Parent, Boolean Overwrite, Byte[] Definition, Property[] Properties, Guid batchId, Warning[]& Warnings)
       at Microsoft.ReportingServices.WebServer.ReportingService2005.CreateReport(String Report, String Parent, Boolean Overwrite, Byte[] Definition, Property[] Properties, Warning[]& Warnings)
       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.CreateReport(String Report, String Parent, Boolean Overwrite, Byte[] Definition, Property[] Properties)
       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
    10:11:45|   Info| InputResult: Ignore
    10:11:45|   Info| CrmAction execution time; RSPublishAction; 00:00:01.9080000
    10:11:45|  Error| Installer Complete: PublishReportsOperation - Error encountered

    Regards


    /Patrice

    • Marked as answer by PmNet-CH-FR Tuesday, January 21, 2014 10:05 AM
    Tuesday, January 21, 2014 9:42 AM
  • Reports got published using PublishReports.exe from Tools directory

    /Patrice

    • Marked as answer by PmNet-CH-FR Tuesday, January 21, 2014 10:05 AM
    Tuesday, January 21, 2014 10:04 AM