MetaData Import for Linux doesn't show tree of available errata channels and loads in loop

Products

• Patch Management Solution
• IT Management Suite

Issue/Introduction

The MetaData Import for Linux doesn't show the tree of available errata channels and it loads in a loop, and the RHN Channel Import is stuck in a running loop and the Stop button doesn't work:

Environment

ITMS 8.x

Patch Management 8.x

Cause

This is a rare occurrence. The Current and Last Statuses in the Windows Updates PreImport Worker State field was stuck as running, likely caused by an interruption in the background services and processes when the task was initially started.

Resolution

Caution: Make a backup of the Symantec CMDB database prior to running the below update query:

To stop the task, first run this query and copy the State column contents to a text editor:

select name, cast(state as XML) as 'State' from item where guid = '4F882CFC-5329-4ACC-BBF1-C325E008F4AF'

or

select guid,state from item where guid = '4F882CFC-5329-4ACC-BBF1-C325E008F4AF'

Look for these two tags:

<LastStatus>1</LastStatus><CurrentStatus>1</CurrentStatus>

Change the values for LastStatus and CurrentStatus to 3, and leave the rest of the result unchanged:

<LastStatus>3</LastStatus><CurrentStatus>3</CurrentStatus>

Copy the full edited result into this query and run the query:

update item set state = 'PASTE THE EDITED RESULT HERE BETWEEN THE SINGLE QUOTES' where guid = '4F882CFC-5329-4ACC-BBF1-C325E008F4AF'

NOTE: Changes have been made to prevent this situation in ITMS 8.6 RU3 and later (IT Management Suite 8.6 RU3 Release Notes)

 

Additional Information

Import of available vendors, software, and languages in Patch Management doesn't stop