OBIEE 11g Log file names and path

Log files:
OBIEE server log (RPD related, OPMN services start/stop related log):
$OBIEE_HOME$/instances/instance1/diagnostics/logs/OracleBIServerComponent/coreapplication_obis1/nqserver.log

OBIEE Query Log (OBIEE report’s query related logs):
$OBIEE_HOME$/instances/instance1/diagnostics/logs/OracleBIServerComponent/coreapplication_obis1/nqquery.log

OBIEE Scheduler Log (OBIEE scheduler related logs):
$OBIEE_HOME$/instances/instance1/diagnostics/logs/OracleBISchedulerComponent/coreapplication_obisch1/nqscheduler.log

Managed server log:
$OBIEE_HOME$/user_projects/domains/bifoundation_domain/servers/bi_server1/logs

Admin Server Log:
$OBIEE_HOME$/user_projects/domains/bifoundation_domain/servers/AdminServer/logs

 

Thanks

Akash Garg (twitter: @akashdgarg)

Advertisements

OBIEE11g: Error:[nQSError: 43126] Authentication failed: invalid user/password. error when Logging into Answers/analytics

After restarting all services (Admin server, Node manager, Managed server and OPMN), users were not bale to login to Presentation Services (commonly known as answers/analysis). It was showing invalid user/password error.

Log file:  /u01/APP/OBIEE/instances/instance1/diagnostics/logs/OracleBIServerComponent/coreapplication_obis1/nqserver.log

error: [2017-08-02T21:53:52.000+05:30] [OracleBIServerComponent] [ERROR:]1] [] [] [ecid: 0000LqZjaJG4qmmpsoL6iX1PWVhs000002,0:26:1:6] [tid: eaed6700] oracle.webservices.provider.ProviderException: java.lang.RuntimeException: oracle.bi.security.service.SecurityServiceException: SecurityService::authenticateAccess is denied for the specified credentials/identity.
[2017-08-02T21:53:52.000+05:30] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 0000LqZjaJG4qmmpsoL6iX1PWVhs000002,0:26:1:6] [tid: eaed6700] [nQSError: 43126] Authentication failed: invalid user/password.

Root Cause: The BISystemUser account has become locked.

Solution:

  1. Log in to the WebLogic Server Administration Console.
  2. Navigate to Security Realms > myrealm > Users and Groups > Users > BISystemUser > Password
  3. Reset the password to same as of old password (i.e. you just need to reset to same password) and save.
  4. Login to Enterprise Manager.
  5. Navigate to WebLogic Domain  and right click on bifoundation_domain.
  6. Click on Security > Credentials
  7. click on oracle.bi.system and then system.user
  8. Then click on edit on top of this table and reset the password same as you set for BISystemUser in WebLogic Server Administration Console.
  9. Restart OPMN services and wait (i did so) for 10 minutes before login into Answers.
  10. It should work.

 

Thank You

Akash (@akashdgarg).

OBIEE11g: Managed server services Stuck: java.lang.OutOfMemoryError: GC overhead limit exceeded error

One fine day, if you suddenly face an issue of OBIEE being not working, managed server services in ‘Hang’ or ‘STUCK’ state, try to restart the services but no luck etc. Reason behind all this scenarios could be the following:

java.lang.OutOfMemoryError: GC overhead limit exceeded.

you will find above error in bi_server.log (bi_server is the name of your managed server) at below path:

/$OBIEE_HOME$/user_projects/domains/bifoundation_domain/servers/bi_server1/logs/bi_server1.log.

Error: looks like this:

####<Jun 12, 2017 8:22:37 PM IST> <Error> <HTTP> <etdcrpt02> <bi_server1> 
<[STUCK] ExecuteThread: '11' for queue: 
'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> 
<005KKckpyjA4qmmpsoL6iX0001CH00001^> <1497279157635> <BEA-101017> 
<[ServletContext@1533767336[app:bisecurity module:bisecurity path:
/bisecurity spec-version:2.5 version:11.1.1]] 
Root cause of ServletException.
java.lang.OutOfMemoryError: GC overhead limit exceeded

Cause of error:

 The detail message "GC overhead limit exceeded" indicates that the 
