File ‘C:\WINDOWS\ccmsetup\NDP452-KB2901907-x86-x64-AllOS-ENU.exe’ returned failure exit code 9.

I’m doing this one from memory, I think in ccmsetup.log there was:

File 'C:\WINDOWS\ccmsetup\NDP452-KB2901907-x86-x64-AllOS-ENU.exe' returned failure exit code 9.  Fail the installation
InstallFromManifest failed 0x80070009

And in the application event log there was:

The description for Event ID 10997 from source MsiInstaller cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.
If the event originated on another computer, the display information had to be saved with the event.
The following information was included with the event:
Product: Microsoft .NET Framework 4.5.2 — Error 997. Error 997. Overlapped I/O operation is in progress.

I found a fix that suggested renaming C:\ProgramData\Microsoft\Crypto\RSA\S-1-5-18 to something like S-1-5-18.backup and then retrying the install.  This worked.

It doesn’t appear from the command line, but it does with Explorer:

20180118 Folder

Taken from Gerd Hübner’s comment on:

https://blogs.msdn.microsoft.com/vsnetsetup/2014/10/27/error-997-overlapped-io-operation-is-in-progress-kb2918614-breaks-windows-installer-service/

Advertisements

SQL for an SCCM report of SQL Standard or Enterprise editions

with IPData (ResourceID, IPAddresses) as
(
select
 n1.ResourceID
, stuff (
(
select ',' + IP_Addresses0 from v_RA_System_IPAddresses n2
where n2.ResourceID = n1.ResourceID and IP_Addresses0 not like '%:%'
order by IP_Addresses0
for xml path('')
),1,1,'') AS IPAddresses
from v_RA_System_IPAddresses n1
group by ResourceID
)
select s.Domain0, s.Name0, c.NormalizedName, ip.IPAddresses
from v_GS_SYSTEM s
inner join v_GS_INSTALLED_SOFTWARE_CATEGORIZED c on c.ResourceID = s.ResourceID
inner join IPData ip on ip.ResourceID = s.ResourceID
where
FamilyName = 'Information Management and Access'
and CategoryName = 'Information and Data Management'
and (c.NormalizedName like '[M,S]%QL Server % Database Engine Services%Enterprise%' or c.NormalizedName like '[M,S]%QL Server % Database Engine Services%Standard%')

SQL for an SCCM report of Windows Server Standard or Datacenter editions

with IPData (ResourceID, IPAddresses) as
(
select
 n1.ResourceID
, stuff (
(
select ',' + IP_Addresses0 from v_RA_System_IPAddresses n2
where n2.ResourceID = n1.ResourceID and IP_Addresses0 not like '%:%'
order by IP_Addresses0
for xml path('')
),1,1,'') AS IPAddresses
from v_RA_System_IPAddresses n1
group by ResourceID
)
select s.Domain0, s.Name0, c.NormalizedName, ip.IPAddresses
from v_GS_SYSTEM s
inner join v_GS_INSTALLED_SOFTWARE_CATEGORIZED c on c.ResourceID = s.ResourceID
inner join IPData ip on ip.ResourceID = s.ResourceID
where
FamilyName = 'Operating Environment'
and CategoryName = 'Operating System and Components'
and (c.NormalizedName like '[M,W]%indows Server%Standard%' or c.NormalizedName like '[M,W]%indows Server%Datacenter%')

“MSI: Could not access network location %APPDATA%\.” in ccmsetup.log

Thanks to http://www.haroldbato.com/2014/03/sccm-msi-could-not-access-network.html

The registry value “AppData” in the HKEY_USERS\S-1-5-18\Software\Microsoft\Windows\CurrentVersion\Explorer\User Shell Folders key is hosed.  For some reason, it’s value is %APPDATA%:

C:\>reg query "\\WORKSTATION.DOMAIN.NAME\hku\S-1-5-18\Software\Microsoft\Windows\CurrentVersion\Explorer\User Shell Folders" /v AppData

HKEY_USERS\S-1-5-18\Software\Microsoft\Windows\CurrentVersion\Explorer\User Shell Folders

    AppData    REG_EXPAND_SZ    %APPDATA%

Change the value to “%USERPROFILE%\AppData\Roaming”.

“Setup was unable to upgrade Sql CE database file” in ccmsetup.log

