Oracle Business Intelligence Application Architect
☎ +91 9994883085
Don't miss

Thursday, 27 February 2014

Missing navigation space for subject area


Missing navigation space for subject area

Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P:OI2DL65P

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.

Solutions:

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.
Home/obiee/bi11g/user_projects/domains/bifoundation_domain/bin/Startweblogic.sh
Wait unstill status comes to running mode




 








2.       Start Node Manager
/home/obiee/bi11g/wlserver_10.3/server/bin/startNodemanager.sh
Wait until secure socket listener started on port 9556








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





4.       Start opmnal
/home/obiee/bi11g/instance/instance1/bin/opmnctl

./opmnctl  startall

Blog Archive