Unable to save Hierarchy Properties for the Package Server Settings Policy
search cancel

Unable to save Hierarchy Properties for the Package Server Settings Policy

book

Article ID: 204922

calendar_today

Updated On:

Products

IT Management Suite

Issue/Introduction

When changing the Hierarchy Properties in Package Server Settings policy, any changes fail to save correctly.

Steps to reproduce:

  1. Navigate to Settings > All Settings > Notification Server > Site Server Settings > Package Service.
  2. Right click Package Service Settings and select Hierarchy > Properties (see screen shot attached)
  3. Default has Package Settings enabled, all others disabled
  4. Make any changes (we unchecked Package Settings and enabled Security Settings, for example) and click OK.
  5. Go back into Hierarchy > Properties and see the changes were not saved. 
  6. Same behavior using Chrome or Internet Explorer

 

Environment

ITMS 8.5 RU3/RU4 

Cause

Defect

Resolution

Under investigation, fix planned for future release

Work-around:

  1. Make a backup of the CMDB database
  2. Run the following queries in SQL Management Studio against the CMDB database 
    • Example to change the SecuritySettings to FALSE:

UPDATE ITEM
SET STATE = REPLACE(CAST(STATE AS NVARCHAR(MAX)),

'<hierarchyEditableProperty editable="False">SecuritySettings</hierarchyEditableProperty>', --editable="True" to enable, "False" to disable.

'<hierarchyEditableProperty editable="True">SecuritySettings</hierarchyEditableProperty>')
WHERE GUID = 'f85fe5d9-005a-40ac-b213-944b496405fe'

    • Example to change the PackageStorage to TRUE

UPDATE ITEM
SET STATE = REPLACE(CAST(STATE AS NVARCHAR(MAX)),

'<hierarchyEditableProperty editable="True">PackageStorage</hierarchyEditableProperty>', --editable="True" to enable, "False" to disable.

'<hierarchyEditableProperty editable="False">PackageStorage</hierarchyEditableProperty>')
WHERE GUID = 'f85fe5d9-005a-40ac-b213-944b496405fe'

Note that there are four hierarchyEditableProperty options that can be edited with this workaround. 

PackageAssignment: <hierarchyEditableProperty editable="True">PackageAssignment</hierarchyEditableProperty>
PackageStorage:        <hierarchyEditableProperty editable="True">PackageStorage</hierarchyEditableProperty>
PublishedCodebase   <hierarchyEditableProperty editable="True">PublishedCodebase</hierarchyEditableProperty>
SecuritySettings         <hierarchyEditableProperty editable="True">SecuritySettings</hierarchyEditableProperty>