OBIEE 11g Errors: Root XML Node nqw not found in island!


Gosh… I got a strange error today while building one of reports using Answers. The error suddenly appears as “Root XML Node nqw not found in island!” after I modified the report and run it in the dashboard .

The main concern is that the error appearing while I am trying  to edit the request. The error is so annoying that I am neither being able to modify the request and nor being able to run this (actually it is throwing error) .

Reason why it is appearing is , I was just define one presentation variable against the Multiselect Product name and prompted that in the reports criteria filter section . And after running the request it starts throwing this absurd error !! I am not being able to come out from the issue even after logout and clearing the browser session .

This could be resolved by editing the report content using Catalog manager and removing the buggy presentation variable . I have not done much r&d with this report and leave it as it is …. So buggy and frustrating error !!! 😦 I will try to replicate the behavior in a similar but small prototype just to nail down the issue and will update into thread if I find something really useful .

Bypass Username and Password on Weblogic server Startup


It’s always annoying to put Weblogic server username and password on server start-up and shutdown. It would be nice if the process could be automated. There are two different approach for this. Making this as Windows Service and set it as ‘Automatic’ in Startup Type .Other controllable approach is to manipulate the StartStopservices.cmd file of weblogic to pass the weblogic user name and password variable with a hard-coded predefined value .

To adopt the second approach take the backup of file “StartStopServices.cmd” located in below path:

.\\[MIDDLEWARE_HOME]\instances\instance1\bifoundation\OracleBIApplication\coreapplication

and add the below strings to pass the value of the variables: -DWLS_USER=weblogic -DWLS_PW=weblogic#1

(here “weblogic#1” is my password)

Save the file and start the BI Services. It will take the username and password automatically reading from the file and trigger the start-up activities …

This will save some keystrokes at-least 🙂

weblogic.security.SecurityInitializationException: Authentication for user weblogic denied


I just tried to see what will be the “Start BI Services” prompt while I put wrong username and password and unfortunately  it didn’t return the result as expected if  the input is wrong .

It returns below window and neither Admin , Managed server nor the Node manager process get started(due to obvious security reason and verification failure)  but the window is hanging on prompted nothing… and this is an genuine issue . User is expecting some information at the screen …. which is not the case now … So user needs to press [Control+C] to abort from the screen …

After dig down to the (..\\[Middleware_Home]\user_projects\domains\bifoundation_domain\servers\AdminServer\logs\AdminServer.log) file it returns below errors:

#### <[ACTIVE] ExecuteThread: ‘0’ for queue: ‘weblogic.kernel.Default (self-tuning)’> <> <> <> <1301221608750> weblogic denied>
#### <<WLS Kernel>> <> <> <1301221608766> weblogic.security.SecurityInitializationException: Authentication for user weblogic denied
weblogic.security.SecurityInitializationException: Authentication for user weblogic denied
at weblogic.security.service.CommonSecurityServiceManagerDelegateImpl.doBootAuthorization(CommonSecurityServiceManagerDelegateImpl.java:965)
at weblogic.security.service.CommonSecurityServiceManagerDelegateImpl.initialize(CommonSecurityServiceManagerDelegateImpl.java:1050)
at weblogic.security.service.SecurityServiceManager.initialize(SecurityServiceManager.java:875)
at weblogic.security.SecurityService.start(SecurityService.java:141)
at weblogic.t3.srvr.SubsystemRequest.run(SubsystemRequest.java:64)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:201)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:173)

