Helpful Tips for OBIEE

Start Here

Get in touch with a
TriCore Solutions specialist

Blog | Dec 23, 2016

Helpful Tips for OBIEE


Discover some useful OBIEE tips from Kiran Bellam. 

oracle obiee support
Introduction:
I have been working with OBIEE for a while now, and I ‘ve uncovered some tips that could be useful in your day to day responsibilities.  I’ve compiled a list of my Top 3 below.

TIP #1                                                                  

Unrecognized patch ID while applying patch in BSU Tool and "java.lang.OutOfMemoryError” 

Issue: #1

When you are trying to apply a patch in Solaris using BSU and you get the below error.

Encountered unrecognized patch ID: XXXX(ID based on patch)

Solution:

Shown below are the patch files in the snapshot.

obiee patch

To resolve the issue simply change the name of the catalog xml file from the patch as described below.

Change from patch-catalog_24474 to patch-catalog.xml and try to apply the patch again using BSU tool.

Note: Patch directory needs to have 777 permissions

Issue: #2

Exception in thread "main" java.lang.OutOfMemoryError: GC overhead limit exceeded.

When you are applying the same patch and you will get the below “out of memory” error.

Exception in thread "main" java.lang.OutOfMemoryError: GC overhead limit exceeded
at java.util.Arrays.copyOf(Arrays.java:2367)
at java.lang.AbstractStringBuilder.expandCapacity(AbstractStringBuilder.java:130)
at java.lang.AbstractStringBuilder.ensureCapacityInternal(AbstractStringBuilder.java:114)
at java.lang.AbstractStringBuilder.append(AbstractStringBuilder.java:415)
at java.lang.StringBuilder.append(StringBuilder.java:132)
at java.lang.Class.getMethod(Class.java:1665)

Solution:

To resolve the above issue, remove the Java path from bsu.sh file and re-apply the patch again.

 -----------------------------------------------------------------------------------------      TIP #2

Steps to change the Weblogic password

Step1: Log in to the Weblogic console

  • Click on Security on the left pane.
  • Click on 'My Realm'.
  • Click on 'Users and Groups' tab.
  • Drill down on to WebLogic user.
  • Navigate to the 'Password' tab.
  • Enter the password into New Password and Confirm Password text boxes. 

Step2:  Navigate to the below locations: 

  • OBIEE11g\product\fmw\user_projects\domains\bifoundation_domain\servers\AdminServer\security
  • OBIEE11g\product\fmw\user_projects\domains\bifoundation_domain\servers\bi_server1\security
  • Rename the boot.properties file to any name or remove the file

Step 3: Stop BI Services & Start BI Services 

  • Stop BI Services, it will ask weblogic username and password, provide the username and modified password.
  • Start BI Services 

Note**: Delete the tmp files for Admin and BI server before starting the services                                    --------------------------------------------------------------------------------------------  TIP #3

OBIEE report error:

Catalog object schema validation failed in OBIEE 12c

Steps:

  • Goto to report folder
  • Edit the report
  • Goto the Adavanced Tab
  • Copy the XML Code to the text editor 

Some font values are not supported in OBIEE 12c which are available in Discoverer. 

If the Discoverer report is done in the “Dialog” font and you are migrating the report from Discoverer to OBIEE with the same code, it will throw the below error in OBIEE 12c. 

Datatype error: Type:InvalidDatatypeValueException,
Message: Value 'Dialog' is not in enumeration
 

Edit the XML code and remove the Parameter fontFamily="Dialog" from the Advanced tab and run the report.

If you want to display report with all Default font values in OBIEE just remove the below parameters in XML code:

<saw:displayFormat><saw:formatSpec suppress="default" interaction="default" backgroundColor="#FFFFFF" fontColor="#000000" fontStyle="regular" fontSize="11" fontEffects="none" hAlign="left" vAlign="top" fontFamily="Dialog"><saw:dataFormat xsi:type="saw:custom" customFormat="DD-MMM-YYYY"/></saw:formatSpec></saw:displayFormat> 

Conclusion:
I hope you have found these tips helpful. If you have any questions please contact me by clicking below. You can also leave a comment in the field below. Thanks for reading!

Ask Kiran