Folders "Distributed Software" are missing on Enterprise for one Domain

Products

• CA Client Automation
• CA Client Automation - Patch Manager

Issue/Introduction

On Enterprise console, one Domain has missing folders under Control Panel/Domains/All Domains.

"Distributed Software Packages", "Distributed Software Policies" and "Fetched Items" folders are missing.

 

 

"Software Distributions - Stage software packages..." is missing in context menu :

 

 

 

Environment

Client Automation - All versions

Cause

This problem occurs because the value of column usage_list in table ca_n_tier is not correct for the DOMAIN.

 

It contains

0x0000000000000000000000000000000000000000000000000000000000000000

instead 

0x00000700001C0000000010000000004000000000000000000000000000000000

 

 

 

Resolution

Execute following SQL Request on mdb database of Enterprise Server using "Microsoft SQL Server Management Studio".

 

use mdb

update ca_n_tier

set usage_list=0x00000700001C0000000010000000004000000000000000000000000000000000

where usage_list=0x0000000000000000000000000000000000000000000000000000000000000000

 

 

After a refresh in Console, the folders should appear :

 

 

And context menu contains "Software Distributions - Stage software packages..."