HFM Smart View Error “Unknown Error in Hfmproviderdata at the Root Level Is Invalid. Line 1, Position 1” When Refreshing Large Worksheets


Unknown Error in HFMProviderData at the root level is invalid. Line 1, position 1. When refreshing large Smart View workbooks using the HFMOfficeProvider, users receive the following message:

Unknown Error in HFMProviderData at the root level is invalid. Line 1, position 1.

When a Fiddler trace is performed, you see the following message in the response from the HFMOfficeProvider.

<?xml version=”1.0″ encoding=”utf-8″ ?><exception errcode=”10000″ native=”-1″ type=”warning”><desc>Unknown Error in HFMProviderData at the root level is invalid. Line 1, position 1.</desc><details from=”HFMwsFormulas.GetVals.”>Insufficient memory to continue the execution of the program.</details></exception>

This issue is caused by the IIS Setting AspMaxRequestEntityAllowed being set too low for the amount of data that the customer is requesting via Smart View. The AspMaxRequestEntityAllowed IIS parameter limits the an ASP page’s response to a request to a certain number of bytes. The default value is 200 kB.

To resolve this issue, perform the following steps on all HFM web servers:

  1. Backup the metabase.xml file in the windows\system32\inetsrv directory
  2. Stop WWW Publishing Service
  3. Using Wordpad, Edit the metabase.xml file in <windows>\system32\intsrv directory
  4. Find the first Entry of AspMaxRequestEntityAllowed entry which is after the
    <IIsWebService Location =”/LM/W3SVC”

    entry. This is the default setting for all websites in IIS. Changing this will affect all websites, unless it is specified for the specific website. If you only want to change this setting for HFMOfficeProvider find the entry:

    <IIsWebVirtualDir Location =”/LM/W3SVC/1/ROOT/hfmofficeprovider”

    and add the AspMaxRequestEntityAllowed entry there:

    AspMaxRequestEntityAllowed=”204800″

    The value is the number of bytes that an ASP response will be limited to. The default is 204800, which limits responses to about 200 kB. Our suggestion is to set this much higher. For example, to set it to 1 GiB, change the value to

    AspMaxRequestEntityAllowed=”1073741824″
  5. Once you have made the change, then Start WWW Publishing service.
  6. Test and verify you can refresh the sheet that was throwing the memory error in the fiddler trace. If you still get the memory error, increase the ASPMaxRequestEntityAllowed further.

To make this change in IIS 7

  1. Launch IIS Manager
  2. Expand Default web site
  3. Click on HFM
  4. Click on the Asp icon in the right pane.
  5. Right click on the Asp icon and click on Open Feature
  6. Expand Limit properties
  7. Increase the MaximumRequestEntityBodyLimit
  8. Once you have made the change, then Start WWW Publishing service.
  9. Test and verify you can refresh the sheet that was throwing the memory error in the fiddler trace. If you still get the memory error, increase the MaxRequestEntityAllowed further.

Thanks

~KKT~

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s