We got following error message after installing plug on one of the CRM Server
The description for Event ID 18960 from source MSCRMKeyService cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.
If the event originated on another computer, the display information had to be saved with the event.
The following information was included with the event:
CrmWRPCTokenKey
f0f324a8-e843-df11-a4bc-0026551afb74
00000000-0000-0000-0000-000000000000
the message resource is present but the message is not found in the string/message table
Cause
This error comes if you have importing plug in steps (i.e. import xml) using plug in registration tool
Resolution
Manually create the plug in steps and then restart CRM website (i.e. iisreset) and also restart CRM asynchronous service.
Cheers,
MayankP 
Like this:
Be the first to like this post.
Sometime back I posted on how to change/delete read only records in Dynamics CRM but this does not work for contract.
Contract record once becomes active/invoice there is no supported way to change the contract back to draft. So I created custom workflow activity which allows users to change contract back to draft.
Once contract is in draft state, user can change any fields or delete the contract from the system.
I have shared this utility on CodePlex at Here
This application also contains some other contract utility. Following are the details steps regarding usage of this application
Step 1: Download the application files and register this assembly using plug in registration tool
Step 2 : Once assembly is registered successfully, go to setting and create new workflow against contract, make sure contract is owner by admin user who have access to modify the database tables.
Step 3: Call this workflow “Change Status to Draft” and add step from Contract utilities -> Change Status to Draft. (As per following screen print).
Step 4: provide input parameters (i.e. database connection to string)
Step 5: Now publish the workflow.
Step 6: go to contract screen and run this workflow against relevant active/invoiced contract record and this workflow will make contract draft. Now user can change any field on this contract or delete the contract now
Note: This is unsupported customization, Please unit test this module on your development/test environment before applying it to Live Environment..
Like this:
Be the first to like this post.
Dynamic CRM workflow can generally only be published by owner. If you want to assign workflow to different support/sales manager and publish the workflow on their behalf then CRM does not allow you do it…
Then I found out about impersonation in CRM, as per this user account under which the impersonation code is to run must be added to the PrivUserGroup group in Active Directory. So your user account or admin user account who should have privileges to run code on behalf of someone else.
Once you have above things set up then it becomes easy do above task (i.e. Publish the workflow on behalf of someone else)
Following are steps to achieve this in Dynamics CRM.
Step 1: Add new button to workflow screen using ISV.Config.
This would look like as follows..
Step 2: Write Java script code for to publish the workflow one behalf to current workflow owner. If workflow is already published then unpublish the current workflow.
Download the java script code
Hope this helps..
Cheers,
MayankP:)
Like this:
Be the first to like this post.
This question is one of the most frequently asked questions by CRM developers/administrators.
Following are few different ways to get this information for Dynamic CRM.
Option 1: Add or Remove Programs
Go to Control Panel and click Add or Remove Programs
Select Show updates and this will show relevant roll up details as mentioned in the following figure.
This is client side screen print and for the server you need to go on to server and check same thing in Add or Remove Programs.
Option 2: Using CRM about US Dialog box
Go to Outlook and Click on “CRM” button in CRM outlook Toolbar and it will displays the client (outlook) and Server roll up number of CRM system as shown in screen print below.
Option 3: Checking Database Table
Run following query against relevant CRM database and query result will details relevant installed version for CRM system.
Also check following is a list of CRM rollups and their release info, match the details (i.e. Version number) got through above option and you will know which roll up is installed on your CRM system easily.
Version Build
RTM 4.0. 7333.3
Rollup 1 4.0.7333.1113
Rollup 2 4.0.7333.1312, 4.0.7333.1316
Rollup 3 4.0.7333.1408
Rollup 4 4.0.7333.1551
Rollup 5 4.0.7333.1644, 4.0.7333.1645
Rollup 6 4.0.7333.1750
Rollup 7 4.0.7333.2138
Rollup 8 4.0.7333.2542
Rollup 9 4.0.7333.2644
Cheers,
MayankP
Like this:
Be the first to like this post.
“How to Find cases where activities (emails, phone, task etc.) modified last 1 month?”
Above is the question, One of our customer asked me last week and they wanted to do advanced find on cases and find out the cases which have activities (emails, phone, tasks, service activity etc…) created/modified in last 1 month.
Now I first thought was this is not possible through standard advanced find because I thought you can do condition with multiple entities (email, task etc.) but there is no way we can do OR conditions for multiple entities in dynamics advanced find screen.
But then realized that all activities are derived from the same base activity class, so we can use that and turn out there is already field called “Last Updated” (date field) on activity..
So turn out this is really simple advanced find as per following screen print.
Cheers,
MayankP
Like this:
One blogger likes this post.
One of my colleagues has showed me this cool trick…
So many times you need to write code where you needed to append strings values from a field in SQL Table and all the times people uses different approach…cursors, CTE, WHILE loop, doing it from the front end…etc. in SQL
Following is one very cool approach to achieve this in SQL using XML Path.
Hope this helps…
Like this:
Be the first to like this post.
CRM 3.0
When you export records from CRM 3.0 to Microsoft Excel only the first 10,000 rows are exported. Unless you scroll to the end of the spreadsheet there isn’t any kind of indication that a limit has been reached. The following post from Microsoft walks you through the steps necessary to increase the limit.
http://support.microsoft.com/kb/911395
CRM 4.0
To change this in CRM 4.0:
1. Log-in to the SQL Server where the _MSCRM database is stored
2. Open the OrganizationBase table
3. FInd the Column: MaxRecordsForExportToExcel
4. Change the value from 10,000 to the desired value
5. Committ the change to the database
Like this:
Be the first to like this post.
