Wednesday, March 31, 2010
I created a dedicated site for my tools. This site is quite basic but provide links to download the tools and a small tutorial for each one of them.
I thought it is a better way to distribute the tools to my (or your) customers, partners and colleagues since it avoid to go through the blog (even if the tools are quite easily accessible).
The link: http://mscrmtools.wordpress.com
I hope you will like it...
Saturday, March 27, 2010
- 2 minutes to delete a single record
- Timeout on restarting the Microsoft CRM asynchronous processing service
- Unable to display a view on workflows or system tasks.
- Incredibly long time wait for any SQL statement on AsyncOperationBase table
- AsyncOperationBase (800 000 lines)
- DuplicateRecordBase (15 000 000 lines)
No job systems, workflow and detection of duplicates job will be retained.
All running workflows will also be deleted
- The size of the database is 2GB
- The asynchronous processing service restarts in no time
- Record deletion is very fast
- Fast display of system tasks, workflow logs, etc.
- Planning tasks to delete bulk to clean the table of system tasks regularly.
- Disable the detection rules that are duplicates or not involving fields ever used. By default, if you create many prospect without email address, default duplicate detection rule applies and therefore generates many rows in the table DuplicationRecordBase.
Wednesday, March 24, 2010
I just updated three of my tools to make them faster and lighter:
The average weight of the tools was 1,2MB. It is now 350KB
Also, the first call to the crm web service is faster as there is so much less data to load
Monday, March 22, 2010
How to create a relative URL in site map to static content under the ISV folder in CRM 4
Saturday, March 20, 2010
Tuesday, March 16, 2010
Thursday, March 11, 2010
Thanks to Andrew Zimmer, a bug has been corrected in the tool.
This bug made the tool decoding the HTML characters that were encoded when exporting the customizations. So when you were importing them back, the HTML characters were no more encoded...
You can download this latest version from the usual location (right pane of the blog)
Tuesday, March 9, 2010
- Tooltip on each privilege to see the privilege ID
- A "name" resolution is made against the object ID specified (I use the primary attribute of the entity)
I will focus next on the peformance of the tool (I need to do some clean up on the CrmService reference to speed the tool)...
Friday, March 5, 2010
It's been a while that I'm back but I have a lot of work and so little time for this blog.
However, things promise is a promise, here is a small tool that could make your life easier.
Have you ever encountered this error message:
SecLib::AccessCheckEx failed. Returned hr = -2147187962, ObjectID: 1ef9f412-6601-dd11-8655-0019b9dfe618, OwningUser: 98bbc999-96a2-de11-aeaf-0019b9dfe227 and CallingUser: 037c1c90-96a2-de11-aeaf-0019b9dfe227
You do not really know what object and what user it is and especially what rights might fail him. With this tool, you can put all these IDs and know what are the privileges of the user regarding this record.
With this tool, you can:
With this tool, you can:
- Indicate which entity you want to inspect
- Enter the identifier of the object in question
- Searching for a user with its name or its unique identifier
As usual, if you need improvment or detect a bug, do not hesitate to contact me
The tool can be downloaded just below (and in the archive with all tools)