12c EM: Accessing the Incident Rules Page Fails with ADFC-10001: cannot instantiate class 'oracle.sysman.core.event.rules.ui.view.IncidentRulesUIBean' / ORA-06502: PL/SQL (Doc ID 1908601.1)

Last updated on JULY 17, 2021

Applies to:

Symptoms

Custom Rulesets have been configured in the 12c Cloud Console.
Accessing the Setup->Incidents->Incident Rules page returns a pop-up with the below error:

ADFC-10001: cannot instantiate class
'oracle.sysman.core.event.rules.ui.view.IncidentRulesUIBean'

It is not possible to view or edit any Ruleset due to this error.

The <gc_inst>/em/EMGC_OMS1/sysman/log/emoms.trc shows the below error:

2014-05-27 14:32:30,655 [[ACTIVE] ExecuteThread: '15' for queue: 'weblogic.kernel.Default (self-tuning)'] WARN  errPopup.ErrorPopupUtil logp.251 - ADFC-10001: cannot instantiate class 'oracle.sysman.core.event.rules.ui.view.IncidentRulesUIBean'
javax.faces.FacesException: oracle.adf.controller.ControllerException: ADFC-10001: cannot instantiate class 'oracle.sysman.core.event.rules.ui.view.IncidentRulesUIBean'
    at oracle.adfinternal.controller.util.Utils.createAndLogFacesException(Utils.java:192)
    at oracle.adfinternal.controller.beans.ManagedBeanFactory.newInstance(ManagedBeanFactory.java:192)
    at oracle.adfinternal.controller.beans.ManagedBeanFactory.instantiateBean(ManagedBeanFactory.java:873)
    at oracle.adfinternal.controller.state.ScopeMap.get(ScopeMap.java:82)
    at javax.el.MapELResolver.getValue(MapELResolver.java:164)
...........
at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2183)
    at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1454)
    at weblogic.work.ExecuteThread.execute(ExecuteThread.java:209)
    at weblogic.work.ExecuteThread.run(ExecuteThread.java:178)
Caused by: oracle.adf.controller.ControllerException: ADFC-10001: cannot instantiate class 'oracle.sysman.core.event.rules.ui.view.IncidentRulesUIBean'
    at oracle.adfinternal.controller.util.Utils.createAndLogFacesException(Utils.java:184)
    ... 76 more
Caused by: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation.  Statement: SELECT * FROM (SELECT RULESET_ID,
    RULESET_NAME,
    RULESET_NAME_NLSID,
    OWNER,
    CREATED_BY,
    DESCRIPTION,
    DESCRIPTION_NLSID,
    RESOURCE_BUNDLE,
    RULESET_ORDER,
    IS_ENABLED,
    IS_VISIBLE,
    IS_READONLY,
    IS_BROKEN,
    PLUGINID,
    IS_BUSINESS,
    LAST_UPDATED_BY,
    LAST_UPDATED_DATE,
    CREATED_DATE,
    TARGET_SELECTION_TYPE,
    SOURCE_SELECTION_TYPE,
    RL_EXPRESSION,
    RULESET_GUID,
    To_Number(Rownum) As Display_Order,
    AllSubscribeUsers
    FROM (
            SELECT EmRuleSetsEO.RULESET_ID,
            EmRuleSetsEO.RULESET_NAME,
            EmRuleSetsEO.RULESET_NAME_NLSID,
            EmRuleSetsEO.OWNER,
            EmRuleSetsEO.CREATED_BY,
            EmRuleSetsEO.DESCRIPTION,
            EmRuleSetsEO.DESCRIPTION_NLSID,
            EmRuleSetsEO.RESOURCE_BUNDLE,
            EmRuleSetsEO.RULESET_ORDER,
            EmRuleSetsEO.IS_ENABLED,
            EmRuleSetsEO.IS_VISIBLE,
            EmRuleSetsEO.IS_READONLY,
            EmRuleSetsEO.IS_BROKEN,
            EmRuleSetsEO.PLUGINID,
            EmRuleSetsEO.IS_BUSINESS,
            EmRuleSetsEO.LAST_UPDATED_BY,
            EmRuleSetsEO.LAST_UPDATED_DATE,
            EmRuleSetsEO.CREATION_DATE AS CREATED_DATE,
            EmRuleSetsEO.TARGET_SELECTION_TYPE,
            EmRuleSetsEO.SOURCE_SELECTION_TYPE,
            EmRuleSetsEO.RL_EXPRESSION,
            Emrulesetseo.Ruleset_Guid,
            rsusrers.all_users as AllSubscribeUsers
            FROM EM_RULE_SETS EmRuleSetsEO
            left outer join
            (select r.ruleset_id,
                    em_incident_rules.table_to_string(CAST(COLLECT(recipient) AS SMP_EMD_LONG_STRING_ARRAY)) as all_users
             from em_rules r,
                  (select acts.rule_id, notif.recipient
                   from em_rule_cond_actions acts,
                   em_rule_basic_notifications notif
                   where acts.COND_ACTION_ID = notif.COND_ACTION_ID) rr
             where r.rule_id = rr.rule_id
             group by r.ruleset_id ) rsusrers
            on EmRuleSetsEO.ruleset_id=rsusrers.ruleset_id
            Where EmRuleSetsEO.Is_Visible=1
            ORDER BY RULESET_ORDER)) QRSLT  ORDER BY RULESET_ORDER
    at oracle.jbo.server.BaseSQLBuilderImpl.processException(BaseSQLBuilderImpl.java:3735)
    at oracle.jbo.server.OracleSQLBuilderImpl.processException(OracleSQLBuilderImpl.java:4725)
    at oracle.jbo.server.QueryCollection.buildResultSet(QueryCollection.java:1467)
    at oracle.jbo.server.QueryCollection.executeQuery(QueryCollection.java:994)
    at oracle.jbo.server.ViewObjectImpl.executeQueryForCollection(ViewObjectImpl.java:7188)
    at oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:1239)
    at oracle.jbo.server.ViewRowSetImpl.executeQueryForMasters(ViewRowSetImpl.java:1419)
    at oracle.jbo.server.ViewRowSetImpl.executeQueryForMode(ViewRowSetImpl.java:1325)
    at oracle.jbo.server.ViewRowSetImpl.executeQuery(ViewRowSetImpl.java:1310)
    at oracle.jbo.server.ViewObjectImpl.executeQuery(ViewObjectImpl.java:7083)
    at oracle.sysman.core.event.rules.ui.view.IncidentRulesUIBean.loadView(IncidentRulesUIBean.java:484)
    at oracle.sysman.core.event.rules.ui.view.IncidentRulesUIBean.<init>(IncidentRulesUIBean.java:162)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
    at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
    at java.lang.Class.newInstance0(Class.java:355)
    at java.lang.Class.newInstance(Class.java:308)
    at oracle.adfinternal.controller.beans.ManagedBeanFactory.newInstance(ManagedBeanFactory.java:187)
    ... 75 more
Caused by: java.sql.SQLException: ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at line 1

    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
    at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)
    at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)

Changes

One of the custom rules created in the Console UI has 60+ email addresses added directly to the rule itself.

Cause

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