garbage collector is running all the time and Java program is making very 
slow progress. After a garbage collection, if the Java process is spending 
more than approximately 98% of its time doing garbage collection and if it 
is recovering less than 2% of the heap and has been doing so far the last 
5 (compile time constant) consecutive garbage collections, 
then a java.lang.OutOfMemoryError is thrown. This exception is typically 
thrown because the amount of live data barely fits into the Java heap 
having little free space for new allocations.

Solution:

Instant: restart all services (admin server, node manager, managed server and OPMN).

while restarting managed server, first you need to stop/force stop (to force stop use kill -9 PID ) managed server.

Permanent fix: 

Increase the heap size. The java.lang.OutOfMemoryError exception for 
GC Overhead limit exceeded can be turned off with the command line 
flag -XX:-UseGCOverheadLimit.

 

 

 

Thanks till next time

Akash (@akashdgarg)

 

 

‘Catalog’ not visible despite of having access in OBIEE11g.

One of my user raised an issue of ‘Catalog’ menu being not visible on homepage along with other menu items like Dashboard, Open, New etc.catalog_not_visible

My initial investigation was to check roles, group of the user. He belongs to ‘AuthenticatedUser’ group, no explicit denial of access to catalog folder. He was able to open reports by going an alternative approach(using Open menu). Then why is he not able to see catalog as a menu button on home screen?

Solution: 1. Log in to user’s account (impersonation/ or by user’s credentials), go to my Account, check the Accessibility mode to ‘OFF’ (earlier it was set to ‘ON’).

acc_mode_off

press ‘OK’ and refresh the page:

catalog_visible

Catalog is visible now.

OBIEE Version: 11.1.1.7.141014.

 

Thanks till next time.

Showing dynamic data over image in OBIEE

There was a requirement in which we needed to show report’s data on a static image. This Image was provided by client and we had to place the tables of 4×2 on multiple places on this image. In image (refer below image) you will see Rectangles in different colours which are static, but values shown under those rectangles are dynamic. These values are changing as per there is a change in data in ETL table. To overcome as a solution of this requirement we took help of html code. Here is the step by step guide to implement the same.

show_dynamic_value1

  1. Criteria:go to criteria tab and drag and drop columns for which you want to show data on image.show_dynamic_value2
  2. Create one column called ‘Style’ for the position of different boxes on Image. This is how 8 different positions were created. No of positions may vary for your project. you can change the px values to change the position of objects on image.show_dynamic_value3
  3. Then use ‘Narrative View’show_dynamic_value4
  4. you can take reference from below code:Prefix: show_dynamic_value6Note: Image shown is placed at a path mentioned above. This path may be different for different projects

    Narrative: show_dynamic_value5

     

    Highlighted texts:

    color:red it is a tag for Red coloured box and @2 and @4 are referring to the columns in criteria which to be shown in row corresponding to red box: @2 and @4 are referring to two different columns, Internal and External respectively.

    Like wise this is done for other coloured boxes.

    Row seperator : </div>

    Post fix : </div>

    Please share your thoughts if it helped and keep watching this space for more updates.You can follow me on twitter (@akashdgarg) for quick updates about what’s happening in the area of BI, Big data, OBIEE etc.

Continue reading

How to show Null values as blank in reports

It is very common from a user to ask you mask Null values to something else, for example Null to be shown as Zero.

But, I come through a reverse requirement where user wanted to show Null as Null without any masking. By default, Obiee was showing zeros.

Quickly, it clicked in my mind I changed the setting at Physical layer in RPD.

Let’s go step by step.

  1. Values are being shown as 00/00/00 and 0.0 in second fourth and fifth column rescpectively in below screen shot.null1
  2. User wanted them to be shown as below.null2
  3. All you have to do is to login to RPD and Navigate to Physical columns of respective columns.
  4. Check the ‘Nullable’ option as shown below and Press OK. Then save the rpd and check
  5.  .null3Please share your thoughts if it helped and keep watching this space for more updates.You can follow me on twitter (@akashdgarg) for quick updates about what’s happening in the area of BI, Big data, OBIEE etc