Cannot export very large amount of data

When you try to export a very large amount of data from Controller, an error message appears, similar to the following: 

IBM Controller, Error No=5, Source=FrangoDirect.ExportDataD.SelectPeriodVal#System.Web.Services, 
Description=Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'.
[ArithmeticException]: Overflow or underflow in the arithmetic operation.
[HttpException]: An error occurred while communicating with the remote host. The error code is 0x80070216.
   at System.Web.Hosting.IIS7WorkerRequest.RaiseCommunicationError(Int32 result, Boolean throwOnDisconnect)

Cause

This error message is created by Microsoft Internet Information Services (IIS) because the amount of data being exported exceeds the IIS limits.

Solution

To resolve this issue, follow these steps:

  1. Log on to the Controller application server.
  2. Browse to the folder ControllerProxyServer.
    Tip: The default location is C:\Program Files\ibm\cognos\ccr_64\ControllerProxyServer
  3. Create a backup of the file web.config
  4. Open web.config in a text editor.
  5. In the <appSettings> section, add the following line:

    <add key="useBulkExport" value="true"/>

  6. Save the file.
  7. Refresh the IIS server.
  8. Try exporting the data again.

The data export should now be successfully completed.