Help! XML Returned from server does not have 'root' element

Gabbitas

I keep getting the following error in the operation mode:

"XML Returned from server does not have 'root' element"

This message appears when a user tries to open a form for a single business object. Project BO.

This error has seemingly come from nowhere. I haven't made any changes to the configuration and all has been working fine until this just popped up. Now my users are unable to access any records of the BO Project.

I have looked at the logs and it is not giving me to much to go on. There is one error that shows that is connected to UDD BO.

"Exception getting user defined templates Internal error. Business object BAS_UserDefinedDocument not found in business space version"

I don't have any user defined docs in my application and no rules that would modify any such object. Could this be the cause of the problem? I have had a look under the hood of MySQL and sure enough the BASUserDefDocuments table doesn't exist as per error. In other applications running the same config without the problem the same table doesn't exist either.

I have had a look on the forums about the XML error and there is a lot about the use of ampersand inside fields but most of the posts are quite old. Also, ampersand symbol has been used in fields in my app and have not caused any problems.

The only way I can get back from the error is if I restore an earlier MySQL backup which loses operational data!!

Anyone who has any thoughts on this please chip in

Thanks, Andy

RocketRod

Usually it's just an & that someone has entered into an address or name attribute! Find it, remove it, and all usually is well.

Cheers Rod

Gabbitas

Hi Rod,

Thanks for the reply on this. After many discussions with my users I came to realise that it is in fact an ampersand that is causing the error. I managed to track it down and get rid of it.

I have a choice list that allows users to add and edit choices. The problem kicks in when a user creates a choice that contains the ampersand!

Support - is this a MySQL problem or is it something that could be fixed? My users are going to have a tendency to use the symbol as it is commonly used in our industry specific aberrations?

Many Thanks Rod and Support

RocketRod

Great you found it!

I put in rules to strip it out so it doesn't cause issues. It also occurs in SQL DB which I use.

Cheers Rod