Error opening All Schedules: XML parsing: line 2, character 39, illegal xml character
Last Updated February 04, 2019
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"
Symantec Management Platform 8.5
There were hundreds of thousands of "Agent Push" tasks in the ITEM table. These were old tasks that had never been deleted. Within some of them was embedded (along with the schedule) an encrypted password whose characters were and could not be properly escaped (formatted to be rendered in XML format) Characters such as ?, # etc.
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 Sheduler.
INSERT INTO ItemToDelete SELECT Guid, getdate() FROM vItem WHERE ClassGuid = '2375E0E2-6B22-4681-B982-1BA4C8C73E47'
If they exist they can be detected via the following query:
Subscribing will provide email updates when this Article is updated. Login is required to Subscribe