Sign in
Microsoft.com
 
Microsoft
 
 
 

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

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    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

  • Question
    Sign in to vote
    0
    Sign in to vote

    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

  • Question
    Sign in to vote
    0
    Sign in to vote
    Anyone??

    Regards, Saad

    Wednesday, June 10, 2015 7:10 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    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
  • Question
    Sign in to vote
    0
    Sign in to vote

    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
  • Question
    Sign in to vote
    0
    Sign in to vote

    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