Facing problem with OBIEE 11g?

The following error phrase keep appear when attempted to navigate to Business Intelligence -> coreapplication in Oracle Enterprise Manager Fusion Middleware Control:

“Stream Closed for more information…bla..bla..bla..Server Exception during PPR, #8″

Its irritating rite? See below

Ok, let me guess. Just now, your BIEE server ran out of disk space.

Am I right? If yes, this solution should work, otherwise please don’t tell me why. But try this at first and hopefully your problem gone.

As user oracle (or any user that you use to install OBIEE 11g), navigate to the following location:

$MIDDLEWARE_HOME/user_projects/domains/bifoundation_domain/sysman/mds/partition1/ai/bi/mdssys/cust/user/<USER_NAME>

replace <USER_NAME> with your user id of the user, mine is “weblogic”.

*Unless you LIKE to work on WINDOWS environment, use backslash (\) instead of slash (/).

So my actual path is:

/oracle/Middleware/user_projects/domains/bifoundation_domain/sysman/mds/partition1/ai/bi/mdssys/cust/user/weblogic

Then, can you see the file with name instance.jspx.xml on that location?

If yes, delete it. Yes..delete it.

rm -rf instance.jspx.xml

Not confident?? Ok, you can rename it to any other name that you like:

mv instance.jspx.xml instance.jspx.xml.isAgoodCat

Then, what to do?

Yeeess…restart all services (opmnctl stopall, stopManageWeblogic, stopWeblogic)

Your Oracle Enterprise Manager Fusion Middleware Control should work now. See