ADF_FACES-60097: FOR MORE INFORMATION, PLEASE SEE THE SERVER’S ERROR LOG
ISSUE
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
Platform : Oracle Enterprise Linux 7.6
OEM : 13.3.0.0.0
OMS Agent : 12.1.0.5
Tags In
Categories
- Linux (8)
- Iptables (2)
- Memory Usage (1)
- Postfix (1)
- Yum (4)
- Networker (2)
- Oracle (65)
- Account (2)
- AWR (2)
- Database Errors (6)
- Database Performance (9)
- Datapump (4)
- Enterprise Manager (24)
- Enterprise Manager Metrics (4)
- Environments (4)
- High CPU Usage (2)
- High IO Load (4)
- Initialization Parameters (5)
- job_queue_processes (1)
- Processes (3)
- NLS (1)
- Objects (1)
- Objects DDL (2)
- OJVM/PSU/DRU Patches (1)
- PL/SQL (5)
- UTL_FILE (4)
- Prerequisites (1)
- Privileges (1)
- Profile (1)
- Queries (2)
- Redologs (1)
- Resource Limits (1)
- Segment Shrink (1)
- Session (6)
- Spfile (3)
- SQL PLUS (1)
- Spooling (1)
- Standard Queries (7)
- Statistics (2)
- Tablespaces (1)
- Temporary Tablespace (2)