Knowledgebase: HFM
Smart View Error "XML Load Error: XML Document must have a top level element
Posted by Priya Doyle on 07 December 2010 05:44 PM

Smart View Error "XML Load Error: XML Document must have a top level element"

 Modified 01-FEB-2010 

Applies to:

Hyperion Financial Management - Version: to - Release: 4.0 to 11.1
Information in this document applies to any platform.


When trying to submit data to HFM, receive error, "XML Load Error: XML Document must have a top level element" within a minute.


An upgrade from IE X to IE 7.


This is specific to IE7. The http requests are being timed out due to IE 7 lowering its timeout settings.


Smart View Refresh or Refresh All issues with IE7 
Clients on IE6 that upgrade to IE7 may experience issues refreshing worksheets due to a low timeout setting.

To help troubleshoot this, the administrator can use Fiddler to trace the HTTP activity from the clients machine to the server. What was seen in a fiddler trace is Smart View would request data, no data would come back within 30 seconds, during which time other requests were processed. The request that had no response showed the following error: 


Oracle Development discovered this to be a MicroSoft issue and recommended the following two Microsoft Knowledge base articles related to IE7. 

Important note from the above KB: 

By design, Internet Explorer imposes a time-out limit for the server to return data. The time-out limit is five minutes for versions 4.0 and 4.01 and is 60 minutes for versions 5.x and 6. Also, the time-out limit is 30 seconds for Windows Internet Explorer 7. As a result, Internet Explorer does not wait endlessly for the server to come back with data when the server has a problem. 

After implementing the changes recommended in the two kb articles, the issue the customer reported was resolved. In our testing we needed the registry key changed from both KB articles. 

The following client side registry keys were ADDED: 

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Internet Settings]\ 

Once making the changes, it is recommended to reboot the client machine. 
These registry changes are the recommended settings from Microsoft. In some cases (slower connection speeds, or using VPN) you may need to increase the KeepAliveTimeout if these settings do not work. Please consider using the latest version of fiddler (timestamps requests) to see how much time it takes for the data to come back and adjust the setting based on that time. 

(0 vote(s))
Not helpful

Comments (0)
Post a new comment
Full Name: