af:query: Reset Button Fails With AttrValException JBO-27036 When jbo.ampool.doampooling=false (Doc ID 1325762.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle JDeveloper - Version 11.1.1.3.0 to 11.1.1.5.0 [Release Oracle11g]
Information in this document applies to any platform.

Symptoms

You have developed an ADF Faces/BC application in JDeveloper 11.1.1.4.0
Some pages have an af:query based on a View Criteria where Criteria items have the property "Validation" set to "Selectively Required".
When running the page under normal conditions, the page works correctly.
Under heavy load, however, end users get the following error when they click the "Reset" button after they executed a query:

"At least one of the following attributes <list of criteria items> is required."



and the following stack trace is displayed in the Logs:

<Utils> <buildFacesMessage> ADF: Adding the following JSF error message: At least one of the following attributes FirstName, LastName, PhoneNumber is required.
oracle.jbo.AttrValException: JBO-27036: At least one of the following attributes FirstName, LastName, PhoneNumber is required.
   at oracle.jbo.rules.JboVCItemRequiredValidator.validate(JboVCItemRequiredValidator.java:207)
   at oracle.jbo.common.ViewCriteriaImpl.validateRow(ViewCriteriaImpl.java:608)
   at oracle.jbo.common.ViewCriteriaImpl.validate(ViewCriteriaImpl.java:569)
   at oracle.jbo.server.ViewRowSetImpl.validateViewCriteria(ViewRowSetImpl.java:8086)
   at oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:1167)
   at oracle.jbo.server.ViewRowSetImpl.activateRowSetState(ViewRowSetImpl.java:7173)
   at oracle.jbo.server.ViewRowSetIteratorImpl.activateIteratorState(ViewRowSetIteratorImpl.java:3929)
   at oracle.jbo.server.ViewRowSetIteratorImpl.getRangeSize(ViewRowSetIteratorImpl.java:627)
   at oracle.jbo.server.ViewRowSetImpl.getRangeSize(ViewRowSetImpl.java:2899)
   at oracle.jbo.server.ViewObjectImpl.getRangeSize(ViewObjectImpl.java:10141)
   at oracle.adf.model.binding.DCIteratorBinding.initSourceRSI(DCIteratorBinding.java:1858)
   at oracle.adf.model.binding.DCIteratorBinding.callInitSourceRSI(DCIteratorBinding.java:1670)
   at oracle.adf.model.binding.DCIteratorBinding.internalGetRowSetIterator(DCIteratorBinding.java:1643)
   at oracle.adf.model.binding.DCIteratorBinding.refresh(DCIteratorBinding.java:4345)
   at oracle.adf.model.binding.DCExecutableBinding.refreshIfNeeded(DCExecutableBinding.java:341)
   at oracle.jbo.uicli.binding.JUCtrlHierNodeBinding.getChildren(JUCtrlHierNodeBinding.java:723)
   at oracle.jbo.uicli.binding.JUCtrlHierBinding.getHintMap(JUCtrlHierBinding.java:286)
   at oracle.jbo.uicli.binding.JUCtrlHierBinding.getHints(JUCtrlHierBinding.java:463)
   at oracle.jbo.uicli.binding.JUCtrlValueBinding.internalGet(JUCtrlValueBinding.java:2277)
   at oracle.jbo.uicli.binding.JUCtrlRangeBinding.internalGet(JUCtrlRangeBinding.java:549)
   at oracle.jbo.uicli.binding.JUCtrlHierBinding.internalGet(JUCtrlHierBinding.java:448)
   ...



If they press "Reset" a second time, they get a popup error:

JBO-27036: At least one of the following attributes <list of criteria items> is required.

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, #2"



The problem can be reproduced at will in the Development environment by setting jbo.ampool.doampooling=false, as explained in the following note:
<Note:417546.1> - How To Reproduce Problems Related to AM Passivation / Activation

A similar issue had been reported in the past.
At this time, the root cause had been identified as being the following bug:
<Bug:9902529> - SEARCH REGION VALUES ARE GETTING LOST AFTER PASSIVATION

However this bug was considered as fixed in JDeveloper 11.1.1.4.0
You have migrated to JDeveloper 11.1.1.4.0 but still encountered the issue there.

Cause

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