?
Solved

Moved CRM to new server, reports won't run

Posted on 2009-12-21
31
Medium Priority
?
1,950 Views
Last Modified: 2013-11-24
Not sure where to configure this at, but here is my setup.

Moved CRM server to a new virtual machine. The database server did not move, nor did the report server. Everything is still on the same domain.

Everything came up fine, but I cannot get any reports to run. I reinstalled the SRS connector hoping for a configuration section, but nothing was there except the database of the report server.

How do I get reports running again?

Thanks!
0
Comment
Question by:ApexCo
  • 23
  • 8
31 Comments
 
LVL 15

Expert Comment

by:WilyGuy
ID: 26106018
Did the CRM URL change?

What is the error when you try to pull a report?
0
 
LVL 8

Author Comment

by:ApexCo
ID: 26106056
The URL did change.

There was just a generic error about it not working. I edited the config DB this morning and add the report server URL.

Now I get the report to run, but it's blank, all the images are red x's and there are a ton of javascript errors. I've been messing with the HTTP Handlers and that's gotten me nowhere.

Are there any settings that need to happen in the config database that I'm missing? Or anything that needs to happen on the new server to make the reports work?

CRM is running on Server 2008 R2 64-bit in classic pipeline mode and the report server is running SQL 2005 SSRS.
0
 
LVL 15

Expert Comment

by:WilyGuy
ID: 26106328
Things to check...
MSCRM_CONFIG Database DeploymentProperties table.

The 'AsyncSdkRootDomain', 'ADSdkRootDomain', and 'ADWebApplicationRootDomain'  likely need to be changed.

Was the old CRM server Windows 2008?
Is it offline? (if you turn it back on, if possible, do the reports work?)

SPNs may be involved if there is a service account, and or Host Header and there is involvement of the Windows Kernel-mode in the Authentication in IIS.
0
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
LVL 8

Author Comment

by:ApexCo
ID: 26108184
Ya, I've already update the  'AsyncSdkRootDomain', 'ADSdkRootDomain', and 'ADWebApplicationRootDomain'.

The old CRM server was 2003 and the CRM application was uninstalled from there.

"SPNs may be involved if there is a service account, and or Host Header and there is involvement of the Windows Kernel-mode in the Authentication in IIS."

Not sure about what to do here.
0
 
LVL 8

Author Comment

by:ApexCo
ID: 26108226
And here are the javascript errors I'm receiving when I run a report.

 
Message: Syntax error  
Line: 2  
Char: 1  
Code: 0  
URI: http://virtual8:5555/Reserved.ReportViewerWebControl.axd?OpType=Resource&Version=8.0.50727.42&Name=Scripts.ReportViewer.js 
   
   
Message: 'RSClientController' is undefined  
Line: 38  
Char: 203  
Code: 0  
URI: http://virtual8:5555/ReachOutHealthcareAmerica/CRMReports/rsviewer/reportviewer.aspx 
0
 
LVL 15

Accepted Solution

by:
WilyGuy earned 2000 total points
ID: 26108713
Sorry to be incomplete on my thought earlier.

Based on the above, there is no custom host header.
Are you running the App Pool with Network Service or a Domain Account?
If a Domain Account, I assume it is the same one that ran it previously?
 and that account is in PrivUser, SQLAccess as well as locally in IIS-IUSERS and CRM-WPG?

There is a new IIS 7 feature called Kernel Mode authentication inside the Windows Authentication tab in IIS.  That really limits the times you'll need to create any Service Principle Names (SPNs).

In Deployment Manager, if you look at the Organization (and check properties) you should see the SRS URL, is it correct? Can you hit the URL from the CRM server (does it prompt for auth?)

I'll take another look tomorrow when I will have to look "fresh"
0
 
LVL 8

Author Comment

by:ApexCo
ID: 26108893
The SRS URL is correct, and I can definitely hit the report server from the CRM server, but it does prompt for auth. (is that my issue?)

The reports 'runs', but no data is returned and all the images show a red 'x' instead of the image.

I checked the Kernel Mode auth, and it is enabled.

AppPool is running Network Service.
0
 
LVL 8

Author Comment

by:ApexCo
ID: 26108991
And just for reference, this is what I'm seeing.

error.jpg
0
 
LVL 8

Author Comment

by:ApexCo
ID: 26109028
Additionally, the connector has been successfully installed on the SQL Server.

Is there any kind of configuration for the connector? I'm assuming the CRM server just knows how to handle it all once you specify the report server URL.
0
 
LVL 8

Author Comment

by:ApexCo
ID: 26113174
I grabbed another error from the application log, from the server that is running the actual CRM. Maybe it will help.

And I've tried using SQL auth this morning, Windows auth (on the report server config, and messing with the different settings in the MSCRM_Datasource on the reports server), to no avail.


Exception information:
    Exception type: CrmReportingException
    Exception message: An error has occurred during report processing. (rsProcessingAborted)


