Service Desk Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Error when I viewing Exchange File (xml) in Data Exchange Task

SOLVED
Go to solution
Highlighted
Zorin
Regular Collector

Error when I viewing Exchange File (xml) in Data Exchange Task

Hi,

I have xml file for sd_lang exchange task.
I was edited it and I success open in browser Internet Explorer.
But when I try to open it in Data Exchange (button View...) I have next Error:

Unable to preview XML file: Unable to preview XML file: Unable to preview XML file: SAX exception: mismatched end tag: expected "VALUE" but got "PROPERTY"

And when I start "Import data into Service Desk Database" this data not transferred.

What I need to open this file from this metod?

Regards,
zorin
5 REPLIES
Prasanna_M
Super Collector

Re: Error when I viewing Exchange File (xml) in Data Exchange Task

Hi,

How was this XML file generated? It looks like the XML file is not structured properly.

If the XML file is not generated through standard ini file, then you have to take care of the XML file structure.

Thanks and Regards,
Prasanna.
Zorin
Regular Collector

Re: Error when I viewing Exchange File (xml) in Data Exchange Task

Yes, I edited this file in manually.
But this file very big. How now I can find error in this file? And Internet Explorer open this file without problem!

Regards,
Zorin
Prasanna_M
Super Collector
Solution

Re: Error when I viewing Exchange File (xml) in Data Exchange Task

Hi,

If Internet explorer can open the file without errors then SD will also be able to open it without error.

While opening in Internet Explorer(IE), IE will parse the XML file and show the data till it finds an error.

Try opening the file in IE again. When the file is loaded completely, scroll through the page till you get the end tag(). You may find the error message some where in between if there is one.

SD always parses the entire XML file and then show it.

Thanks and Regards,
Prasanna.
Zorin
Regular Collector

Re: Error when I viewing Exchange File (xml) in Data Exchange Task

Thank you, Prosanna.

Your suggestion is worked.
I found my error in line 90918 after waiting for opening file in Internet Explorer
and clicking in left bootom corner of browser with black Exclamation mark on yellow triangle.

Regards,
Rodion Zvorygin
Mark O'Loughlin
Honored Contributor

Re: Error when I viewing Exchange File (xml) in Data Exchange Task

Hi,

are you opening and running the data Exchange file from an admin console opened on the physical server on which the DE file exists or from an admin console opened locally on your desktop/laptop?
//Add this to "OnDomLoad" event