MSI: Action 8:59:26: CcmUpgradeSqlCEDatabases. Upgrade Sql CE databases that were queued by CcmUpgradeSqlCEDatabasesInit. ccmsetup 1/12/2018 8:59:26 AM 1344 (0x0540)
MSI: Setup was unable to upgrade Sql CE database file UserAffinityStore.sdf.
The error code is 8007007E. ccmsetup 1/12/2018 8:59:26 AM 1344 (0x0540)

Similar fix as “unable to compile”… this time rename C:\Windows\ccm\*.sdf files.

C:\Windows\CCM>dir *.sdf
 Volume in drive C is System Reserved
 Volume Serial Number is A24B-DD40

 Directory of C:\Windows\CCM

01/12/2018  09:39 AM            65,536 CcmStore.sdf
04/11/2016  06:50 AM            32,768 CertEnrollmentStore.sdf
01/12/2018  09:39 AM            65,536 ClientEvents.sdf
05/30/2017  08:53 AM            65,536 ComplRelayStore.sdf
01/08/2018  01:13 PM        49,303,552 InventoryStore.sdf
01/10/2018  01:16 PM           229,376 StateMessageStore.sdf
01/10/2018  12:18 AM           106,496 UserAffinityStore.sdf
               7 File(s)     49,868,800 bytes
               0 Dir(s)  421,985,853,440 bytes free

C:\Windows\CCM>ren *.sdf *.backup

C:\Windows\CCM>dir *.backup
 Volume in drive C is System Reserved
 Volume Serial Number is A24B-DD40

 Directory of C:\Windows\CCM

01/12/2018  09:39 AM            65,536 CcmStore.backup
04/11/2016  06:50 AM            32,768 CertEnrollmentStore.backup
01/12/2018  09:39 AM            65,536 ClientEvents.backup
05/30/2017  08:53 AM            65,536 ComplRelayStore.backup
01/08/2018  01:13 PM        49,303,552 InventoryStore.backup
01/10/2018  01:16 PM           229,376 StateMessageStore.backup
01/10/2018  12:18 AM           106,496 UserAffinityStore.backup
               7 File(s)     49,868,800 bytes
               0 Dir(s)  421,985,853,440 bytes free

 

“Setup was unable to compile Sql CE script file” in ccmsetup.log during upgrade.

File C:\Windows\ccmsetup\{EF4FF44A-5960-4DD5-AC5A-4E10625AEA63}\client.msi installation failed. Error text: ExitCode: 1603
Action: CcmCompileSqlCEScripts.
ErrorMessages:
Setup was unable to compile Sql CE script file C:\Windows\CCM\StateMessageStore.sqlce.
The error code is 80004005.

in C:\Windows\ccm, rename the *.sqlce files.
Thanks to https://windowsbag.wordpress.com/2017/07/25/fix-error-unable-to-compile-sql-ce-script-file-during-sccm-client-install-or-upgrade-80004005/

“File ‘C:\Windows\ccmsetup\Silverlight.exe’ returned failure exit code 1612. Fail the installation” in ccmsetup.log

Seems to be a corrupt install of Silverlight.  Using “How to clean a corrupted Silverlight installation and then reinstall Silverlight” (https://support.microsoft.com/en-us/help/2608523/how-to-clean-a-corrupted-silverlight-installation-and-then-reinstall-s), create a batch file CleanSilverlight.bat with the following and run it locally on the affected client:

reg delete HKLM\Software\Microsoft\Silverlight /f
reg delete HKEY_CLASSES_ROOT\Installer\Products\D7314F9862C648A4DB8BE2A5B47BE100 /f
reg delete HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Installer\Products\D7314F9862C648A4DB8BE2A5B47BE100 /f
reg delete HKEY_CLASSES_ROOT\TypeLib\{283C8576-0726-4DBC-9609-3F855162009A} /f
reg delete HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\App Paths\install.exe /f
reg delete HKEY_CLASSES_ROOT\AgControl.AgControl /f
reg delete HKEY_CLASSES_ROOT\AgControl.AgControl.5.1 /f
reg delete HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall\{89F4137D-6C26-4A84-BDB8-2E5A4BB71E00} /f
rmdir /s /q "%ProgramFiles%\Microsoft Silverlight"
rmdir /s /q "%ProgramFiles(x86)%\Microsoft Silverlight"