Answered by:
Unable to update CRM 2011 Load Balanced Report URL in Deployment Manager

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,
SaadRegards, 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 AMModerator -
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.ClearRegards, 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,
SaadRegards, Saad
- Marked as answer by Mohd Saad Wednesday, June 17, 2015 11:06 AM
Wednesday, June 17, 2015 11:06 AM