✍ Kashif M ™
☎ +91 9994883085
✉ kashif7222@gmail.com


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