Skip to Main Content

Internal server error when trying to export from interactive grid

3827077Apr 14 2021

We are getting Internal server error when trying to export from interactive grid (any). The logs are saying java.sql.SQLException: ORA-22922: nonexistent LOB value. We are on APEX 20.2, ORDS 19.2 and tomcat 9.0.10.
We have googled, analyzed log files (db and tomcat) without any luck.
Does anybody recognize this issue?
Dump from catalina.log

14-Apr-2021 09:55:18.070 SEVERE [http-nio-8085-exec-10] . java.sql.SQLException: ORA-22922: nonexistent LOB value

    InternalServerException \[statusCode=500, reasons=\[\]\]
            at oracle.dbtools.apex.ModApexContext.handleError(ModApexContext.java:288)
            at oracle.dbtools.apex.OWA.downloadFile(OWA.java:103)
            at oracle.dbtools.apex.hooks.postProcess.FileDownload.postProcess(FileDownload.java:12)
            at oracle.dbtools.apex.hooks.ProcessorRegistry.postProcess(ProcessorRegistry.java:55)
            at oracle.dbtools.apex.ModApex.handleRequest(ModApex.java:336)
            at oracle.dbtools.apex.ModApex.doGet(ModApex.java:147)
            at oracle.dbtools.apex.ModApex.service(ModApex.java:110)
            at oracle.dbtools.http.entrypoint.Dispatcher.dispatch(Dispatcher.java:143)
            at oracle.dbtools.http.entrypoint.EntryPoint$FilteredServlet.service(EntryPoint.java:243)
            at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl.java:73)
            at oracle.dbtools.http.forwarding.QueryFilteringRewrite.doFilter(QueryFilteringRewrite.java:90)
            at oracle.dbtools.http.filters.HttpFilter.doFilter(HttpFilter.java:47)
            at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl.java:64)
            at oracle.dbtools.http.forwarding.ForwardingFilter.doFilter(ForwardingFilter.java:68)
            at oracle.dbtools.http.filters.HttpFilter.doFilter(HttpFilter.java:47)
            at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl.java:64)
            at oracle.dbtools.http.cors.CORSPreflightFilter.doFilter(CORSPreflightFilter.java:68)
            at oracle.dbtools.http.filters.HttpFilter.doFilter(HttpFilter.java:47)
            at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl.java:64)
            at oracle.dbtools.http.cookies.auth.CookieSessionCSRFFilter.doFilter(CookieSessionCSRFFilter.java:75)
            at oracle.dbtools.http.filters.HttpFilter.doFilter(HttpFilter.java:47)
            at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl.java:64)
            at oracle.dbtools.http.auth.AuthenticationFilter.authenticate(AuthenticationFilter.java:101)
            at oracle.dbtools.http.auth.AuthenticationFilter.doFilter(AuthenticationFilter.java:64)
            at oracle.dbtools.http.filters.HttpFilter.doFilter(HttpFilter.java:47)
            at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl.java:64)
            at oracle.dbtools.url.mapping.RequestMapperImpl.doFilter(RequestMapperImpl.java:160)
            at oracle.dbtools.url.mapping.URLMappingBase.doFilter(URLMappingBase.java:95)
            at oracle.dbtools.url.mapping.filter.URLMappingFilter.doFilter(URLMappingFilter.java:130)
            at oracle.dbtools.http.filters.HttpFilter.doFilter(HttpFilter.java:47)
            at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl.java:64)
            at oracle.dbtools.http.auth.external.ExternalSessionFilter.doFilter(ExternalSessionFilter.java:59)
            at oracle.dbtools.http.filters.HttpFilter.doFilter(HttpFilter.java:47)
            at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl.java:64)
            at oracle.dbtools.rt.authentication.apex.ApexSessionQueryRewriteFilter.doFilter(ApexSessionQueryRewriteFilter.java:58)
            at oracle.dbtools.http.filters.HttpFilter.doFilter(HttpFilter.java:47)
            at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl.java:64)
            at oracle.dbtools.http.cors.CORSResponseFilter.doFilter(CORSResponseFilter.java:88)
            at oracle.dbtools.http.filters.HttpResponseFilter.doFilter(HttpResponseFilter.java:45)
            at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl.java:64)
            at oracle.dbtools.http.filters.AbsoluteLocationFilter.doFilter(AbsoluteLocationFilter.java:65)
            at oracle.dbtools.http.filters.HttpResponseFilter.doFilter(HttpResponseFilter.java:45)
            at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl.java:64)
            at oracle.dbtools.http.errors.ErrorPageFilter.doFilter(ErrorPageFilter.java:85)
            at oracle.dbtools.http.filters.HttpFilter.doFilter(HttpFilter.java:47)
            at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl.java:64)
            at oracle.dbtools.http.secure.ForceHttpsFilter.doFilter(ForceHttpsFilter.java:74)
            at oracle.dbtools.http.filters.HttpFilter.doFilter(HttpFilter.java:47)
            at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl.java:64)
            at oracle.dbtools.http.auth.ForceAuthFilter.doFilter(ForceAuthFilter.java:44)
            at oracle.dbtools.http.filters.HttpFilter.doFilter(HttpFilter.java:47)
            at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl.java:64)
            at oracle.dbtools.http.filters.Filters.filter(Filters.java:67)
            at oracle.dbtools.http.entrypoint.EntryPoint.service(EntryPoint.java:82)
            at oracle.dbtools.http.entrypoint.EntryPointServlet.service(EntryPointServlet.java:102)
            at oracle.dbtools.entrypoint.WebApplicationRequestEntryPoint.service(WebApplicationRequestEntryPoint.java:50)
            at javax.servlet.http.HttpServlet.service(HttpServlet.java:733)
            at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
            at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
            at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
            at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
            at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
            at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202)
            at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
            at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541)
            at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)
            at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
            at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:690)
            at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
            at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
            at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:373)
            at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
            at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:868)
            at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1589)
            at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
            at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
            at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
            at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
            at java.lang.Thread.run(Thread.java:748)
    Caused by: java.sql.SQLException: ORA-22922: nonexistent LOB value
Comments
Post Details
Added on Apr 14 2021
5 comments
114 views