Implement CRM 365 online or on premise…?

Implement CRM 365 online or on premise…?

For small/Medium Business this is not a question. Budget to buy servers or using VMWare + licenses for CRM, SQL + system are too expensive. The natural answer is CRM online.

Now what about Medium\Large companies…

Big companies with call center (telephone integration) needs faster system, open the forms quickly CRM online can be a problem, too slow the only option is on premise.

CRM online contains latest version of the product with the new features, bug fixing.  

Working with on premise gives the flexibility to work with SSIS (import and export massive data) directly to database, create RDL reports (SQL command) in this case on premise.

Many companies like banks, investment houses cannot export the customer data from the companies outside in this case only on premise can be relevant.

Easy way to upgrade on premise or CRM online depends on the quality of the code, Write only supported and using SDK. In CRM online immediately customer gets the error but in on premise we can install the SP first in development environment, fix code then test environment and if all good in Production.

The conclusion for small/ medium business online can be a good solutions, depend budget, customization, integration code changes.

For large companies for now the only option should be on premise…

Hope in the future Microsoft will improve the performance.

Thanks

Rami Heleg

+972525695114 

Houston, we have a problem – Aysnc Service is down.. Unable to restart.

Houston, we have a problem – Aysnc Service is down.. Unable to restart.

After install Framework in CRM Database server and restart we Got a major problem Async Maintaince Service is down and failed to upload..

　

Error message:

  

Host XXX : failed while monitoring asynchronous operations queue. Exception: System.InvalidCastException: Unable to cast object of type 'System.DBNull' to type 'System.String'.

at Microsoft.Crm.Asynchronous.JobDataAccess.<>c__DisplayClassc.<RetrieveSqlServerName>b__a(Object[] values)

at Microsoft.Crm.Asynchronous.JobDataAccess.ExecuteSqlOrganizationScopeAndProcessRecords(IDbCommand command, Guid organizationId, RecordProcessor recordProcessor)

at Microsoft.Crm.Asynchronous.JobDataAccess.RetrieveSqlServerName(Guid orgId)

at Microsoft.Crm.Asynchronous.JobDataAccess.UpdateJobTargetServer(AsyncJob job)

at Microsoft.Crm.Asynchronous.JobDataAccess.GetNextJob(IList`1 orgsAvailableForMaintenance, DateTime startCycleTime, Int32 maxJobsToReturn)

at Microsoft.Crm.Asynchronous.JobDataAccess.GetNextJobInAppLock(IList`1 orgsAvailableForMaintenance, DateTime startCycleTime, Int32 maxJobsToReturn)

at Microsoft.Crm.Asynchronous.JobDataAccess.SelectJobs(DateTime startCycleTime, Int32 maxJobsToRetrieve)

at Microsoft.Crm.Asynchronous.JobManager.RetrieveAndQueueJobs()

at Microsoft.Crm.Timers.Timer.InvokeElapsedWithCancellationToken(Object state)

at Microsoft.Crm.Timers.Timer.InvokeElapsed()

at Microsoft.Crm.Timers.Timer.TimerProcessor.ExecuteTimers(Object data)

at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)

at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)

at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)

at System.Threading.ThreadHelper.ThreadStart(Object obj)

 

 steps to fould the reason:

1. Use CRM Trace when try to restart the service got the error:


crm 2011 failed while monitoring asynchronous operations queue. Exception: System.InvalidCastException: Unable to cast object of type 'System.DBNull' to type 'System.String'.
In CRM we have 3 organization , disabled specific one Async successs to restart.. then I checked MSCRM_Config – organization table looks perfect like all other organization..


Backup problematic organization DB and remove the organization + try to import this organization got the next error message

The instance name must be the same as computer name.

 

The reason for this problem found by running this command @@servername in sql management…

How to solve:

   

select @@servername - result is NULL (should contain server name)

SP_DROPSERVER "SERVERDBNAME"

SP_ADDSERVER "SERVERDBNAME ", local

　

restart the MSSQLSERVER service

Async Maintanice servce back to life.
  

Enjoy,

Rami Heleg

+972-52-5695114

 

Failed to create Appointment.. get error: Message: Pointer record exists but referenced record of type 8 not found

ERROR to create Appointment.. get error:

Message: Pointer record exists but referenced record of type 8 not found

In my example get in the error message which guid..

Crm Exception: Message: Pointer record exists but referenced record of type 8 not found: 95d0dd28-6a70-e311-9214-005056be5eb7, ErrorCode: -2147220969

The solution:

Search in resource the record - use Database.

select * from ResourceBase

where Resourceid　 = '95d0dd28-6a70-e311-9214-005056be5eb7'

and remove the record.

DELETE FROM ResourceBase WHERE ResourceId='95d0dd28-6a70-e311-9214-005056be5eb7''

problem to fix in online

Enjoy,

Rami Heleg.

"SYSTEM user account not found"

Set regarding field and in log get the next message "SYSTEM user account not found"

 

The reason for this message belongs to BU. Be sure in security role read Users with full read. The reason user System belong to the top business Unit and current user belong to a diffident business Unit

 

Enjoy,

Rami Heleg

Open Microsoft Dynamics CRM in Application mode

Tool Tip: Open CRM Application in browser window without menu and command bars

go to:

Administation - > System Settings
Select Customization Tab and check box the value of

Open Microsoft dynamics CRM in Application mode = true

very usefull for CRM 2011.

Thanks,
Rami Heleg

Build Fetch based advanced find (download Fetch Xml)

In CRM 4 to build fetch via advanced find windows we worked  like this example:

http://rami-heleg.blogspot.com/2009/10/fetch-query.html

( using Java script – alert).

In CRM 2011 Microsoft added a sample button to advanced find which help developer to import the FETCH XML.

Export the Fetch using button download Fetch Xml.

Thanks,
Rami Heleg.