Thread information:
    Thread ID: 17
    Thread account name: NT AUTHORITY\NETWORK SERVICE
    Is impersonating: False
    Stack trace:    at Microsoft.Crm.Web.Reporting.SrsReportViewer.SetExecutionCredentials(ServerReport report)
   at Microsoft.Crm.Web.Reporting.SrsReportViewer.ConfigurePage()
   at Microsoft.Crm.Application.Controls.AppUIPage.OnPreRender(EventArgs e)
   at System.Web.UI.Control.PreRenderRecursiveInternal()
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
0
 
LVL 8

Author Comment

by:ApexCo
ID: 26113238
Ok, this is really odd.

If I connect to http://servert/reports and click on the organization I can see all of the reports/datasources, etc.

If I connect to http://localhost/reports from the SQL server itself, nothing is inside the organization. But if I try to add something with the same name it says it already exists??


0
 
LVL 8

Author Comment

by:ApexCo
ID: 26113267
Ok, I'm an idiot, I didn't have 'show details' clicked, ugh.


0
 
LVL 15

Expert Comment

by:WilyGuy
ID: 26113459
OK, so sounds like you have done quite a bit.  Obviously SRS worked before this CRM server move, so unless you moved something within SRS, I wouldn't mess with that.

might be best to Republish the reports.  How many custom reports do you have?

So go into ReportManager and Show Details.  Then click the Edit button next to the whatever_MSCRM and put something like RE- in front of the name.  This will preserve that instance in case the republish doesn't help.

Next go to CRM server and open a command prompt.  go to the equivalent of C:\Program Files\Microsoft Dynamics CRM\Tools

Then run publishreports "whatever" (where whatever is the name of the Org, try to be case sensitive here not sure if it matters).

This should recreate the SRS folder in Report Manager (so now you should have 2 folders).  Check this, then check the Reports.  An IISRESET is nice on SRS and CRM to make sure nothing is cached.


0
 
LVL 8

Author Comment

by:ApexCo
ID: 26113631
Morning,

I've already done the republish (yesterday) and it didn't have any effect for me.

I enabled detailed errors and this might help a bit. See screenshot, is anything not right here?

detailed-error.jpg
0
 
LVL 8

Author Comment

by:ApexCo
ID: 26113671
I neglected to mention, that I uninstalled SRS from the old server without realizing it needed to be there.

Then reinstalled it again.
0
 
LVL 8

Author Comment

by:ApexCo
ID: 26113693
I think I have this nailed down to being unable to connect to the DB, but I just don't know how to fix it.

Microsoft CRM Error Report:
Error Description:
An error has occurred during report processing. (rsProcessingAborted)

Error Details:
An error has occurred during report processing. (rsProcessingAborted)

Full Stack:
[ReportServerException: For more information about this error navigate to the report server on the local server machine, or enable remote errors]


[ReportServerException: Cannot create a connection to data source 'CRM'. (rsErrorOpeningConnection)]


[ReportServerException: An error has occurred during report processing. (rsProcessingAborted)]
   at Microsoft.Reporting.WebForms.ServerReport.GetExecutionInfo()
   at Microsoft.Reporting.WebForms.ServerReport.GetDataSources(Boolean& allCredentialsSet)
   at Microsoft.Reporting.WebForms.ServerReport.GetDataSources()
   at Microsoft.Crm.Web.Reporting.SrsReportViewer.SetExecutionCredentials(ServerReport report)

[CrmReportingException: An error has occurred during report processing. (rsProcessingAborted)]
   at Microsoft.Crm.Web.Reporting.SrsReportViewer.SetExecutionCredentials(ServerReport report)
   at Microsoft.Crm.Web.Reporting.SrsReportViewer.ConfigurePage()
   at Microsoft.Crm.Application.Controls.AppUIPage.OnPreRender(EventArgs e)
   at System.Web.UI.Control.PreRenderRecursiveInternal()
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

[HttpUnhandledException: Exception of type 'System.Web.HttpUnhandledException' was thrown.]
   at System.Web.UI.Page.HandleError(Exception e)
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
   at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
   at System.Web.UI.Page.ProcessRequest()
   at System.Web.UI.Page.ProcessRequest(HttpContext context)
   at ASP.reachouthealthcareamerica_crmreports_rsviewer_reportviewer_aspx.ProcessRequest(HttpContext context)
   at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
   at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)


 


0
 
LVL 15

Expert Comment

by:WilyGuy
ID: 26113770
Hmm, "old server"????

Was this an all in one CRM/SQL/SRS and you have moved CRM?

Where is SRS installed?  on CRM server or SQL server?  Which version of IIS?  Is Anonymous turned on on the website?  what about each virtual directory (ReportServer and Reports)?

So SRS was uninstalled at some point...so you reinstalled and recreated the configuration, pointing to the existing ReportServer and ReportTemp DBs?

Have you uninstalled the SRS Data Connector?  Then Reinstalled?  You said "Reinstalled" but that could just mean you repaired.  I assume you re-applied whatever Rollups you had?

The screenshot is fine, but obviously there is more on each tab and there is scrolling on each screen...
0
 
LVL 8

Author Comment

