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!

Import application - 500 server error (4.2.4)

Scott WesleyJan 2 2014

Amazon Windows ec2 instance

GlassFish Server 3.1.2

APEX Listener  2.0.4.259.08.59

APEX 4.2.4

I'm attempting to import an application I exported from my local 4.2.3 instance, and received 500-Internal server error after I select schema and app_id.

The server.log file errors include

[#|2014-01-03T04:25:03.855+0000|SEVERE|glassfish3.1.2|null|_ThreadID=34;_ThreadName=Thread-2;|    

java.sql.SQLRecoverableException: No more data to read from socket

  at oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1157)

  at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:345)

  at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:223)

  at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)

  at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:205)

  at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:1043)

  at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1336)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  at oracle.dbtools.rt.web.HttpEndpointBase.modApex(HttpEndpointBase.java:350)

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

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

  at org.apache.catalina.core.StandardWrapper.service(StandardWrapper.java:1550)

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

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

  at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:655)

  at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:595)

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

  at org.apache.catalina.connector.CoyoteAdapter.doService(CoyoteAdapter.java:331)

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

  at com.sun.enterprise.v3.services.impl.ContainerMapper$AdapterCallable.call(ContainerMapper.java:317)

  at com.sun.enterprise.v3.services.impl.ContainerMapper.service(ContainerMapper.java:195)

  at com.sun.grizzly.http.ProcessorTask.invokeAdapter(ProcessorTask.java:860)

  at com.sun.grizzly.http.ProcessorTask.doProcess(ProcessorTask.java:757)

  at com.sun.grizzly.http.ProcessorTask.process(ProcessorTask.java:1056)

  at com.sun.grizzly.http.DefaultProtocolFilter.execute(DefaultProtocolFilter.java:229)

  at com.sun.grizzly.DefaultProtocolChain.executeProtocolFilter(DefaultProtocolChain.java:137)

  at com.sun.grizzly.DefaultProtocolChain.execute(DefaultProtocolChain.java:104)

  at com.sun.grizzly.DefaultProtocolChain.execute(DefaultProtocolChain.java:90)

  at com.sun.grizzly.http.HttpProtocolChain.execute(HttpProtocolChain.java:79)

  at com.sun.grizzly.ProtocolChainContextTask.doCall(ProtocolChainContextTask.java:54)

  at com.sun.grizzly.SelectionKeyContextTask.call(SelectionKeyContextTask.java:59)

  at com.sun.grizzly.ContextTask.run(ContextTask.java:71)

  at com.sun.grizzly.util.AbstractThreadPool$Worker.doWork(AbstractThreadPool.java:532)

  at com.sun.grizzly.util.AbstractThreadPool$Worker.run(AbstractThreadPool.java:513)

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

|#]

[#|2014-01-03T04:25:03.855+0000|SEVERE|glassfish3.1.2|null|_ThreadID=34;_ThreadName=Thread-2;|No more data to read from socket

java.sql.SQLRecoverableException: No more data to read from socket

  at oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1157)

  at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:345)

  at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:223)

  at oracle.jdbc.driver.T4C7Ocommoncall.doOCOMMIT(T4C7Ocommoncall.java:75)

  at oracle.jdbc.driver.T4CConnection.doCommit(T4CConnection.java:634)

  at oracle.jdbc.driver.PhysicalConnection.commit(PhysicalConnection.java:3913)

  at oracle.jdbc.driver.PhysicalConnection.commit(PhysicalConnection.java:3919)

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

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

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

  at oracle.ucp.jdbc.proxy.JDBCConnectionProxyFactory.invoke(JDBCConnectionProxyFactory.java:274)

  at com.sun.proxy.$Proxy132.commit(Unknown Source)

  at oracle.dbtools.apex.ModApexContext.closeConnection(ModApexContext.java:299)

  at oracle.dbtools.apex.ModApexContext.close(ModApexContext.java:323)

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

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

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

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

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

  at oracle.dbtools.rt.web.HttpEndpointBase.modApex(HttpEndpointBase.java:350)

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

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

  at org.apache.catalina.core.StandardWrapper.service(StandardWrapper.java:1550)

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

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

  at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:655)

  at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:595)

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

  at org.apache.catalina.connector.CoyoteAdapter.doService(CoyoteAdapter.java:331)

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

  at com.sun.enterprise.v3.services.impl.ContainerMapper$AdapterCallable.call(ContainerMapper.java:317)

  at com.sun.enterprise.v3.services.impl.ContainerMapper.service(ContainerMapper.java:195)

  at com.sun.grizzly.http.ProcessorTask.invokeAdapter(ProcessorTask.java:860)

  at com.sun.grizzly.http.ProcessorTask.doProcess(ProcessorTask.java:757)

  at com.sun.grizzly.http.ProcessorTask.process(ProcessorTask.java:1056)

  at com.sun.grizzly.http.DefaultProtocolFilter.execute(DefaultProtocolFilter.java:229)

  at com.sun.grizzly.DefaultProtocolChain.executeProtocolFilter(DefaultProtocolChain.java:137)

  at com.sun.grizzly.DefaultProtocolChain.execute(DefaultProtocolChain.java:104)

  at com.sun.grizzly.DefaultProtocolChain.execute(DefaultProtocolChain.java:90)

  at com.sun.grizzly.http.HttpProtocolChain.execute(HttpProtocolChain.java:79)

  at com.sun.grizzly.ProtocolChainContextTask.doCall(ProtocolChainContextTask.java:54)

  at com.sun.grizzly.SelectionKeyContextTask.call(SelectionKeyContextTask.java:59)

  at com.sun.grizzly.ContextTask.run(ContextTask.java:71)

  at com.sun.grizzly.util.AbstractThreadPool$Worker.doWork(AbstractThreadPool.java:532)

  at com.sun.grizzly.util.AbstractThreadPool$Worker.run(AbstractThreadPool.java:513)

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

|#]

The export file is 2.5mb,  I've successfully imported a 0.5mb file.

I'm not sure how to continue debugging this, but I'm free to upgrade the listener if necessary.

Cheers

Comments

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

Post Details

Locked on Jan 30 2014
Added on Jan 2 2014
0 comments
1,194 views