OBIEE 12c error export to excel ReadOverTheLimitException

When attempting to export an Analysis to excel the following error occurs (using OBIEE 12c):

There was an error processing your download. Please check with your administrator.

The OBIEE Server log $OBIEE_Domain/servers/obips1/logs/(saw#.log) generated the following exception:

com.siebel.analytics.utils.InputStreamWithLimit$ReadOverTheLimitException.

Solution:

1. Increase the InputStreamLimitInKB limit:
   1. Browse to $OBIEE_Domain/config/fmwconfig/biconfig/OBIJH
   2. Open the config.xml in a text editor
   3. Find the following lines:
      • 
           8192
           true
        

Change the InputStreamLimitInKB value from 8192 to 2048000.

• Example:
• 
     2048000
     true
  

Save and close the file.

Increase the JavaHost maximum heap size to assist in exports to excel:

1. Browse to $Middleware_Home/bi/modules/oracle.bi.cam.obijh/env
2. Open obijh.properties in a text editor
3. Find the following line:
   • OBIJH_ARGS=-server -Xmx1024M -Xrs -Djava.security.manager=default...
4. Increase the maximum heap value to 2048M:
   • Example:
   • OBIJH_ARGS=-server -Xmx2048M -Xrs -Djava.security.manager=default...
5. Save and close the file

Restart the OBIEE processes for change to take effect