13 March 2009

CRM 4.0 Update Rollup 3

Microsoft released the RollUp 3 for MSCRM 4.0, this time including the rollup for SRS data connector, as usual it was packed into 64/32 bits version. You can get it from the link below
Download Here


Details of the Rollup 3 documented in
KB961768

02 March 2009

Failed to upload report on CRM 4

If you hit weird error on CRM while you try to upload a report, you might need to read this.
It seems some of the DLL in CRM application server failed to read/write.
I get this in the SQL error logs

ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An unexpected error occurred in Report Processing., ; Info: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An unexpected error occurred in Report Processing. ---> System.IO.FileLoadException: Could not load file or assembly 'Microsoft.ReportingServices.ProcessingObjectModel, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. Access is denied.File name: 'Microsoft.ReportingServices.ProcessingObjectModel, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91'

You also can see this in CRM FE event viewer:
Web service request CreateReport to Report Server http://servername/ReportServer/ReportService2005.asmx failed with SoapException. Error: An unexpected error occurred in Report Processing.

Solution:
Make sure the user have the modify permission in the directory "C:\WINDOWS\microsoft.net\Framework64\v2.0.50727". (If you use 32bits, it will be "Framework" instead of Framework64)
Required by the folder [Temporary ASP.NET Files]