Caused By: javax.security.auth.login.FailedLoginException: [Security:090304]Authentication Failed: User weblogic javax.security.auth.login.FailedLoginException: [Security:090302]Authentication Failed: User weblogic denied
at weblogic.security.providers.authentication.LDAPAtnLoginModuleImpl.login(LDAPAtnLoginModuleImpl.java:250)
at com.bea.common.security.internal.service.LoginModuleWrapper$1.run(LoginModuleWrapper.java:110)
at com.bea.common.security.internal.service.LoginModuleWrapper.login(LoginModuleWrapper.java:106)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at javax.security.auth.login.LoginContext.invoke(LoginContext.java:769)
at javax.security.auth.login.LoginContext.access$000(LoginContext.java:186)
at javax.security.auth.login.LoginContext$4.run(LoginContext.java:683)
at javax.security.auth.login.LoginContext.invokePriv(LoginContext.java:680)
at javax.security.auth.login.LoginContext.login(LoginContext.java:579)
at com.bea.common.security.internal.service.JAASLoginServiceImpl.login(JAASLoginServiceImpl.java:113)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.bea.common.security.internal.utils.Delegator$ProxyInvocationHandler.invoke(Delegator.java:57)
at $Proxy22.login(Unknown Source)
at weblogic.security.service.internal.WLSJAASLoginServiceImpl$ServiceImpl.login(WLSJAASLoginServiceImpl.java:91)
at com.bea.common.security.internal.service.JAASAuthenticationServiceImpl.authenticate(JAASAuthenticationServiceImpl.java:82)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.bea.common.security.internal.utils.Delegator$ProxyInvocationHandler.invoke(Delegator.java:57)
at $Proxy40.authenticate(Unknown Source)
at weblogic.security.service.WLSJAASAuthenticationServiceWrapper.authenticate(WLSJAASAuthenticationServiceWrapper.java:40)
at weblogic.security.service.PrincipalAuthenticator.authenticate(PrincipalAuthenticator.java:348)
at weblogic.security.service.CommonSecurityServiceManagerDelegateImpl.doBootAuthorization(CommonSecurityServiceManagerDelegateImpl.java:929)
at weblogic.security.service.CommonSecurityServiceManagerDelegateImpl.initialize(CommonSecurityServiceManagerDelegateImpl.java:1050)
at weblogic.security.service.SecurityServiceManager.initialize(SecurityServiceManager.java:875)
at weblogic.security.SecurityService.start(SecurityService.java:141)
at weblogic.t3.srvr.SubsystemRequest.run(SubsystemRequest.java:64)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:201)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:173)
>
#### <<WLS Kernel>> <> <> <1301221608844>
#### <<WLS Kernel>> <> <> <1301221608844>
#### <<WLS Kernel>> <> <> <1301221608844>
#### <<WLS Kernel>> <> <> <1301221608859>

OBIEE 11g strange Error ! EM throwing error in startup but OPMN showing all Alive


While starting up all the OPMN managed processes i.e trigger start button from Business Intelligence (coreapplication)  module of OBIEE 11g Fustion Middleware EM console ,I got and error that failed to start all the processes.

Gosh ….! So many errors …This is the irony of fate with me and nothing gone in very straightway unfortunately 😦

Just peeped out to the log message file and I got couple of error notification like:

EM-02694 – Supplementary information regarding operation : BI_INSTANCE:coreapplication;FAILED_TO_START;Error in starting one or more components of BI Instance; Please check the server log files for detailed message.

Supplementary information regarding operation: DOMAIN;WAITING_FOR_OPMN;Timeout; Waiting for OPMN to start process

Actually the reason for the surprise came later when I see OPMNCTL status showing all BI Sys component processes are Alive . I can login to application and browse through the reports as well .

Now while I refresh the EM page I can see all processes are up with the green status.

So something really is not in sync. Possible reason OPMN and EM communication syncronisation ?? Don’t know …. So thumb rule, as per this release, don’t rely on EM message on server issue and log …rather see if OPMN managed processes are up and running fine or not .

OBIEE 11g Error : NQSerror 42016 – Check database specific features table. Must be able to push at least a single table reference to a remote database.


I was just in a process of configuring the SampleAPP application and that leads to a very strange error:

After setup everything when I navigated through the report it is throwing below error:

As per the error message is concerned , some problem can be with the Database features .But I am quite sure that I haven’t tamper with it .After I peeped into the database features in RPD it reveals nothings set as Database defaults. Anyway after click on ‘Reset to Defaults’ resolves my issue and I am not getting this error anymore 🙂

