FIX SCCM Update Prerequisites Failed Issue | ConfigMgr

0
FIX SCCM Update Prerequisites Failed Issue ConfigMgr

Let’s find out the fix for SCCM Update Prerequisites Failed Issue. As the heading indicates itself it’s about the new KB released “KB4560496” for ConfigMgr 2002.

Introduction:

I installed it in my test lab the day it was released and everything was going good. But when I tried installing it in production standalone primary site the prerequisites failed with below error:

FIX SCCM Update Prerequisites Failed Issue | ConfigMgr
FIX SCCM Update Prerequisites Failed Issue | ConfigMgr

Read all about KB4560496 for MECM 2002. Deep Dive with known issues and bug fixes by Anoop Nair https://www.anoopcnair.com/sccm-2002-hotfix-rollup-kb4560496/ – Very briefly explained.

ERRORS:

So there are 2 failed prerequisites and we will fix it.

  1. Max Test Repl (Replication) Size of SQL Server Always On Availability.
  2. SQL Server Configuration for Site Upgrade.

One step at a time. This is going to be interesting.

Max Test Repl Size of SQL Server Always On Availability.

First of all, we will check the existing value in DB of “Max Test Repl Size”. To get the value to connect the SCCM DB using Management Studio and execute query “SP_Configure”. It will populate value as below:

FIX SCCM Update Prerequisites Failed Issue | ConfigMgr
FIX SCCM Update Prerequisites Failed Issue | ConfigMgr

Now you are seeing the correct value because i changed it already. Now there are 2 options to change this value.

Using SQL Server Management Studio:

  • In Object Explorer, right-click a server and select Properties.
  • Click the Advanced node.
  • Under Miscellaneous, change the Max Text Replication Size option to the desired value
    • (Recommended 2147483647).
FIX SCCM Update Prerequisites Failed Issue | ConfigMgr 1

Using Transact-SQL

  • Connect to the Database Engine.
  • From the Standard bar, click New Query.
  • Copy and Paste the following example into the query window and click Execute.
    • This example shows how to use sp_configure to configure the max text repl size option to -1.
USE AdventureWorks2012 ;
GO
EXEC sp_configure 'show advanced options', 1 ;
RECONFIGURE ;
GO
EXEC sp_configure 'max text repl size', -1 ;
GO
RECONFIGURE;
GO

Now this error will go away. Don’t run the Prerequisites check yet because you have to fix another error.

FIX SCCM Update Prerequisites Failed Issue  ConfigMgr
FIX SCCM Update Prerequisites Failed Issue ConfigMgr

NOTE: MS Doesn’t support the alteration of DB. Perform actions under the supervision of SQL Experts.

SQL Server Configuration for Site Upgrade

Now moving on to the second issue.

  • To fix this one we need to read the logs and get more information about the reason for this failure.
  • Check ConfigMgrPrereq.log located in C drive root of your Primary/CAS.
  • This is what I got when checking the log.
FIX SCCM Update Prerequisites Failed Issue | ConfigMgr
FIX SCCM Update Prerequisites Failed Issue | ConfigMgr

It’s saying AG (Availability Group) replica has READ_Only as a readable secondary state should be ALL.

Before we start how to fix we should check a few more things. Execute the below SQL Queries to get more information.

  • select * from sys.availability_replicas
  • select * from sys.availability_read_only_routing_lists
  • select * from sys.dm_tcp_listener_states

It will populate information shown in screenshots.

FIX SCCM Update Prerequisites Failed Issue | ConfigMgr
FIX SCCM Update Prerequisites Failed Issue | ConfigMgr
FIX SCCM Update Prerequisites Failed Issue | ConfigMgr 2

FIX SCCM Update Prerequisites Failed Issue

Now let’s fix it Using SQL Server Management Studio.

To configure access on an availability replica

  1. In Object Explorer, connect to the server instance that hosts the primary replica, and expand the server tree.
  2. Expand the Always On High Availability node and the Availability Groups node.
  3. Click the availability group whose replica you want to change.
  4. Right-click the availability replica, and click Properties.
  5. In the Availability Replica Properties dialog box, you can change the connection access for the primary role and for the secondary role, as follows:
    • For the secondary role, select a new value from the Readable secondary drop list, as follows: No
      No user connections are allowed to secondary databases of this replica. They are not available for read access. This is the default setting. Read-intent only
      Only read-only connections are allowed to secondary databases of this replica. The secondary database(s) are all available for read access -Yes
      All connections are allowed to secondary databases of this replica, but only for read access. The secondary database(s) are all available for read access.
    • For the primary role, select a new value from the Connections in the primary role drop list, as follows: Allow all connections
    • All connections are allowed to the databases in the primary replica. This is the default setting. Allow read/write connections
    • When the Application Intent property is set to ReadWrite or the Application Intent connection property is not set, the connection is allowed.
    • Connections, where the Application Intent connection property is set to ReadOnly, are not allowed.
    • This can help prevent customers from connecting a read-intent workload to the primary replica by mistake.
    • For more information about Application Intent connection property,

Using Transact-SQL

To configure access on an availability replica 

  1. Connect to the server instance that hosts the primary replica.
  2. If you are specifying a replica for a new availability group, use the CREATE AVAILABILITY GROUP Transact-SQL statement. If you are adding or modifying a replica of an existing availability group, use the ALTER AVAILABILITY GROUP Transact-SQL statement.
    • To configure connection access for the secondary role, in the ADD REPLICA or MODIFY REPLICA WITH clause, specify the SECONDARY_ROLE option, as follows: SECONDARY_ROLE ( ALLOW_CONNECTIONS = { NO | READ_ONLY | ALL } )where, NO
    • No direct connections are allowed to secondary databases of this replica. They are not available for read access. This is the default setting.
    • READ_ONLY Only read-only connections are allowed to secondary databases of this replica.
    • The secondary database(s) are all available for read access.
    • ALL connections are allowed to secondary databases of this replica, but only for read access. The secondary database(s) are all available for read access.
  3. To configure connection access for the primary role, in the ADD REPLICA or MODIFY REPLICA WITH clause, specify the PRIMARY_ROLE option, as follows: PRIMARY_ROLE ( ALLOW_CONNECTIONS = { READ_WRITE | ALL } )where, READ_WRITE
  4. Connections, where the Application Intent connection property is set to ReadOnly, are disallowed.
  5. When the Application Intent property is set to ReadWrite or the Application Intent connection property is not set, the connection is allowed.
  6. All connections are allowed to the databases in the primary replica. This is the default setting.

NOTE: MS Doesn’t support the alteration of DB. Perform actions under the supervision of SQL Experts.

Disclaimer – The information provided on the site is for general informational purposes only. All information on the site is provided in good faith, however, we make no representation or warranty of any kind, express or implied regarding the accuracy, adequacy, validity, reliability, availability or completeness of any information on the website.

Resources

LEAVE A REPLY

Please enter your comment!
Please enter your name here

This site uses Akismet to reduce spam. Learn how your comment data is processed.