✍ Kashif M

Thursday, 27 February 2014

Missing navigation space for subject area

Missing navigation space for subject area


State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 15002] Missing navigation space for subject area…. (HY000)

Cause of the Error:

1.       If you create an initialization box with non- logical query it may stop or hang the services of BI.

2.      Some times over load of executing from Admin Tool also it will cause.

3.      Database may not retrieve the data according to the query used in BI.

4.      In BMM layer or Physical layer joins also may cause this error.


1.      Check all the services of BI.

2.      If anything got down restart the services then check the report.

3.      If any of the measure column from the subject area if greyed out, then just edit the measure logical column and see the report.

4.      Check the joins are in proper.

Screen Shots:

Missing navigation space for subject area
Missing navigation space for subject area

Sunday, 16 February 2014

mapplet in informatica

Set of transformation that can we be re-used.

single transformation that can be re-used in multiple mapping is called mapplet

informatica 9.5 1 client installation steps

worklets in informatica

An informatica object representing the set of grouping of task

Re-usable worklet - create in worklet designer

Non-reusable worklet - create in workflow designer

To Start OBIEE 11g services in Linux

Login in root user
1.       Start Administration service.
Wait unstill status comes to running mode


2.       Start Node Manager
Wait until secure socket listener started on port 9556

3.       Start Managed server
Format should be in startManagedweblogic.sh bi_server1 http://obiee.7stl.com:7001
Wait until server started in running mode

4.       Start opmnal

./opmnctl  startall

Blog Archive


1z0-482 Dumps (2) 1Z0-525 Dumps (1) About Kashif (1) BI Apps Installation (1) BI Publisher (2) BI Publisher Interview Questions (1) BICS (2) Business Intelligence (1) DATA WAREHOUSE ADMINISTRATOR CONSOLE (18) Data Warehousing (48) E-BIZ R12 (1) E-BIZ R12 INSTALLATION (1) Essbase (1) hmailserver (1) Hyperion (1) Hyperion Essbase (2) Hyperion Essbase Interview Questions (1) Hyperion financial management (1) Informatica (163) Informatica Installation 9.6.1 (2) Informatica Interview Question (47) Informatica Online Training (1) informatica scenarios questions (1) Informatica Training (1) Informatica Training Chennai (1) JAVA (1) linux (1) mkashu (1) Normalization in Oracle (1) OBIA (1) OBIA (3) OBIA Installation (33) OBIEE (2) OBIEE 10G (8) OBIEE 11G (138) OBIEE 11g dumps (2) OBIEE 11g Interview Questions (1) OBIEE 12c (20) OBIEE 12c Architecture (1) OBIEE 12C TRAINING (1) OBIEE certification (2) OBIEE Interview Question (1) OBIEE Publisher Interview Questions (1) OBIEE TRAINING CHENNAI (1) OBIEE TRAINING ONLINE (1) ODI (Oracle data integrator) (2) odi 11g certification (1) ODI dumps (2) Oracle Administrator (20) Oracle Business Intelligence Application (3) Oracle Data Integrator (2) Oracle Data Integrator Interview questions for experience (1) Oracle Database (3) Oracle Database 12c Installation steps (3) Oracle Database Installation in Linux 6 (2) Oracle E-Business R 12.3 (1) Oracle Hyperion Planning and Budgeting Questionnaire (2) oracle Joins (1) Power BI (5) RCU INSTALLATION (1) scorecard in obiee 11g (1) SQL (3) SQL Interview Questions (1) sql server 2008 (2) Sql server installation (1) WinSCP (1)