OBIEE 11g : Scale up of Presentation Server in Enterprise Manager Fails on Activate Changes with 'Commit failed with 0 errors and 2 warnings'
Last updated on AUGUST 25, 2017
Applies to:Business Intelligence Suite Enterprise Edition - Version 22.214.171.124.0 and later
Microsoft Windows x64 (64-bit) - Version: 2008 R2
OBIEE 11g was scaled out horizontally across 2-nodes, it was discovered that the Presentation Server (OBIPS) was no longer deployed / running in instance2 on Node-2
On Node-2, <MW_HOME>/instances/instance2/bin/opmnctl status does not list the "coreapplication_obips1" component; and there is no <ias-component id="coreapplication_obips1"> entry in the <MW_HOME>/instances/instance2/config/OPMN/opmn/opmn.xml file.
In Enterprise Manager > Business Intelligence > coreapplication > Availability > Processes, see there is no "coreapplication_obips1" for instance2.
In Enterprise Manager > Business Intelligence > coreapplication > Capacity Management > Scalability, see Presentation Servers = 0 for instance2.
To scale up OBIPS on Node-2: Lock and Edit Configuration > Raise the above value from 0 to 1 > Apply > Activate Changes ... but see the following error is thrown:-
Activate Changes - Completed Successfully
Commit failed with 0 errors and 2 warnings. Problems reported by: <server>:coreapplication_obips1, <server>:coreapplication credstore.
The following errors are written in the Enterprise Manager log file <BI_DOMAIN>/servers/AdminServer/sysman/log/emoms.log:-
The following were also observed:-
1. <BI_DOMAIN>/config/fmwconfig/biee-domain.xml (On Node-1 and Node-2) shows a "coreapplication_obips1" in instance2
2. <BI_DOMAIN>/opmn/topology.xml (On Node-1) shows a "coreapplication_obips1" in instance2
3. <MW_HOME>/instances/instance2/config/OracleBIPresentationServicesComponent exists but is empty
4. <MW_HOME>/instances/instance2/... contains various other OracleBIPresentationServicesComponent sub-folders
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms