In Metadata import task, the task Import of available vendors is running and we can't stop it.
We rebooted NS server, but the same status.
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.
Caution: Make a backup of the Symantec CMDB database prior to running the below update query.
There are changes to prevent this situation in 8.6 RU3
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 = 'f8d384de-d891-4f1d-8a0f-7f9c92794a9f'
Look for these two tags:
Change the values for LastStatus and CurrentStatus to 3, and leave the rest of the result unchanged.
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 = 'f8d384de-d891-4f1d-8a0f-7f9c92794a9f'