locked
Unable to update CRM 2011 Load Balanced Report URL in Deployment Manager RRS feed

  • Question

  • Hi,

    In Deployment Manager I am Unable to update CRM 2011 Load Balanced Report URL. There are 2 Servers are in my environment and I can Update to single Report server. I am getting the below error message when i try to update the LB Report URL:

    "Setup failed to validate specified Reporting Services Report Server. Error: Error occurred while finding an item on the report server.
    The request failed with HTTP status 401: Unauthorized."

    LB Report URL works fine from Browser and i can access it.

    I enable trace and got following log.

    Process:  mmc |Organization:00000000-0000-0000-0000-000000000000 |Thread:   97 |Category: Exception |User: 00000000-0000-0000-0000-000000000000 |Level: Error |ReqId:  | CrmException..ctor  ilOffset = 0x0
    at CrmException..ctor(String message, Exception innerException, Int32 errorCode, Boolean isFlowControlException)  ilOffset = 0x0
    at ReportServer.CreateCrmReportingException(Exception innerException, String methodName, Int32 errorCode)  ilOffset = 0x7B
    at ReportServer.FindItemByName(String searchRoot, String name, ItemTypeEnum itemType)  ilOffset = 0x6F
    at ReportServer.get_IsWorkgroupEdition()  ilOffset = 0x0
    at SetupReportServer.GetSetupReportServer(Uri reportServerUrl)  ilOffset = 0xF
    at ExistingRSValidator.InternalCheck(IDictionary parameters)  ilOffset = 0x94
    at Validator.Check(IDictionary parameters)  ilOffset = 0x12
    at Validator.InternalCheck(IDictionary context, IDictionary data)  ilOffset = 0x0
    at ConditionBase.Validate(IDictionary context, IDictionary data)  ilOffset = 0x0
    at BaseGroup.Validate(IDictionary data)  ilOffset = 0xDC
    at EDWTool.RunSnifferValidate(BaseGroup sniffer)  ilOffset = 0x2B
    at EDWTool.Run(Boolean stopOnFail, BaseGroup snifferToRun)  ilOffset = 0x65D
    at EDWTool.RunAll(Boolean stopOnFail)  ilOffset = 0x43
    at NonRtlResultsPanel.RunTasks()  ilOffset = 0xAF
    at NonRtlResultsPanel.Setup()  ilOffset = 0x1A
    at ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean ignoreSyncCtx)  ilOffset = 0x71
    at ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)  ilOffset = 0x0
    at ThreadHelper.ThreadStart()  ilOffset = 0x19
    >Crm Exception: Message: Error occurred while finding an item on the report server., ErrorCode: -2147187944, InnerException: System.Net.WebException: The request failed with HTTP status 401: Unauthorized.
       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.FindItems(String Folder, BooleanOperatorEnum BooleanOperator, SearchCondition[] Conditions)
       at Microsoft.Crm.Reporting.ReportServer.FindItemByName(String searchRoot, String name, ItemTypeEnum itemType)

    Please help.


    Regards, Saad


    • Edited by Mohd Saad Monday, May 25, 2015 4:17 AM
    Friday, May 22, 2015 3:38 AM

Answers

  • Hi All,

    Issue was not with CRM. Infra team disabled the cookie Cache of Load Balanced Report server and evrything is working fine now.

    Regards,
    Saad


    Regards, Saad

    • Marked as answer by Mohd Saad Wednesday, June 17, 2015 11:06 AM
    Wednesday, June 17, 2015 11:06 AM

All replies

  • Anyone??

    Regards, Saad

    Wednesday, June 10, 2015 7:10 AM
  • You say 'LB Report URL works fine from Browser and i can access it' - is that the ReportServer url, or Report Manager ?

    If you've only tried Report Manager, try the ReportServer Url. And is this from a browser running on the Crm server, and using the same account that you run Deployment Manager with.

    If all that is OK, check the Report Server log files , though the issue may be more with load balancing - it'd be useful to know if anything gets written to the RS log files, or if the failure comes before that


    Microsoft CRM MVP - http://mscrmuk.blogspot.com/ http://www.excitation.co.uk

    Wednesday, June 10, 2015 9:00 AM
    Moderator
  • Hi David, 

    Thanks for the reply. 

    LB Report URL is Load Balanced ReportServer url. Both Report Manager URL and Report Service URL are running fine. I can update individual Report Server URL in deployment Manager but unable to update LB Report Server URL.

    From crm50dmsnapin here is the trace.

    00:15:05|   Info| Check WordBreakerValidator: Success
    00:15:05|   Info| Check FullTextInstalledValidator: Success
    00:15:05|   Info| Check FullTextRunningValidator: Success
    00:15:05|   Info| Check OrganizationDatabaseExistsValidator: Success
    00:15:05|   Info| Group Microsoft SQL Server Reporting Services
    00:15:05|   Info| Check ReportingUrlValidator: Success
    00:15:06|  Error| Check ExistingRSValidator : Failure: Setup failed to validate specified Reporting Services Report Server http://Server/ReportServer_CRM. Error: Error occurred while finding an item on the report server.
    The request failed with HTTP status 401: Unauthorized.

    00:15:06|Verbose| Validation ran.
    00:15:06|Verbose| Validation completed.
    00:15:06|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.EDWTool.Run
    00:15:06|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.EDWTool.RunAll
    00:15:06|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.EDWToolCallbacks.Clear
    00:15:06|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.EDWToolCallbacks.Clear


    Regards, Saad

    Wednesday, June 10, 2015 10:26 AM
  • Hi All,

    Issue was not with CRM. Infra team disabled the cookie Cache of Load Balanced Report server and evrything is working fine now.

    Regards,
    Saad


    Regards, Saad

    • Marked as answer by Mohd Saad Wednesday, June 17, 2015 11:06 AM
    Wednesday, June 17, 2015 11:06 AM