Error when executing CRM v3 report in CRM v4 : Report render failure. Error: The 'CRM_FullName' parameter is missing a value

Hi,

Get an apparently difficult error with my CRM 3.0 custom reports used in CRM 4.0. I got this unuseful generic error dialog box when executing my report.
In the event viewer, I got the error message :
Report render failure. Error: The 'CRM_FullName' parameter is missing a value

But my dataset seemed correctly coded and everything worked fine using Business Intelligence Studio.

In fact, due to the new report render mechanism in CRM 4.0, the user who executes the report is no more the current user but the application pool system account.

So, what's the problem? In CRM 3.0, you used the following query to retrieve user name:

select fullname from FilteredSystemUser where domainname = SUSER_SNAME()


This not work anymore as the user executing the report is not the current user (in my case, was Network service which has no fullname).

The solution is quite simple, see in standard reports how it works. You will find this query:

select fullname from FilteredSystemUser where systemuserid =
dbo.fn_FindUserGuid()

Comments

Anonymous said…
This solved my issue and worked for me. Many Thanks. We were using CRM 3.0, upgraded to 4.0 and all was fine for years, but recently we decided to move the DB to a new server and that's when the issue happened.
June 29, 2011 at 4:01 PM
Post a Comment

Popular posts from this blog

New XrmToolBox plugin : Import/Export NN relationships

Image
Two plugins in one day! wow! This one was, in fact, developed a couple of months ago. One of my colleague was using a solution from my fellow MVP Andrii Butenko which allows to import/export NN relationships in a silverlight web resource. This was nice but my colleague was using other attributes than primary key to do the mapping and Andrii’s solution does not support this. So he asked me to develop a XrmToolBox’s plugin that could do this. And, here it is! You can select entities and relationships and moreover, choose mapping attributes on both enitities. I only let text and number attributes selectable as other does not really make sense for mapping purposes. Then you can import or export NN relationships! Here is a preview As usual, this plugin, among other, is available with XrmToolBox on CodePlex
Read more

Searchable Propery Attribute Updater

Image
Hi, The previous post was not the last one... :) You can find in this post the first tool that will make your life easier: Just remember when you customer asked you to remove all these unused attributes form the attribute list of the advanced find form... You navigated through all attrbutes form to modify the Searchable property of each attributes for hours... (maybe am I exaggerating a bit...) The program I give you allows you to update all attributes in a single winform application! Yes it can be! Do not hesitate to give me your comments about this program if you think improvements can be done... Download:
Read more

Full featured CRM grid in HTML/JS

Image
In last December, I was asked to write a web resource to display a grid with CRM records. I was quite frustrated because I didn’t succeed to manage some grid features easily like fixed header with horizontal scrolling among others. I delivered a fixed table which was not so bad but absolutely not something that look like the application grid views. So I decided to work harder to find a way to do this CRM style grid view. After some works (almost two full days), I have succeeded to create a full featured CRM grid view by using only JavaScript. Here is a screenshot: And this is how I can create a grid view from only a div in a HTML page < html > < head > < title > Page de test </ title > < script src ="json2.js"></ script > < script src ="jquery.js"></ script > < script src ="XrmServiceToolKit.js"></ script > < script src ="sdk.metadata.js"></ script > ...
Read more