Note that: This issue could be with the SampleAPP.rpd which come as free application in  OBIEE 11g Shiphome build .

OBIEE 11g Error: NQS 46028 Unable to get the DLL path for the CLI 10g/11g from the NQSConfig.ini file


The behavior has been found in current release of OBIEE 11g .The same problem persist even if you upgrade the OBIEE 10g RPD to 11g version. The problem has been found during “metadata import using the TNS having OCI 10g/11g drive”r or while “view data in RPD” .

The error line shows :

NQS 46028:  Unable to get the DLL path for the CLI 10g/11g from the NQSConfig.ini file

The DB connectivity seems okay using command prompt or sqlplus option .

‘tnsping <service_name>’ from command return the response perfectly .So it is not the DB issue rather RPD is not being able to connect to DB .

Following the below steps resolved the issue:

1) Copied the ‘tnsnames.ora’ from Oracle DB path “E:\OraDeba11gR2\product\11.2.0\dbhome_1\NETWORK\ADMIN”  to “E:\OraFMW11g\Oracle_BI1\network\admin” doesn’t resolves the issue fully .

2) Create a Environment System variable in windows advanced option of system properties called as ORACLE_INSTANCE and set the value asE:\OraFMW11g\instances\instance1′   (without quote) .

3) Use absolute connection pool information to RPD or if the VALUEOF has been used just need to make sure that it will match exactly with the tnsnames.ora configuration . (having same value for SID or SERVICE_NAME will be fine in some cases)

ORADEBA =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = Oradeba)
)
)

4) Restart the BI Server .

Voila …Everything will be fine  🙂

The reason behind the issue is that, till earlier release of OBIEE 1og doesn’t bundled with the Oracle client hence the required drivers and all the DB connectivity has been done using the default native Oracle driver(having single look-up point for tnsnames.ora) .But  OBIEE 11g itself includes the Oracle client bundle, hence connecting from repository will always try to look-up the tnsnames.ora file inside the Fusion path rather 11g DB network\admin path .So copying the same TNS file across two path resolves the issue.

Hopefully Oracle will fix the issue in later release just to pick the absolute reference of Oracle DB path always.

OBIEE 11g Error: Unable to start coreapplication_obips1 component


While OBIEE presentation server is not up and running you will get below messages:

Error 500–Internal Server Error
From RFC 2068 Hypertext Transfer Protocol — HTTP/1.1:
10.5.1 500 Internal Server Error
The server encountered an unexpected condition which prevented it from fulfilling the request.

Just check the status of all OBIEE components using opmnctl command as below
F:\MiddlewareHome\instances\instance1\bin>opmnctl status

All the components are alive except coreapplication_obips1.

Processes in Instance: instance1
———————————+——————–+———+———
ias-component | process-type | pid | status
———————————+——————–+———+———
coreapplication_obiccs1 | OracleBIClusterCo~ | 1160 | Alive
coreapplication_obisch1 | OracleBIScheduler~ | 1604 | Alive
coreapplication_obijh1 | OracleBIJavaHostC~ | 5484 | Alive
coreapplication_obips1 | OracleBIPresentat~ | N/A | Down
coreapplication_obis1 | OracleBIServerCom~ | 1236 | Alive

Also EM log showing error message below:

Failed to get messages for target /Farm_bifoundation_domain

Also the diagnostic log shows below:

EM-02694    Supplementary information regarding operation:
PROCESS:coreapplication_obips1;FAI

There may be various reason to it and one of the obvious reason is Loop-back adapter not configured for DHCP client .

The another main reason is any mistake at ‘instanceconfig.xml’ file .Any mistake in instanceconfig.xml tag placement could cause the issue of BIPS not starting up properly .Just correct the issue if did any changes and try to restart the service individually from EM UI .

Hope this could help somebody as it is very difficult to dig into issue just because of the junk OBIEE log file 😦 So tip is , do think and not blindly incorporate !!