OBIEE 11g: Error: 'Error '500 Internal Server'' BI Server Crashes, Hangs Or 'Out Of Memory' When Adding A Large Table In Smart View (Doc ID 1913940.1)

Last updated on JANUARY 29, 2016

Applies to:

Business Intelligence Suite Enterprise Edition - Version 11.1.1.7.140225 and later
Business Intelligence Server Enterprise Edition - Version 11.1.1.7.140225 and later
Information in this document applies to any platform.

Symptoms

You have upgraded OBIEE 11.1.1.6.8 to 11.1.1.7.1.
OBIEE services crashing when you add a large table (about 80,000 rows) in SmartView.
You see the error:

Error '500 Internal Server'

Smart View could also hang or display an 'Out Of Memory' error.

SmartView is version 11.1.2.5.200 build 174 and you are using Excel 2010.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms