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.
You will be able to access report, but column with security restriction will appear with no data.
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.
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.
15- OBIEE Analytics page is working fine. But you cannot login Fusion Middleware OEM & weblogic console. How to resolve such issue?
Ans- Click Here For Solution
16- User Faces Error while executing report modification in analysis as : Exceeded Configured Maximum Number Of Allowed Output Prompts, Prompts, Sections, Rows or Columns Error Codes : IRVLJWTA:OI2DL65P
Ans- You need to update parameter values in instanceconfig.xml file of obiee presentation component for the view type causing issue
17- What happens when you face Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P, while executing results in OBIEE?
Ans- This happens due to datatype mismatch of calculated column used in report wrt column in repository. Make changes to datatype & your issue will be resolved.
:)
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.
15- OBIEE Analytics page is working fine. But you cannot login Fusion Middleware OEM & weblogic console. How to resolve such issue?
Ans- Click Here For Solution
16- User Faces Error while executing report modification in analysis as : Exceeded Configured Maximum Number Of Allowed Output Prompts, Prompts, Sections, Rows or Columns Error Codes : IRVLJWTA:OI2DL65P
Ans- You need to update parameter values in instanceconfig.xml file of obiee presentation component for the view type causing issue
17- What happens when you face Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P, while executing results in OBIEE?
Ans- This happens due to datatype mismatch of calculated column used in report wrt column in repository. Make changes to datatype & your issue will be resolved.
:)