Remove From My Forums

Hardware Load Balanced Alias causing reporting issues

Question
0

Sign in to vote
Hello,

Currently have a multi-instance crm 2011 Rollup 5 environment. We have a load balanced alias that points to our two web front ends. I'm looking for any type of direction that I can get. When we use the alias we have reporting issues that look like the following:

Webpage error details

User Agent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.1; WOW64; Trident/4.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0; InfoPath.2; .NET4.0C; .NET4.0E; MS-RTC LM 8; BRI/1; MS-RTC EA 2; Zune 4.7)
Timestamp: Thu, 26 Jan 2012 13:18:36 UTC

Message: 'Type' is undefined
Line: 1
Char: 1
Code: 0
URI: http://crm2011/Reserved.ReportViewerWebControl.axd?OpType=Resource&Version=10.0.30319.1&Name=ViewerScript

Message: 'Sys' is undefined
Line: 55
Char: 1
Code: 0
URI: http://crm2011/orgname/CRMReports/rsviewer/reportviewer.aspx

Message: 'Sys' is undefined
Line: 388
Char: 1
Code: 0
URI: http://crm2011/orgname/CRMReports/rsviewer/reportviewer.aspx

Message: Object expected
Line: 111
Char: 1
Code: 0
URI: http://crm2011/orgname/CRMReports/rsviewer/reportviewer.aspx

Message: Object expected
Line: 111
Char: 1
Code: 0
URI: http://crm2011/orgname/CRMReports/rsviewer/reportviewer.aspx

Or the following errors:

Webpage error details

User Agent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.1; WOW64; Trident/4.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0; InfoPath.2; .NET4.0C; .NET4.0E; MS-RTC LM 8; BRI/1; MS-RTC EA 2; Zune 4.7)
Timestamp: Thu, 26 Jan 2012 13:36:35 UTC

Message: Object expected
Line: 60
Char: 1
Code: 0
URI: http:/crm2011/orgname/CRMReports/rsviewer/reportviewer.aspx

Message: Object expected
Line: 60
Char: 1
Code: 0
URI: http://crm2011/orgname/CRMReports/rsviewer/reportviewer.aspx

Jason Cosman
- Edited by oldjc Thursday, January 26, 2012 2:05 PM
Thursday, January 26, 2012 1:37 PM

All replies

0

Sign in to vote
I unfortunately don't use a NLB based solution so I can't help much but just to make sure you covered the basic bases did you do the following:

In Deployment Manager go to Microsoft Dynamics CRM -> Properties -> web addresses; from there set all of the appropriate URLs?
In Deploymenet Manager go to Microsoft Dynamics CRM -> Properties -> web addresses -> Advanced; and ensure the "The deployment uses an NLB" checkbox is checked.

Visit my Blog: http://matthewchurilla.blogspot.com/
- Edited by MatthewChurilla Friday, January 27, 2012 3:08 PM
Friday, January 27, 2012 3:07 PM
0

Sign in to vote

Please refer to the following MSDN blog I wrote . This issue of your looks exactly like this :-

http://blogs.msdn.com/b/arpita/archive/2012/07/21/microsoft-dynamics-crm-2011-unable-to-run-any-reports-due-to-missing-security-role-in-default-organization.aspx
Arpita

Saturday, July 21, 2012 12:55 AM
0

Sign in to vote

I was actually able to solve this by correcting my SPN's and having the hardware load balancer setup for bind ip on server. This was the real fix put in place that resolved this issue.
Jason Cosman

Friday, August 3, 2012 5:32 PM
1

Sign in to vote
oldjc,

The issue is probably because of the IIS machine key. It seems you configured to load balanced based on the server IP? so that will make sure you have "sticky sessions" to one specific server during that user session, that will make sure it uses one IIS server for one session and fixes the issue. I would double check if you have the same machine keys on both IIS servers.

http://quantusdynamics.blogspot.co.uk/2012/06/dynamics-crm-2011-report-error-sys-is.html
Visit my blog for CRM material, improving performance, kerberos, IFD, development tips, etc. :) http://quantusdynamics.blogspot.com
- Proposed as answer by nrodriEditor Friday, February 8, 2013 9:29 AM
Monday, August 6, 2012 11:11 AM

Answerer

Asked by:

Hardware Load Balanced Alias causing reporting issues

Question

All replies