top of page
Writer's pictureMembers of COE Team

SCCM current branch updates errors and resolutions, SCCM 1910, 2002, 2006, 2010.

Updated: Feb 17, 2021

If you wan to know how to upgrade the SCCM. Please follow the given link.


Upgrade Errors: Here are few upgrade Errors which I found when I upgrade my SCCM environment. If you are facing any thing else. Please let me know, I will try to solve it for you.


Error1:

[Failed]:Checks if the specified SQL Server meets the minimum requirements for site upgrade.


Error2:

The operation cannot be performed on database "XXXXX" because it is involved in a database mirroring session or an availability group. Some operations are not allowed on a database that is participating in a database mirroring session or in an availability group.




Solution:

1. Run this command on your Primary SQL server in Always on availability Group.


SELECT is_broker_enabled FROM sys.databases WHERE name = 'CM_DND';


Run the command and check if Value is 0, upgrade will not run. You need to change the value to 1, only then upgrade Pre-req will pass.




2. use this command to disable the availability Group.


USE master;

ALTER AVAILABILITY GROUP aag1 REMOVE DATABASE cm_dnd;


This Command will Remove the Database from availability Group




3. Use this command to alter the database to enable Broker service with immediate Rollback functionality.


ALTER DATABASE CM_DND SET ENABLE_BROKER WITH ROLLBACK IMMEDIATE

This will enable Broker service with immediate rollback feature.




4. Add the Database back to availability Group by the given SQL command.

USE master;

ALTER AVAILABILITY GROUP AAG1 ADD DATABASE cm_dnd;




5. Verify the broker service. It Value should be 1.




Error3:

Configuration option 'max text repl size (B)' changed from 2147483647 to 2147483647. Run the RECONFIGURE statement to install.

Error; Configuration Manager has detected that SQL Server does not meet the minimum requirements for site upgrade.




Solution of Error 3:

1. Right click on SCCM database, go to property and correct the entry.




2. Login on primary Database and run the below given Query to set Set Max text repl size to 2147483647 on Primary SQL server.

EXECUTE sp_configure 'max text repl size (B)', 2147483647




Error4:

[Failed]:Checking secondary read state of availability group replicas


Error5:

[Failed]:Checking failover state of availability group replicas


Solution of Error 4 and 5:

1. Login on primary Database server, Connect the DB on MSSMS. Go to Always on high availability--: Right click on Availability group--: Property--:


2. Make sure your setting are correct before upgrade. Once upgrade complete you can revert manual failover to automatic.




Error6: Installation stuck after stopping “configuration manager update service”… This log appears in “Cmupdate.log”.

In “HMAN.log”, you can see these errors.

01-30-2021 13:28:53.839 SMS_HIERARCHY_MANAGER 176 (0xb0) INFO: Failed to copy the file [\\?\D:\Microsoft Configuration Manager\CMUStaging\6B4F84B7-5555-48B0-AECC-74FB5A8AA24B\SMSSetup\AI\LUTables.enc] to [\\?\D:\Microsoft Configuration Manager\AI\LUTables.enc] (LastError=3).

01-30-2021 13:28:53.839 SMS_HIERARCHY_MANAGER 176 (0xb0) Failed to copy file from D:\Microsoft Configuration Manager\CMUStaging\6B4F84B7-5555-48B0-AECC-74FB5A8AA24B\SMSSetup\AI\LUTables.enc to D:\Microsoft Configuration Manager\AI\LUTables.enc




Solution of Error 6:

1. It seems that <SCCM installation Directory>:\Microsoft Configuration Manager\AI\ folder is missing from your SCCM installation directory.

2. Please copy the folder from

<SCCM installation Directory>:\Microsoft Configuration Manager\cd.latest\SMSSETUP\AI

to

<SCCM installation Directory>:\Microsoft Configuration Manager\



This Post talks about:

sccm 2010 upgrade checklist

sccm 2010 known issues

sccm 2010 new features

sccm 2010 issues

sccm 1910 upgrade checklist

sccm 2010 prerequisites

sccm 2006 new features



17 views0 comments

Recent Posts

See All

Comments


bottom of page