Print Friendly, PDF & Email

 
ISSUE

After a 12.1.0.5.0 agent was successfully installed on a target host and a database was discovered in Enterprise Manager the selecting a Database Target link in Enterprise Manager 13c Release 3 Cloud Control Results in Errors.
 
It’s very likely the other versions of agents are affected too.

 
SYMPTOMS

Selecting a target database link from Targets -> Databases fails with the error :

ADF_FACES-60097: For more information, please see the server's error log for an entry beginning with: ADF_FACES-60096:Server Exception during PPR, #9

 
Clicking on the UPKPROD database link below results to the error

When clicking on the database link the following exceptions are written to the enoms.trc trace file on the OMS host

oracle@s001as-oem13c-r3|09:55|~: tail -30f /oracle/oem13300/gc_inst/em/EMGC_OMS1/sysman/log/emoms.trc
2019-03-06 09:55:51,142 [[ACTIVE] ExecuteThread: '5' for queue: 'weblogic.kernel.Default (self-tuning)'] WARN  errPopup.ErrorPopupUtil logp.251 - WidthNotInPixel is not set https://s001as-oem13c-r3.dbpilot.net:7803/em/faces/db-list-dbList?Adf-Window-Id=w0&Adf-Page-Id=25 REQUEST_METHOD: POST View Id: /db-homepage-home
javax.el.ELException: java.lang.UnsupportedOperationException: WidthNotInPixel is not set
        at javax.el.BeanELResolver.getValue(BeanELResolver.java:368)
        at com.sun.faces.el.DemuxCompositeELResolver._getValue(Unknown Source)
        at com.sun.faces.el.DemuxCompositeELResolver.getValue(Unknown Source)
        at com.sun.el.parser.AstValue.getValue(AstValue.java:138)
        at com.sun.el.parser.AstValue.getValue(AstValue.java:183)
        at com.sun.el.ValueExpressionImpl.getValue(ValueExpressionImpl.java:224)
        at org.apache.myfaces.trinidad.bean.FacesBeanImpl.getProperty(FacesBeanImpl.java:73)
        at org.apache.myfaces.trinidad.component.UIXComponentBase.getProperty(UIXComponentBase.java:1912)
        at org.apache.myfaces.trinidad.component.UIXIterator.getValue(UIXIterator.java:789)
        at org.apache.myfaces.trinidad.component.UIXCollection.__flushCachedModel(UIXCollection.java:1963)
        at org.apache.myfaces.trinidad.component.UIXCollection.__processFlattenedChildrenBegin(UIXCollection.java:1946)
        at org.apache.myfaces.trinidad.component.UIXIterator.processFlattenedChildren(UIXIterator.java:160)
        at org.apache.myfaces.trinidad.component.UIXComponent.processFlattenedChildren(UIXComponent.java:173)
        at org.apache.myfaces.trinidad.component.UIXComponent.processFlattenedChildren(UIXComponent.java:330)
        at org.apache.myfaces.trinidad.component.UIXComponent.processFlattenedChildren(UIXComponent.java:249)
        at oracle.adfinternal.view.faces.renderkit.rich.PanelGroupLayoutRenderer.encodeAll(PanelGroupLayoutRenderer.java:345)
        at oracle.adf.view.rich.render.RichRenderer.encodeAll(RichRenderer.java:1648)
        at org.apache.myfaces.trinidad.render.CoreRenderer.encodeEnd(CoreRenderer.java:525)
        at org.apache.myfaces.trinidad.component.UIXComponentBase.encodeEnd(UIXComponentBase.java:1217)
        at javax.faces.component.UIComponent.encodeAll(Unknown Source)

		....
		
        at weblogic.work.ExecuteThread.execute(ExecuteThread.java:311)
        at weblogic.work.ExecuteThread.run(ExecuteThread.java:263)
Caused by: java.lang.UnsupportedOperationException: WidthNotInPixel is not set
        at oracle.sysman.emSDK.view.graph.StackedCigar.getMinVisibleWidth(StackedCigar.java:250)
        at oracle.sysman.sdkImpl.core.regions.ui.availability.AvailabilityPageModel.processCigar(AvailabilityPageModel.java:290)
        at oracle.sysman.sdkImpl.core.regions.ui.availability.AvailabilityPageModel.initializeData(AvailabilityPageModel.java:168)
        at oracle.sysman.sdkImpl.core.regions.ui.availability.AvailabilityPageModel.getTargetAvailHistory(AvailabilityPageModel.java:489)
        at sun.reflect.GeneratedMethodAccessor3161.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:606)
        at javax.el.BeanELResolver.getValue(BeanELResolver.java:363)
        ... 356 more

If a discovered database was added to any group you could see the n/a status in the Availability(%) column on the group details page

When dragging mouse cursor over the n/a status a popup message is displayed telling us that the target in the Pending state

 
CONFIGURATION

OMS host :
Hostname                  : s001as-oem13c-r3.dbpilot.net
Operating System    : Oracle Linux Server release 7.6
Enterprise Manager : Enterprise Manager Cloud Control 13c Release 3 (13.3.0.0.0)

Target Host :
Hostname                   : s001db-upk.dbpilot.net
Operating System    : Red Hat Enterprise Linux Server release 5.11 (Tikanga)
Agent Version           : OMS Agent 12.1.0.5.0
Agent Instalation     : Manual, using an agent.rsp file

 
SOLUTION

Check the current time on both servers. If they are in the same timezone they should have the same time.


###################
## OMS Host
###################
oracle@s001as-oem13c-r3|10:45|~: date && date -R
Wed Mar  6 10:45:30 MSK 2019
Wed, 06 Mar 2019 10:45:30 +0300


###################
## Target Host
###################
oracle@s001db-upk|15:38|~:date && date -R
Wed Mar  6 15:38:47 MSK 2019
Wed, 06 Mar 2019 15:38:47 +0300

In this example, both servers are in the same timezone (MSK +0300) but the clock of the target host is about 5 hours fast.

So, to fix the issue just adjust the time on both servers and re-discover targets.


###################
## OMS Host
###################
[root@s001as-oem13c-r3 ~]# ntpdate  0.rhel.pool.ntp.org
 6 Mar 10:55:44 ntpdate[4215]: adjust time server 0.rhel.pool.ntp.org offset 0.164590 sec

###################
## Target Host
###################
[root@s001db-upk ~]# ntpdate  0.rhel.pool.ntp.org
 6 Mar 10:53:31 ntpdate[30669]: step time server0.rhel.pool.ntp.org offset -16998.641678 sec

Confirm that time is adjusted on both servers


###################
## OMS Host
###################
[root@s001as-oem13c-r3 ~]# date && date -R
Wed Mar  6 11:01:31 MSK 2019
Wed, 06 Mar 2019 11:01:31 +0300

###################
## Target Host
###################
[root@s001db-upk ~]# date && date -R
Wed Mar  6 11:01:31 MSK 2019
Wed, 06 Mar 2019 11:01:31 +0300

Now when the time is adjusted, remove targets and perform Discovery again
 
After a re-discovered database was promoted the database link became working as expected

 
 

Version   : 11:32 AM 06.03.2019
Platform  : Oracle Enterprise Linux 7.6
OEM       : 13.3.0.0.0
OMS Agent : 12.1.0.5