SharePoint 2010 The Execute method of job definition Microsoft.SharePoint.Administration.SPSqmTimerJobDefinition failed

Hi all, after upgrading SharePoint 2010 farms, I’ve found some problems, one of them is the following:

The Execute method of job definition Microsoft.SharePoint.Administration.SPSqmTimerJobDefinition {ID …} threw an exception. Data is Null. This method or property cannot be called on Null values.

How to start which timer job is that? Of course GUI guys tell you: Go to CA/Monitoring/Check Job Status/History/Select Failed jobs
But as you know i like to get the root cause by using Powershell. So open a Powershell window (Sharepoint 2010 Management Shell) and get the given job. We know only the GUID of that. So

$farm = get-spfarm
$timer = $farm.timerservice
$jobs = $timer.JobDefinitions
$jobs | where {$_.ID -eq “<Event log GUID>”} | ft Name

so in that way i got the CEIP timer job (Customer Experience Improvement Program)

What’s that? during the installation i told that i did not want to participate in that program. and now it’s triggered.. hm…

Let’s disable CEIP at farm level first

  • In Central Administration, select System Settings
  • Click Configure privacy options under Farm Management
  • Under Customer Experience Improvement Program, select ‘No, I don’t wish to participate’

Next we should disable CEIP at all web applications as well even in case of the CA.

  • Application Management – manage Web Applications
  • Select the first Web Application in the list and click General Settings
  • At the very bottom of list, select No in the Enable Customer Experience Improvement Program
  • Do that for all Web Applications in the farm

So the final solution/resolution should be to disable this job via the following steps:

  • Click Monitoring then Review  Job Definitions under the Timer Jobs heading
  • In the list, click on CEIP Data Collection
  • At the bottom of the page, click Disable



Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s