Thursday, December 6, 2018

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