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 this issue?
Ans – Edit nQSConfig.ini file Security section
Attribute: PROJECT_INACCESSIBLE_COLUMN_AS_NULL = YES;
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.