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

Document ID : KB000008315
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

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.

 

Capture1.JPG

 

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

Capture4.JPG

 

 

 

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 :

Capture2.JPG

 

 

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

Capture6.JPG