OBIEE Interview Questions

Real Scenario Issues in OBIEE for Administrators:

1- A user generates adhoc analysis report with some columns which have object level security & user do not belong to authorized group. What will happen?

Ans – nQSError – 27005 will occur

2- How to overcome nQSError – 27005 issue?

Ans – Edit nQSConfig.ini file Security section

Attribute: PROJECT_INACCESSIBLE_COLUMN_AS_NULL = YES;

You will be able to access report, but column with security restriction will appear with no data.

8- While Executing report you get View Display Error - Cube Definition is invalid (Measure out of bounds). With Error Codes: GOA4AK7Z.

Ans - Issue due to Pivot Table view having no measure column. Either add measure column to measure segment or add Table View & remove pivot view if no measure column exists. Your issue will be resolved.

9 - Server component goes down from init state after some time & no information is added in nqserver log ?

Ans - It would be due to huge rpd size which required more time for server component to start. Changing timeout parameters from opmn.xml file will solve the purpose.

10 - Analytics showing error 404 however all java & opmn components are up. But while checking status from weblogic console, you found bi_server component to be in admin state.

Ans - You need to select bi_server component - goto control tab & apply resume button & select yes when prompted to set bi_server component to running state. Your issue will be solved then.

11- All java & opmn components are up & running fine, still you see status of all / some components in down status in Enterprise Manager Oracle Fusion Middleware.

Ans - Click Here For Solution

12- User unable to see Some Subject Area Tables or Columns.

Ans- Its Authorization issue. Setting Proper Permission for the object will resolve the issue.

13- Unable to Login to OBIEE Analytics Page, due to Error as : Failure of server APACHE bridge:

No backend server available for connection: timed out after 10 seconds or idempotent set to OFF or method not idempotent. What action is required to resolve it?

Ans- AdminServer or Bi_Server would either be down or in warning ( hung ) state or Health is not ok. Bouncing it will solve the issue.

14- Many times you encounter the error due to connectivity issue with error as below:

[nQSError: 17014] Could not connect to Oracle database. [nQSError: 17001] Oracle Error code: 12154, message: ORA-12154: TNS:could not resolve the connect identifier specified.

What needs to be done to resolve this?

Ans- Validate Connection pool credentials, with tnsnames.ora entry & your DB credentials. Make them sync to each other & your issue will resolve.

3- User Report performance & Login slowness concern. What needs to be done?

Ans – Do Configurational Changes (NQSConfig.ini & instanceconfig.xml) to solve the issue.

4- Users Report Performance Issue with all reports pertaining to specific Subject Area. What needs to be done?

Ans – Update Session & Repository Init Blocks to rectify the issue.

5- Analytics Application login issue even after all components are up & running fine. What could be issue?

Ans – DB Password of Connection Pool may be changed. Updating them in console will solve the purpose.

6- Schedular component not coming up of opmn components? What can be the reason?

Ans – Repository schema password might be locked or expired. Enabling the same will solve the purpose.

7- Graphs & Charts are not working & showing warning in OBIEE?

Ans – Restarting Javahost component will solve the issue if datatype settings are fine.