Sunday, October 10, 2010

How to create a new organization/ import organization and prevent from insert report service URL…?

Everyone know to create/import organization must insert report URL.


We can prevent insert the report URL and of course success to create organization …

How to do that….?


Add the IgnoreChecks registry key to the computer that is running Microsoft Dynamics CRM 4.
 click Run, type regedit, and then click OK.
In the registry, locate the following subkey:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSCRM
Right-click MSCRM, point to New, click DWORD Value, and then type IgnoreChecks.  + set Value 1.
Sceen shots:








Thanks,
Rami Heleg

Saturday, October 9, 2010

Failed to open CRM. get error message License Expired.

Hi,
  Open CRM and get error message in CRM+ in event viewer “license expired”.
  Error message appears in two modes.

  1. The first case when the license expired.
  2. When service MS Async Service is down.

Go to services windows, select Async service and run again.
Thanks,
Rami heleg

Find CRM entity name by ObjectID

Everybody knows this strange error message from CRM trace logs: Error Message: SecLib::AccessCheckEx failed. Returned hr = -2147187962, ObjectID: 48355f9a-96c5-df11-90dc-00145ebd47b6, OwningUser: 6d04898c-db79-df11-83b4-00145ebd47b6 and CallingUser: 9cfc1a56-da79-df11-83b4-00145ebd47b6.
CRM failed to perform some action on an entity with ObjectID = 48355f9a-96c5-df11-90dc-00145ebd47b6
The error does not contain the problematic entity name I prefer to know.
So I wrote the SQL script that helps me to find an entity name by ObjectID

DECLARE @objectId uniqueidentifier

SET @objectId = '41DC59A0-96C5-DF11-90DC-00145EBD47B6' – Set your ObjectID here
DECLARE @entityName nvarchar(255), @baseEntityName nvarchar(255), @primaryKeyColumnName nvarchar(255), @sql nvarchar(max), @isActivity bit
DECLARE cur CURSOR FOR SELECT Name, BaseTableName, IsActivity from Entity with (nolock) where IsValidForAdvancedFind = 1
OPEN cur
FETCH NEXT FROM cur INTO @entityName, @baseEntityName, @isActivity
WHILE @@FETCH_STATUS = 0
BEGIN
if(@isActivity = 1 OR @entityName = 'ActivityPointer')
SET @primaryKeyColumnName = 'activityid'
else
SET @primaryKeyColumnName = @entityName + 'id'
SET @sql = 'IF EXISTS(SELECT ' + @primaryKeyColumnName + ' FROM ' + @baseEntityName + ' WHERE ' + @primaryKeyColumnName + '=''' + CONVERT(nvarchar(36), @objectId) + ''') SELECT ''' + @entityName + ''''
exec(@sql)
IF @@ROWCOUNT > 0 BREAK;
FETCH NEXT FROM cur INTO @entityName, @baseEntityName, @isActivity
END
DEALLOCATE cur

Thanks,
Max s

Thursday, September 23, 2010

Define opening CRM as a application

Go to system setting
Select tab: Personal Settings

Select the check box like the image linked
Close the explorer and open the CRM again.



Thanks,
Rami Heleg

Wednesday, September 15, 2010

Failed to install CRM 4.0

Failed to install CRM 4.0.

Failed to install CRM 4.0 and get error message
"the account specified to run the microsoft dynamics crm asynchronous processing service does not have performance counter permissions..."

in Microsoft Dynamics CRM Setup windows.

The reasons can be:
installer must be local admin.
define CRM to run CRM in a user which is not local admin. ( enable to view this data after install in iis - application pool)

Thanks,
Rami Heleg

Monday, August 16, 2010

Get CrmService for specific organization.

I have many organizations and I need the entities for specific organization

The solution


Create crm service where URL contain
?uniquename=org_name

for instance:
http://servername/MSCRMService/2007/Crmservice.asmx/?uniquename=org_name
enjoy,
Rami Heleg

Monday, August 9, 2010

Working with GAC

I CRM 4.0 usual is to work with GAC (Global assembly cache)
Replace file, delete file, copy file.
If failed to delete or copy file from GAC
Make the next instructions:
How to view windows/assembly folder
1. Open Regedit, browse to HKLM\Software\Microsoft\Fusion.
2. Add a REG_DWORD value named 'DisableCacheViewer'; set it to 1
3. open an Explorer window and type in C:\WINDOWS\assembly\GAC_MSIL\

Open GAC ( c:\windows\assembly\msil and copy the relevant file and remove
After finish change 'DisableCacheViewer' to 0
Thanks
Rami Heleg.