Hi all.
An error occurs when running a report on a large amount of data. Tell me where to increase the parameters so that such reports work?
If there is not a lot of data, then the report works without errors.
in the file: C:\Oracle\Middleware\Oracle_Home\user_projects\domains\base_domain\servers\WLS_REPORTS\logs\reports\rwservlet_diagnostic.log - found
[2025-03-03T15:49:00.578+02:00] [WLS_REPORTS] [INCIDENT_ERROR] [REP-1800] [oracle.reports.servlet] [tid: 33] [userId: <anonymous>] [ecid: 00jZWQYlhDYFw0zoNP03rz36kEE1jf2xF00028C00000V,0:1:100000000] [APP: reports#14.1.2] REP-1800 : A formatter error occurred.[[
VGS-1701: Not enough memory.
oracle.reports.RWException: IDL:oracle/reports/RWException:1.0
at oracle.reports.RWExceptionHelper.read(RWExceptionHelper.java:67)
at oracle.reports.server._ConnectionStub.runJob(_ConnectionStub.java:587)
at oracle.reports.client.ReportRunner.dispatchReport(ReportRunner.java:320)
at oracle.reports.rwclient.RWReportRunner.dispatchReport(RWReportRunner.java:86)
at oracle.reports.rwclient.RWClient.runReport(RWClient.java:2222)
at oracle.reports.rwclient.RWClient.processRequest(RWClient.java:2067)
at oracle.reports.rwclient.RWClient.doGet(RWClient.java:521)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:645)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:750)
at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:295)
at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:260)
at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:137)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:353)
at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:25)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:87)
at oracle.security.jps.ee.http.JpsAbsFilter$3.run(JpsAbsFilter.java:175)
at java.base/java.security.AccessController.doPrivileged(AccessController.java:714)
at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:314)
at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:650)
at oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:112)
at oracle.security.jps.ee.http.JpsAbsFilter.doFilterInternal(JpsAbsFilter.java:293)
at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:150)
at oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:94)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:87)
at oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:248)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:87)
at oracle.jrf.servlet.ExtensibleGlobalFilter.doFilter(ExtensibleGlobalFilter.java:92)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:87)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3895)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3855)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:344)
at weblogic.security.service.SecurityManager.runAsForUserCode(SecurityManager.java:198)
at weblogic.servlet.provider.WlsSecurityProvider.runAsForUserCode(WlsSecurityProvider.java:203)
at weblogic.servlet.provider.WlsSubjectHandle.run(WlsSubjectHandle.java:71)
at weblogic.servlet.internal.WebAppServletContext.processSecuredExecute(WebAppServletContext.java:2522)
at weblogic.servlet.internal.WebAppServletContext.doSecuredExecute(WebAppServletContext.java:2371)
at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2346)
at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2324)
at weblogic.servlet.internal.ServletRequestImpl.runInternal(ServletRequestImpl.java:1837)
at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1783)
at weblogic.servlet.provider.ContainerSupportProviderImpl$WlsRequestExecutor.run(ContainerSupportProviderImpl.java:287)
at weblogic.invocation.ComponentInvocationContextManager._runAs(ComponentInvocationContextManager.java:352)
at weblogic.invocation.ComponentInvocationContextManager.runAs(ComponentInvocationContextManager.java:337)
at weblogic.work.LivePartitionUtility.doRunWorkUnderContext(LivePartitionUtility.java:60)
at weblogic.work.PartitionUtility.runWorkUnderContext(PartitionUtility.java:41)
at weblogic.work.SelfTuningWorkManagerImpl.runWorkUnderContext(SelfTuningWorkManagerImpl.java:695)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:430)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:370)
]]
as I suspected, it seems like he doesn’t have enough memory to run the report, but the question is where to change the parameter to solve this problem?