by:ApexCo
ID: 26113792
Ok, the only setting that works on the Reports manager is this:

Credentials supplied by the user running the report

I've tried every other connection type and if it's set to anything other than that, I get the database connection errors. With that one I just get the blank report as seen in the image above.
0
 
LVL 15

Expert Comment

by:WilyGuy
ID: 26113798
Did you Web Service identity change for SRS?  (what is running the App Pool? for SRS)
0
 
LVL 15

Expert Comment

by:WilyGuy
ID: 26113808
This is in the Data Source inside the 4.0 folder?
I assume this is the CRM Data Extension string?
0
 
LVL 8

Author Comment

by:ApexCo
ID: 26113859
Here is current situation:

Original CRM server was an all-in-one. Only CRM was moved to new server (Virtual8) and the database was left intact on original. Mistakenly uninstall SRS connector, but SSRS was never removed from original.

Reinstalled SRS connector and pointed it to existing ReportServer. Well actually it only gave me the option during setup to point it at the Server, so I assume it did just that.


0
 
LVL 8

Author Comment

by:ApexCo
ID: 26113873
The Web Service Identity is set for Network Service and that is also running the AppPool for SRS.

The Data Source is inside the 4.0 Server. Set for Data Extension.
0
 
LVL 8

Author Comment

by:ApexCo
ID: 26114210
I just took a look at the RDL files and they were all pointing to 'localhost'

I updated them to the proper DB server and catalog and I still get the same blank report.
0
 
LVL 15

Expert Comment

by:WilyGuy
ID: 26114396
So correctly setup you should see the type as Microsoft CRM Data Extension, the string as MSCRM Data Connector Connection String and the Connect using: Credentials supplied by the user running the report.

All what you have apparently.  Does the Deployment Manager show the correct Servers for the CRM Full Server and the SRS Server?

Also, what is in the PrivUserGroup, the SQLAccessGroup and the PrivReportingGroup in AD?
0
 
LVL 8

Author Comment

by:ApexCo
ID: 26114502
Yes, the data source in the parent has the connection string and using SQL. And the data source inside the 4.0 folder is as you wrote above.

Deployment manager shows both server, one as CRM and the other as the connector. (versions are different though, should they be same?)

PrivReportingGroup = ServerT and Virtual8
PrivUserGroup = all the necessary users
SQLAccessGroup = ServerT and Virtual8
0
 
LVL 8

Author Comment

by:ApexCo
ID: 26114550
I cannot even run reports from the report server manager using http://servert/reports. Just tried to do so and grabbed this error from the SQL server application log.

Process information:
    Process ID: 2632
    Process name: w3wp.exe
    Account name: NT AUTHORITY\NETWORK SERVICE
 
Exception information:
    Exception type: WebException
    Exception message: The remote server returned an error: (403) Forbidden.


This has GOT to be a permissions issue, The network service has rights to everything on the databases that it needs.
0
 
LVL 8

Author Comment

by:ApexCo
ID: 26114818
Well I have gotten rid of the (403) Forbidden error by setting the Network Service up to be able to write to the temp asp.net files directory.

However, I still get the same blank reports with the javascript errors. I just don't get it.

No errors in any logs now, on either the CRM or SRS server, it just doesn't work.
0
 
LVL 8

Author Comment

by:ApexCo
ID: 26119516
Ok, wanted to update what I did last night/early today.

I installed SQL 2005 on the same server CRM is on, patched everything up and then setup SSRS. Got CRM talking to it, changed the report server in deployment manager and it automatically published all the reports correctly with the proper datasource.

I go to run it, and I get the same thing :(

Tried it just straight SSRS and with the CRM connector as well.

Merry Christmas to me :)
0
 
LVL 8

Author Comment

by:ApexCo
ID: 26131977
In case anyone is still monitoring this thread...I have made some progress.

After working the security settings/permissions I'm able to run reports successfully from the report manager (could not do that before) and I'm seeing a different screen when I try to run report from CRM.

The red x's are gone and now the entire thing is just blank.



error2.jpg
0
 
LVL 8

Author Comment

by:ApexCo
ID: 26206801
I'll  update this with MS Support has been engaged. 14 hours on the phone, sharing sessions, etc. and they are just as lost as me.

If they figure this out I'll be sure to post the solution for the good of all mankind.
0
 
LVL 8

Author Comment

by:ApexCo
ID: 32340056
I completely forgot to update this thread.
It turns out there was a rogue redirect in the web.config file, buried way down. No idea how it got there, but once that was removed, everything worked as expected.
0

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I showed you how to use console view (HERE (http://www.experts-exchange.com/articles/18379/Getting-Started-and-Using-the-Salesforce-com-Console.html)) -– but how do you set it up on the admin side of Salesforce? Note that you have to have Admin leve…
Note: You must have administrative privileges in order to create/edit Sharing Rules. Salesforce.com (http://www.salesforce.com) (SFDC) is a cloud-based customer relationship management (CRM) system. It is a database most commonly used by sales an…
Loops Section Overview
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
Suggested Courses

864 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question