Error opening All Schedules: XML parsing: line 2, character 39, illegal xml character

book

Article ID: 173563

calendar_today

Updated On:

Products

IT Management Suite

Issue/Introduction

When accessing the "Shared Schedules" UI under "Settings > Notification Server > Shared Schedules", in the upper right corner is the option to choose either "Shared Schedules Only" or "All Schedules"

It is when "All Schedules" is chosen that the UI halts with the error:   "XML parsing: line 2, character 39, illegal xml character"

 

Cause

Hundreds of thousands of "Agent Push" tasks exist in the ITEM table. These were old tasks that had never been deleted. Some of the tasks contain (along with the schedule) an encrypted password whose characters could not be properly escaped (formatted to be rendered in XML format)  Characters such as ?, # etc.

 

 

 

 

Environment

Symantec Management Platform 8.5

Resolution

Run the following Query to see how many Agent push tasks exist

SELECT count(*)
FROM vItem
WHERE ClassGuid = '2375E0E2-6B22-4681-B982-1BA4C8C73E47'

If the previous query returned any rows run the following SQL against the database (using SQL Management Studio) then run the NS.Quarter Hour... schedule in Windows Task Scheduler.

INSERT INTO
ItemToDelete
SELECT Guid, getdate()
FROM vItem
WHERE ClassGuid = '2375E0E2-6B22-4681-B982-1BA4C8C73E47'

Attachments