Skip to Main Content

ORDS, SODA & JSON in the Database

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Exception in ORDS when submit large array using owa_util.ident_arr

eaespinoza0Oct 13 2017

Hi all

I'm migrating an old mod_plsql application running on Database 12c to use ORDS 3.0.10 running on Apache Tomcat 7.0.78 with JDK 1.8.0_131 and one use case is a form with about 15,000 inputs gets submitted to be passed into a procedure with a variable of type owa_util.ident_arr with smaller data sets it works fine. Below is the stack trace I'm getting from the logs, any ideas if this is a memory issue and if I need in some way increase the memory available to ORDS? or is it a limitation on the size of the array that ORDS can handle to port to the database?

SEVERE: java.sql.SQLRecoverableException: internal error

InternalServerException [statusCode=500, reasons=[]]

        at oracle.dbtools.apex.ModApexContext.handleError(ModApexContext.java:273)

        at oracle.dbtools.apex.OWA.execute(OWA.java:212)

        at oracle.dbtools.apex.ModApex.handleRequest(ModApex.java:266)

        at oracle.dbtools.apex.ModApex.doPost(ModApex.java:174)

        at oracle.dbtools.apex.ModApex.service(ModApex.java:102)

        at oracle.dbtools.http.entrypoint.Dispatcher.dispatch(Dispatcher.java:125)

        at oracle.dbtools.http.entrypoint.EntryPoint$FilteredServlet.service(EntryPoint.java:240)

        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:66)

        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:87)

        at oracle.dbtools.http.auth.AuthenticationFilter.doFilter(AuthenticationFilter.java:62)

        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:125)

        at oracle.dbtools.url.mapping.URLMappingBase.doFilter(URLMappingBase.java:103)

        at oracle.dbtools.url.mapping.filter.URLMappingFilter.doFilter(URLMappingFilter.java:124)

        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:83)

        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:94)

SEVERE: java.sql.SQLRecoverableException: internal error

InternalServerException [statusCode=500, reasons=[]]

        at oracle.dbtools.apex.ModApexContext.handleError(ModApexContext.java:273)

        at oracle.dbtools.apex.OWA.execute(OWA.java:212)

        at oracle.dbtools.apex.ModApex.handleRequest(ModApex.java:266)

        at oracle.dbtools.apex.ModApex.doPost(ModApex.java:174)

        at oracle.dbtools.apex.ModApex.service(ModApex.java:102)

        at oracle.dbtools.http.entrypoint.Dispatcher.dispatch(Dispatcher.java:125)

        at oracle.dbtools.http.entrypoint.EntryPoint$FilteredServlet.service(EntryPoint.java:240)

        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:66)

        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:87)

        at oracle.dbtools.http.auth.AuthenticationFilter.doFilter(AuthenticationFilter.java:62)

        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:125)

        at oracle.dbtools.url.mapping.URLMappingBase.doFilter(URLMappingBase.java:103)

        at oracle.dbtools.url.mapping.filter.URLMappingFilter.doFilter(URLMappingFilter.java:124)

        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:83)

        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:94)

        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:47)

        at oracle.dbtools.http.entrypoint.EntryPoint.service(EntryPoint.java:82)

        at oracle.dbtools.http.entrypoint.EntryPointServlet.service(EntryPointServlet.java:49)

        at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)

        at oracle.dbtools.rt.web.HttpEndpointBase.dispatchableServices(HttpEndpointBase.java:116)

        at oracle.dbtools.rt.web.HttpEndpointBase.service(HttpEndpointBase.java:81)

        at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)

        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)

        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

        at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)

        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)

        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:218)

        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110)

        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:506)

        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)

        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)

        at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:962)

        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)

        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:445)

        at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1115)

        at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637)

        at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:318)

        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)

        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)

        at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)

        at java.lang.Thread.run(Thread.java:748)

Caused by: java.sql.SQLRecoverableException: internal error

        at oracle.jdbc.driver.OraclePreparedStatement.setupDbaBindBuffers(OraclePreparedStatement.java:3697)

        at oracle.jdbc.driver.OraclePreparedStatement.setupBindBuffers(OraclePreparedStatement.java:3046)

        at oracle.jdbc.driver.OraclePreparedStatement.processCompletedBindRow(OraclePreparedStatement.java:2670)

        at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:4794)

        at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:4905)

        at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:5631)

        at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1385)

        at sun.reflect.GeneratedMethodAccessor32.invoke(Unknown Source)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

        at java.lang.reflect.Method.invoke(Method.java:498)

        at oracle.ucp.jdbc.proxy.StatementProxyFactory.invoke(StatementProxyFactory.java:353)

        at oracle.ucp.jdbc.proxy.PreparedStatementProxyFactory.invoke(PreparedStatementProxyFactory.java:178)

        at oracle.ucp.jdbc.proxy.CallableStatementProxyFactory.invoke(CallableStatementProxyFactory.java:136)

        at com.sun.proxy.$Proxy47.execute(Unknown Source)

        at oracle.dbtools.apex.OWA.execute(OWA.java:175)

        ... 63 more

Caused by: java.lang.NullPointerException

        at java.lang.System.arraycopy(Native Method)

        at java.lang.String.getChars(String.java:826)

        at oracle.jdbc.driver.PlsqlIbtBinder.bind(OraclePreparedStatement.java:25646)

        at oracle.jdbc.driver.OraclePreparedStatement.setupDbaBindBuffers(OraclePreparedStatement.java:3597)

        ... 77 more

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Nov 10 2017
Added on Oct 13 2017
0 comments
352 views