Search This Blog

Monday, December 15, 2008

Use your own parameters in Crm forms url

Hi all,

Out of the box CRM 4.0 doesn't allow custom parameters in CRM Form url

But you can change that! You must edit the MSCRM registry located in : HKEY_Local_Machine\Software\Microsoft\MSCRM

Create a new DWORD named "DisableParameterFilter" and set it to 1.

You can now use custom parameters!

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()

Your report is empty when you execute it

When you execute a report, you can have a light blue empty screen instead of your report

There's a KB article from Microsoft about this problem (
http://support.microsoft.com/kb/942672).

In my case, the primary key field was correctly set to "Yes", so I just set it to "No", saved, and reset it to "Yes" and published the entity.

It works now like a charm !

Tuesday, December 9, 2008

Error while installing CRM Microsoft.Crm.Setup.Server.CreateSetupUserAction

If you try to install Microsoft Dynamics CRM on a server that was already used to test an installation, it is possible that the server keep the previous installation date and when you try the new installation, the trial period or the registration period may have expired.



The message in the installation log will be :

Error System.Exception: ActionMicrosoft.Crm.Setup.Server.CreateSetupUserAction
failed. --->System.Runtime.InteropServices.COMException (0x8004415C):
Exception fromHRESULT: 0x8004415C.


The 0x8004415C code indicates that the CRM has expired

To resolve this, keep the installation form and launch the registration wizard. Once you completed it, click Retry and everything should be OK

Monday, December 1, 2008

Error when creating a queue, it looks like a bug

My colleague Didier, and I, have discovered a strange behavior with security roles and queues.
When you look at the SDK for minimal set of privileges required to create a queue, you can see the following list:
  • prvAppendQueue
  • prvAppendToUser
  • prvCreateQueue

There is just one problem… In the security role interface, there is no Append privilege for Queue, so you can’t set it to enable Queue creation.

image

This problem makes the Queue creation form difficult to use as the lookup controls are disabled but mandatory... You also need to know that this problem occurs only with security role you created from scratch.

image

To resolve this problem, there are two solutions:

  • Copy the administrator role (which contains the Append privilege on Queue entity, even if it’s not visible) and remove inappropriate privileges.
  • Export the role, and add the following XML line in the appropriate role node:

<privilege name="prvAppendQueue" depth="Global" />
  • Import the role you changed

Sunday, November 30, 2008

Searchable Propery Attribute Updater

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:

The first post (hopefully not the last one)

Hi everybody,

Here is a new blog about Microsoft Dynamics CRM... "One more!" you're thinking...? Yes, one more, but one that provides you useful tools to make your life easier while working with MSCRM.

Here's a list of what I will provide soon:

  • A program to update the searchable property of all attributes for an entity in a single form: it will avoid you to navigate through all attributes form.
  • A program to replicate a view display to all other views of the same entity: again, you won't have to navigate through all views forms to update them

Of course, if you need a specific tool to facilitate your work and don't know how to do, just explain me what you want: maybe I could write it for you