Anyone facing such issue or has any pointers?
We have a query panel and table for results on a page and there is export button which uses the exportCollectionActionListener.
In production environment, when the users are exporting we are getting the error in the exported excel.
This is working fine in all lower environments even for larger data set. In PROD it fails at around 7K rows
Export is incomplete due to error JBO-27021: Failed to load custom data type value at index 1 with java object of type oracle.jbo.domain.Number due to java.sql.SQLException..
The server log shows a stuck thread in the export as below -
WatchData: MESSAGE = [STUCK] ExecuteThread: '18' for queue: 'weblogic.kernel.Default (self-tuning)' has been busy for "622" seconds working on the request "Http Request Information: weblogic.servlet.internal.ServletRequestImpl@1f493ee6[POST /tmcadfv01/faces/tacore/lease/LeasePaymentSearch.jsf]
", which is more than the configured time (StuckThreadMaxTime) of "600" seconds in "server-failure-trigger". Stack trace:
java.lang.String.intern(Native Method)
oracle.jbo.uicli.binding.JUCtrlListBinding$JUCtrlListBindingItemRef.get(JUCtrlListBinding.java:4820)
oracle.adfinternal.view.faces.model.binding.FacesCtrlListBinding$1.get(FacesCtrlListBinding.java:607)
java.util.AbstractList$Itr.next(AbstractList.java:358)
oracle.adfinternal.view.faces.renderkit.rich.SelectItemUtils.addSelectItems(SelectItemUtils.java:209)
oracle.adfinternal.view.faces.renderkit.rich.SelectItemUtils.getSelectItems(SelectItemUtils.java:78)
oracle.adfinternal.view.faces.export.CollectionExportDirector$FlattenedExporterRenderer.renderSelectOne(CollectionExportDirector.java:1109)
oracle.adfinternal.view.faces.export.CollectionExportDirector$FlattenedExporterRenderer.processComponent(CollectionExportDirector.java:1036)
oracle.adfinternal.view.faces.export.CollectionExportDirector$FlattenedExporterRenderer.processComponent(CollectionExportDirector.java:922)
org.apache.myfaces.trinidad.component.UIXComponent.processFlattenedChildren(UIXComponent.java:198)
org.apache.myfaces.trinidad.component.UIXComponent.processFlattenedChildren(UIXComponent.java:330)
org.apache.myfaces.trinidad.component.UIXComponent.processFlattenedChildren(UIXComponent.java:249)
oracle.adfinternal.view.faces.export.CollectionExportDirector$5.processComponent(CollectionExportDirector.java:810)
oracle.adfinternal.view.faces.export.CollectionExportDirector$5.processComponent(CollectionExportDirector.java:782)
org.apache.myfaces.trinidad.component.UIXComponent.processFlattenedChildren(UIXComponent.java:198)
org.apache.myfaces.trinidad.component.UIXComponent.processFlattenedChildren(UIXComponent.java:330)
org.apache.myfaces.trinidad.component.UIXComponent.processFlattenedChildren(UIXComponent.java:249)
oracle.adfinternal.view.faces.export.CollectionExportDirector._renderDataRow(CollectionExportDirector.java:781)
oracle.adfinternal.view.faces.export.CollectionExportDirector._renderAllDataRows(CollectionExportDirector.java:670)
oracle.adfinternal.view.faces.export.CollectionExportDirector._renderDataRows(CollectionExportDirector.java:603)
oracle.adfinternal.view.faces.export.CollectionExportDirector._renderContent(CollectionExportDirector.java:140)
oracle.adfinternal.view.faces.export.CollectionExportDirector.export(CollectionExportDirector.java:120)
oracle.adfinternal.view.faces.export.ExportCollectionActionListener.processAction(ExportCollectionActionListener.java:207)
javax.faces.event.ActionEvent.processListener(ActionEvent.java:88)
org.apache.myfaces.trinidad.component.UIXComponentBase.broadcast(UIXComponentBase.java:1126)
org.apache.myfaces.trinidad.component.UIXCommand.broadcast(UIXCommand.java:179)
org.apache.myfaces.trinidad.component.UIXComponent.broadcastInContext(UIXComponent.java:364)
org.apache.myfaces.trinidad.component.WrapperEvent.broadcastWrappedEvent(WrapperEvent.java:82)
oracle.adf.view.rich.component.fragment.ContextSwitchingComponent$1.run(ContextSwitchingComponent.java:168)
oracle.adf.view.rich.component.fragment.ContextSwitchingComponent._processPhase(ContextSwitchingComponent.java:510)
oracle.adf.view.rich.component.fragment.ContextSwitchingComponent.broadcast(ContextSwitchingComponent.java:171)
org.apache.myfaces.trinidad.component.UIXComponent.broadcastInContext(UIXComponent.java:364)
org.apache.myfaces.trinidad.component.WrapperEvent.broadcastWrappedEvent(WrapperEvent.java:82)
oracle.adf.view.rich.component.fragment.UIXInclude.broadcast(UIXInclude.java:111)
org.apache.myfaces.trinidad.component.UIXComponent.broadcastInContext(UIXComponent.java:364)
org.apache.myfaces.trinidad.component.WrapperEvent.broadcastWrappedEvent(WrapperEvent.java:82)
oracle.adf.view.rich.component.fragment.ContextSwitchingComponent$1.run(ContextSwitchingComponent.java:168)
oracle.adf.view.rich.component.fragment.ContextSwitchingComponent._processPhase(ContextSwitchingComponent.java:510)
oracle.adf.view.rich.component.fragment.ContextSwitchingComponent.broadcast(ContextSwitchingComponent.java:171)
oracle.adf.view.rich.component.fragment.UIXInclude.broadcast(UIXInclude.java:115)
javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:790)
javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:1282)
oracle.adfinternal.view.faces.lifecycle.LifecycleImpl._invokeApplication(LifecycleImpl.java:1207)
oracle.adfinternal.view.faces.lifecycle.LifecycleImpl._executeInvokeApplication(LifecycleImpl.java:607)
oracle.adfinternal.view.faces.lifecycle.LifecycleImpl._executePhase(LifecycleImpl.java:348)
oracle.adfinternal.view.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:224)
javax.faces.webapp.FacesServlet.service(FacesServlet.java:650)
weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:286)
weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:260)
weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:137)
weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:350)
weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:25)
weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78)
nl.amis.metrics.adf.MetricsFilter.doFilter(MetricsFilter.java:65)
weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78)
tmca.oracle.apps.analytics.view.filters.SessionExpiryFilter.doFilter(SessionExpiryFilter.java:66)
weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78)
oracle.adf.model.servlet.ADFBindingFilter.doFilter(ADFBindingFilter.java:194)
weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78)
oracle.adfinternal.view.faces.webapp.rich.RegistrationFilter.doFilter(RegistrationFilter.java:105)
org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl$FilterListChain.doFilter(TrinidadFilterImpl.java:529)
oracle.adfinternal.view.faces.activedata.AdsFilter.doFilter(AdsFilter.java:60)
org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl$FilterListChain.doFilter(TrinidadFilterImpl.java:529)
org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl._doFilterImpl(TrinidadFilterImpl.java:354)
org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl.doFilter(TrinidadFilterImpl.java:232)
org.apache.myfaces.trinidad.webapp.TrinidadFilter.doFilter(TrinidadFilter.java:92)
weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78)
tmca.oracle.apps.analytics.view.filters.AltaFilter.doFilter(AltaFilter.java:55)
weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78)
oracle.adf.library.webapp.LibraryFilter.doFilter(LibraryFilter.java:166)
weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78)
oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:141)
java.security.AccessController.doPrivileged(Native Method)
oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:315)
oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:649)
oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:124)
oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:232)
oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:94)
weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78)
oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:224)
weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78)
weblogic.servlet.internal.RequestEventsFilter.doFilter(RequestEventsFilter.java:32)
weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78)
weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3654)
weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3620)
weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:326)
weblogic.security.service.SecurityManager.runAsForUserCode(SecurityManager.java:196)
weblogic.servlet.provider.WlsSecurityProvider.runAsForUserCode(WlsSecurityProvider.java:203)
weblogic.servlet.provider.WlsSubjectHandle.run(WlsSubjectHandle.java:71)
weblogic.servlet.internal.WebAppServletContext.doSecuredExecute(WebAppServletContext.java:2423)
weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2280)
weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2258)
weblogic.servlet.internal.ServletRequestImpl.runInternal(ServletRequestImpl.java:1626)
weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1586)
weblogic.servlet.provider.ContainerSupportProviderImpl$WlsRequestExecutor.run(ContainerSupportProviderImpl.java:270)
weblogic.invocation.ComponentInvocationContextManager._runAs(ComponentInvocationContextManager.java:348)
weblogic.invocation.ComponentInvocationContextManager.runAs(ComponentInvocationContextManager.java:333)
weblogic.work.LivePartitionUtility.doRunWorkUnderContext(LivePartitionUtility.java:54)
weblogic.work.PartitionUtility.runWorkUnderContext(PartitionUtility.java:41)
weblogic.work.SelfTuningWorkManagerImpl.runWorkUnderContext(SelfTuningWorkManagerImpl.java:617)
weblogic.work.ExecuteThread.execute(ExecuteThread.java:397)
weblogic.work.ExecuteThread.run(ExecuteThread.java:346)
SUPP_ATTRS = {severity-value=8, rid=0, partition-id=0, partition-name=DOMAIN} SERVER = app_server4 TIMESTAMP = 1594996578547 USERID = <WLS Kernel> MACHINE = ip-10-0-6-121 MSGID = BEA-000337 DATE = Jul 17, 2020 10:36:18:547 AM EDT SUBSYSTEM = WebLogicServer CONTEXTID = 49899f6a-2654-40b3-a253-d6d2e8090b55-0000ee9d TXID = SEVERITY = Error THREAD = [ACTIVE] ExecuteThread: '9' for queue: 'weblogic.kernel.Default (self-tuning)'
WatchAlarmType: AutomaticReset
WatchAlarmResetPeriod: 600000
>