Reporting Point Error after R2 Upgrade

Benoit LecoursSCCM, SSRSLeave a Comment

This post explain how to fix Reporting Point Error after R2 Upgrade. Problem : After upgrading from SCCM 2012 SP1 CU2 to SCCM 2012 R2. You get the following error when running reports : An error has occurred during report processing. (rsProcessingAborted) Cannot read the next data row for the dataset DataSet1. (rsErrorReadingNextDataRow) Conversion failed when converting the nvarchar value ‘S-1-5-21-1010946700-728571707-39459515-134623’ to data type int. Removing and adding the “Reporting Service Role” did not fix the issue. SRSRP.log has Invalid Class errors : Invalid class SMS_SRS_REPORTING_POINT 07/7/2014 1:52:12 PM 6096 (0x17D0) Could not retrieve the reporting service name for instance ‘RPSERVER’ … Read More

Win32_TPM Class in Hardware Inventory is missing Data by Default in Configuration Manager 2012

Nicolas PilonSCCM28 Comments

In Configuration Manager 2007, we were querying WIN32_TPM in hardware inventory for laptop security report. After the 2012 migration, the report was returning no value on this specific class. The usage of Bitlocker rely on TPM (Trusted Platform Module). We found by looking in the SQL query of the report that IsActivated, IsEnabled and IsOwner were selected but missing from 2012 inventory. This is collected throught hardware inventory so I decided to take a look at the default client settings. As you can see the screenshot below, WIN32_TPM class in hardware inventory is configured by default in Configuration Manager 2012 with missing information of the WMI class.  To remediate … Read More

SCCM 2012 R2 CU2 Released

Benoit LecoursSCCMLeave a Comment

SCCM 2012 R2 CU2

Microsoft has just released SCCM 2012 R2 CU2. ****Updated : Full installation guide here**** Follow the link for a full list of issues fixed by CU2 : As per my previous post, the Start-CMPackageDeployment is now fixed  🙂 Client Version has been updated : SCCM ConfigMgr 2012 R2 CU2  Client Version:-  5.00.7958.1203 SCCM ConfigMgr 2012 R2 CU2  Endpoint Protection Client Version:-  4.5.0216.0 Reminder about Cumulative Update : From Technet : Each CU is considered a large hotfix. Therefore, the general guidance is to install it if you are encountering, or believe you may encounter, one of the issues fixed by … Read More

KB2919355 The Software Change returned Error Code 0X87D0070C

Benoit LecoursSCCM14 Comments

This post is an how-to-guide on how to fix :  KB2919355 The software change returned error code 0X87D0070C KB2919355 Update is a cumulative update that includes all previous released security updates and non-security updates that were released before March 2014. This cumulative update is available for deployment using the software updates into Configuration Manager. When trying to install this update with SCCM your gets a failed status in Software Center. When looking at the error details, you get : “The software change returned error code 0X87D0070C (-2016409844)“ This get translated to : “Software update execution timeout”. Looking at the Software … Read More

Start-CMPackageDeployment – Impossible to create a Required Package Deployment using CMDLET

Benoit LecoursPowershell, SCCM12 Comments

**Edit 2014/10/31 : I’m still struggling to make this cmdlet work with a Required schedule even if Microsoft says it’s fixed. If you have been able to make it work, leave a comment in this post. ** **Edit 2014/06/27 : This issue is supposedly fix with R2 CU2 ** The Start-CMPackageDeployment cmdlet is failing with the following error when creating a “Required” deployment with a schedule. Example : Start-CMPackageDeployment -CollectionName “$Name” -PackageId $PkgId -StandardProgramName “Install”  -DeployPurpose Available -DeploymentAvailableDay “2014/06/13” -DeploymentAvailableTime “12:12” -DeploymentStartDay “2014/06/19” -DeploymentStartTime “2:45”-RerunBehavior RerunIfFailedPreviousAttempt -SoftwareInstallation $True -SystemRestart $False Error : Start-CMPackageDeployment : Parameter set cannot be resolved using the specified named parameters. The … Read More

Report Subscription in SSRS does not list Email in Drop Down Menu

Benoit LecoursSCCM, SQL, SSRS6 Comments

What can you do when your report subscription in SSRS does not list email in drop down menu? Symptoms When you first try to create an email subscription in SCCM 2012, you only have the Windows Share choice in the drop down menu. Email is missing from the list. Cause The principal cause of this issue is that your SSRS is not configured properly to send emails. Resolution Log to your SSRS server Open Reporting Service Configuration Manager Click on the Email Settings tab Enter the settings of your sender address and SMTP server Click Apply Verification Once completed, go back in SCCM … Read More

Failed to decrypt Cert PFX Data

Benoit LecoursSCCM2 Comments

Symptoms : Distmgr.log shows lot of “Failed to decrypt cert PFX data” errors You have shared DP enabled You have the same numbers of errors than you have shared Distribution Points Resolution You can safely ignore these error. I’ve made some test on my side and the error will goes away when you reassign distribution point to your 2012 hierarchy. After reassigning a distribution point you’ll see 1 error less in the log. At the end of your migration the error will be completely gone. This error happens because your 2007 DP certificates are not “known” to 2012. More : Technet discussion on … Read More

Endpoint Protection Policy is not Applied

Benoit LecoursSCCM, SCEP4 Comments

This post explains what to do when Endpoint Protection policy not applied Symptom The policy was applied to a specific collection and all members of the collection were failing to apply the policy Monitoring / Endpoint Protection Status / System Center 2012 R2 Endpoint Protection Status / Operational State 12 clients are failing to apply the custom policy. Clicking on the “Antimalware policy application failed” brings us to the list of machine. On the bottom, clicking on the “Antimalware Policy” tab shows the error : 0x80004005 – Failed to generate Antimalware policy file Let’s look at the EndpointProtectionAgent.log on one of the … Read More

Browsing Sites in Create Boundary Section won’t provide Multi-Domain Active Directory Sites

Nicolas PilonSCCM9 Comments

One of the fundamentals aspect of configuration manager is the boundary because you can’t manage anything without a boundary.  (Thanks to Torsten for pointing that it’s possible to manage client without a boundary).  There’s different types of boundary like, IP subnet, IP address range, IPv6 prefix and active directory site. The last one is the recommended method and it’s the easiest to manage. We recently migrate our infrastructure to SCCM 2012 and we have an issue during the boundary configuration. What happen if you have 2 domains with the same active directory site? No big deal, both will be detectable … Read More

Understanding the Reassign Distribution Point Process

Benoit LecoursSCCM, SQL5 Comments

Here’s a detailed post on the process of upgrad (RTM,SP1) / reassign distribution point from 2007 during your migration project. What really happens when you click on “Reassign Distribution Point” on ConfigMgr 2012 R2: ? How to track the progress ? The process is quite simple : 1. Removal of DP role in the 2007 site 2. Delete site system record in the 2007 site 3. Delete shared DP role in the 2012 site 4. Delete shared DP site system record in the 2012 site 5. Install a new site system in the 2012 site 6. Install a new DP role in … Read More