ERROR com.splwg.oms.jbot.JDBCDataStore: DS_FEEDERS.populate Appears in WebWorkspace Client Log (Doc ID 2916615.1)

Last updated on DECEMBER 23, 2022

Applies to:

Goal

Seeing the following error in the WebWorkspace client log which was not previously happening.

2022-12-14 11:58:20,703 [AWT-EventQueue-0] INFO com.splwg.oms.client.util.proxy.FaultToleranceContextFactory: invoke: revalidating public abstract com.splwg.oms.common.intersys.EJBResultSet com.splwg.oms.ejb.session.ISession.executeAdminQuery(java.lang.String) throws java.sql.SQLException
2022-12-14 11:58:20,718 [AWT-EventQueue-0] ERROR com.splwg.oms.jbot.JDBCDataStore: DS_FEEDERS.populate
javax.ejb.EJBTransactionRolledbackException: EJB Exception: ; nested exception is:
javax.ejb.EJBAccessException
at weblogic.ejb.container.internal.BaseRemoteObject.handleSystemException(BaseRemoteObject.java:542) ~[?:?]
at weblogic.ejb.container.internal.BaseRemoteObject.postInvoke1(BaseRemoteObject.java:370) ~[?:?]
at weblogic.ejb.container.internal.StatelessRemoteObject.postInvoke1(StatelessRemoteObject.java:20) ~[?:?]
at weblogic.ejb.container.internal.BaseRemoteObject.__WL_postInvokeTxRetry(BaseRemoteObject.java:307) ~[?:?]
at weblogic.ejb.container.internal.SessionRemoteMethodInvoker.invokeInternal(SessionRemoteMethodInvoker.java:67) ~[?:?]
at weblogic.ejb.container.internal.SessionRemoteMethodInvoker.invoke(SessionRemoteMethodInvoker.java:21) ~[?:?]
at com.splwg.oms.ejb.session.Session_a1u24g_RemoteSessionImpl.executeAdminQuery(Unknown Source) ~[?:?]
at sun.reflect.GeneratedMethodAccessor843.invoke(Unknown Source) ~[?:?]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_351]
at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_351]

The managed server .out file should also be logging query issues that can help track down the invalid feeders.  Look for similar messages as this

2022-12-14 11:58:23,049 [[ACTIVE] ExecuteThread: '21' for queue: 'weblogic.kernel.Default (self-tuning)'] WARN com.splwg.oms.ejb.session.Session: nms-security: <USER> does not have admin access for query select h_cls, h_idx, birth_patch, active, feeder_name, substation_name, color, flm_enabled, vvo_enabled, flisr_enabled, fla_enabled, engine, vvo_objective, pf_history_enabled, protection_schemes_enabled, protection_schemes_mode, nca_objective, feeder_type, flm_custom_mode from feeders where active in ('Y','A') AND ((h_cls = 998 AND h_idx = ######)) order by substation_name, feeder_name

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.