OBIEE 11g Configuration Assistant On Windows Fails To Start The Cluster Controller


During the installation process of OBIEE 11g(Version: 11.1.1.3.0 [1905]) , the configuration assistant is failing on the cluster manager configuration and get the following error:

OBIEE 11g Configuration Assistant On Windows Fails To Start The Cluster Controller (Obiccs1) With Error Nqserror: 46036

Executing : opmnctl start coreapplication_obiccs1

The installer *.out log ( [date stamp].out ) in C:\Program Files\Oracle\Inventory\logs will show:

C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\1>SET ORACLE_HOME=C:\[middleware_home]\Oracle_BI1

C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\1>CALL “C:\[middleware_home]\instances\instance1\bin\opmnctl.bat” startproc ias-component=coreapplication_obiccs1
opmnctl startproc: starting opmn managed processes…
================================================================================
opmn id=[hostname]:9501
0 of 1 processes started.

ias-instance id=instance1
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
——————————————————————————–
ias-component/process-type/process-set:
coreapplication_obiccs1/OracleBIClusterControllerComponent/BIClusterController/

Error
–> Process (index=1,uid=993659221,pid=1100)
failed to start a managed process after the maximum retry limit
Log:
none

java.lang.Exception: opmnctl task failed
at oracle.as.install.bi.biconfig.standard.OpmnctlTask.doExecute(OpmnctlTask.java:76)
at oracle.as.install.bi.biconfig.standard.AbstractProvisioningTask.execute(AbstractProvisioningTask.java:79)
at oracle.as.install.bi.biconfig.standard.StandardProvisionTaskList.execute(StandardProvisionTaskList.java:61)
at oracle.as.install.bi.biconfig.BIConfigMain.doExecute(BIConfigMain.java:110)
at oracle.as.install.engine.modules.configuration.client.ConfigAction.execute(ConfigAction.java:335)
at oracle.as.install.engine.modules.configuration.action.TaskPerformer.run(TaskPerformer.java:87)
at oracle.as.install.engine.modules.configuration.action.TaskPerformer.startConfigAction(TaskPerformer.java:104)
at oracle.as.install.engine.modules.configuration.action.ActionRequest.perform(ActionRequest.java:15)
at oracle.as.install.engine.modules.configuration.action.RequestQueue.perform(RequestQueue.java:63)
at oracle.as.install.engine.modules.configuration.standard.StandardConfigActionManager.start(StandardConfigActionManager.java:158)
at oracle.as.install.engine.modules.configuration.boot.ConfigurationExtension.kickstart(ConfigurationExtension.java:81)
at oracle.as.install.engine.modules.configuration.ConfigurationModule.run(ConfigurationModule.java:83)
at java.lang.Thread.run(Thread.java:619)

Checking the Cluster Controller diagnostic log in:

[drive:\[middleware_home]\instances\instance1\diagnostics\logs\OracleBIClusterControllerComponent\coreapplication_obiccs1

will show:

[nQSError: 46036] Internal Assertion: Condition rCCSNodeDB.SetConfigInfo(rCCSNodeDB.GetOurNodeId(), GetClusterServerStartTime()), file server\cluster\clusterserver\Src\CLSMain.cpp, line 262

The main reason for this error is related to network setting on your server.
It is usually reproduced on machines that are configured with DHCP or in a private network (such as a NAT configuration in a virtual machine) and the loopback adapter is not configured or configured correctly.  It generally does not occur with a static IP address configuration; however, it could possibly occur if network domain name server (DNS) resolution is not configured or configured correctly.

From a command prompt, execute the following:

  • nslookup hostname
  • nslookup hostname.domainname
  • nslookup IP address

Each command should resolve without errors. If there are errors, please see your network administrator.

The network configuration needs to be done before the installation starts; however, if you are stuck at the configuration assistant “progress screen”, then a workaround would be to remove any occurrence of a domain name from the following file:

[middleware_home]\instances\instance1\config\OracleBIApplication\coreapplication\NQClusterConfig.INI

After you have changed the file, then click the ‘retry’ button in the configuration assistant.

Lastly, if using a static IP and the above solutions do not resolve the problem then do the following:

  • Update your Windows host file located(32-bit or 64-bit) at:
    [drive]:Windows\System32\drivers\etc\hostto include the machine IP Address and hostname, for example:10.100.100.10  hostname
    10.100.100.10  hostname.domain   (For the machine having Fully Qualified Domain Name (FQDN))

After that click the ‘retry’ button in the configuration assistant for it to continue or run the following command in an administrator command shell to check and start the Cluster Controller before retrying in the configuration assistant.
[middleware home]\instances\biee_instance\bin>opmnctl.bat startproc ias-component=coreapplication_obiccs1

Narrative view issue with OBIEE 11g


Currently I was looking into Narrative view syntax for OBIEE 11g and it seems the older HTML tag based syntax is obsolete and not work properly as expected .Therefore ,  below syntax is not functional anymore with OBIEE 11g however it works perfectly fine with OBIEE 10.1.3.4.0 release :

<table width=”100%” cellpadding=”3″>
<tr>
<td width=”60%” align=”left” valign=”top”><b><font size=”2″>Prescription Sales</font></b></td>
<td width=”40%”align=”left” valign=”top”><b><font size=”2″ color=”green”><u>@2</u></font></b></td>
</tr>
</table> 
 

However following syntax works fine:

[b]Hello World[/b] = [b]@2[/b]

In order to get the above HTML tag based example working fine we need to do two things:

1) Set HardenXSS to false in the instanceconfig.xml file and restart the service. Here is a snippet of a working instanceconfig.xml with this tag:

<Security>
<!–This Configuration setting is managed by Oracle Business Intelligence
Enterprise Manager–>
<ClientSessionExpireMinutes>210</ClientSessionExpireMinutes>
<!–HardenXSS is not managed by Enterprise manager–>
<HardenXSS>false</HardenXSS>
</Security>

2) Restart the Presentation server after making changes to instanceconfig.xml.

3) Check the “Contains HTML markup” checkbox in the Narative view.