Publishing failure

Resolve publishing failures. 

If you can connect to the web server, but can't publish a file, you can try the troubleshooting steps below.

Navigating to the repository web service on the server will give a detailed message if there is a problem with the configuration. If everything is configured correctly, you will see some sample code about using the service. For example, navigate to:

http://localhost/AnaplanXLWeb/webservices/RepositoryServer.svc

If this returns without an error, then try with the exact URL the user would enter, for example:

https://www.someserver.com/AnaplanXLWeb/webservices/RepositoryServer.svc

If that works, try https://www.someserver.com/AnaplanXLWeb/webservices/RepositoryService.svc/js, if you get a 404 then you may have incorrectly set up HTTPS access, please see above.

If the page is blank then an error could have occurred while starting the page, please check for errors in:

1. Windows Event Viewer, specifically Windows Logs > Application.
2. Anaplan XL Web Edition error.log, found in the Anaplan XL Web installation folder

If a full message is displayed, it should give details of the configuration that needs changing. Examples of errors and their solutions:

The ServiceMetadataBehavior HttpGetEnabled property is set to true. The HttpGetUrl property is a relative address, but there's no HTTP base address. Either supply an HTTP base address or set HttpGetUrl to an absolute address.

Locate the <serviceBehaviors> section and update it to:

 <serviceBehaviors>
  <behavior name="AnaplanXLWeb.WebServices.RepositoryServerBehavior">
    <serviceMetadata httpGetEnabled="false" httpsGetEnabled="true" />
    <serviceDebug includeExceptionDetailInFaults="false" />
  </behavior>
  <behavior name="AnaplanXLWeb.WebServices.SmallMultipleChartServerBehavior">
    <serviceMetadata httpGetEnabled="false" httpsGetEnabled="true" />
    <serviceDebug includeExceptionDetailInFaults="false" />
  </behavior>
  <behavior name="AnaplanXLWeb.WebServices.MapServerBehavior">
    <serviceMetadata httpGetEnabled="false" httpsGetEnabled="true" />
    <serviceDebug includeExceptionDetailInFaults="false" />
  </behavior>
  <behavior name="AnaplanXLWeb.WebServices.PrintRendererServerBehavior">
    <serviceMetadata httpGetEnabled="false" httpsGetEnabled="true" />
    <serviceDebug includeExceptionDetailInFaults="true" />
  </behavior>
  <behavior name="AnaplanXLWeb.WebServices.SchedulingServerBehavior">
    <serviceMetadata httpGetEnabled="false" httpsGetEnabled="true" />
    <serviceDebug includeExceptionDetailInFaults="false" />
  </behavior>
</serviceBehaviors>

It's an error to use a section registered as allowDefinition='MachineToApplication' beyond application level.

The web.config file may have been copied to an incorrect location. The message will give more detail about which file to remove.

If you are using multiple sites in IIS, you need to add to web.config in section <serviceHostingEnvironment>

multipleSiteBindingsEnabled="true"

If your server has TLS disabled, Anaplan XL may not be able to connect from Excel, giving the message:

An error occurred while making the HTTP request to SERVERNAME. This could be because the server certificate isn't configured properly with HTTP.SYS in the HTTPS case. This could also be caused by a mismatch in the security binding between the client and the server.

Re-enable TLS to enable the client to connect.

Users need to change permissions on the Repository and Temp directories to publish files.

If this permission is missing, often users can connect to the web server, but don't see a My Reports folder. They get an error when attempting to publish a file. They'll also not be able to perform other report operations.

To check if this is the problem, you can grant Modify Access to the Repository and Temp directories in the Anaplan XL Website to Everyone and retry publishing.

If the publish then succeeds, then permissions are the issue, and you can restrict access to the users you wish to be able to publish.

Your Excel Trust Center settings may be restricting the necessary file types if you are receiving message:

Exception from HRESULT: 0x800A03EC

and if you select on the Support Information tab for the message, it'll include this:

at Microsoft.Office.Interop.Excel.WorkbookClass.SaveAs(...)

You should check that the Trust Center > File Block Settings for Web Pages and Excel 2003 XML Spreadsheets allows saving.

You may receive the error in the Windows Application event log:

The HttpGetEnabled property of ServiceMetadataBehavior is set to true and the HttpGetUrl property is a relative address, but there is no HTTP base address. Either supply an HTTP base address or set HttpGetUrl to an absolute address.

This can occur if the website is bound to HTTPS, but the serviceMetadata configuration is set up for HTTP only. Change the elements in the web.config:

<serviceMetadata httpGetEnabled="false" httpsGetEnabled="true" />