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
Cheers
Albandrod's Memory 