Recovery from weblogic failures in OBIEE :

Error I: Policy Provider Error

1) When system-jazn-data.xml located at      <Oracle_Home>/bifoundation_domain/config/fmwconfig

get corrupted.

Compile this using xmlwf < system-jazn-data.xml  >

Check till the compilation is successful and try restarting server again.

2)    Create file boot.properties in <Oracle_Home>/ domains/bifoundation_domain/servers/AdminServer/security/

Enter username:<default_user>

password : <default_password>

3) Rename ldap directory to ldap_bacup from <Oracle_Home>/ domains/bifoundation_domain/servers /AdminServer/data

4)  Restart Admin Server using startWebLogic.sh.  Once server is started, create new user BISystemUser in weblogic console. Delete .lok files from <Oracle_Home>/ domains/bifoundation_domain/servers /Admin & bi_server1.

Start nodemanager.     Nodemanager should be managed.

5)     Login into em console:

a.       Goto Weblogic Domain àbifoundation domain

b.      Right Click à Goto Credentials

c.       Click on oracle.bi.system

d.      Edit system.user

e.      Reset password for user BISystemUser.

 Error II: Number Format Exception

Rename  ../domain-name/server/adminserver/data/ldap/config/replicas.prop file  to replicas.prop_bacup.

Error III: Reason java.io.IOException
orapki wallet create -wallet <wallet path on fmwconfig> -auto_login_only

Export To Excel : Column merge & Pagination

Column merge issue comes when OBIEE answers report is exported to excel. This can be rectified by removing filters from the Views section but it makes Pagination stops working in reports.

To solve this issue we need to remove Filters View from Analysis XML rather than from Views section.It will only remove it from report layout but not from report itself: Path for analysis XML:

Go to particular report. Click on :

Edit à Advanced à Analysis XML box

Comment the following code:

<!-- <saw:cvRow>

 <saw:cvCell viewName="filtersView!2"/>

</saw:cvRow> -->

Click on apply xml again.

Now the report is error free..