function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
JasonRogersJasonRogers 

error updating account objects

While trying to change a single field in an account and calling update I get the following stack trace. Any clues?

java.lang.RuntimeException: java.lang.Exception: Error saving object: java.io.IOException: ORA-22922: nonexistent LOB value

at oracle.jdbc.driver.DatabaseError.SQLToIOException(DatabaseError.java:557)
at oracle.jdbc.driver.OracleClobWriter.flushBuffer(OracleClobWriter.java:215)
at oracle.jdbc.driver.OracleClobWriter.close(OracleClobWriter.java:188)
at common.udd.object.ClobField.postDbSave(ClobField.java:128)
at common.udd.object.EntityObject.postSave(EntityObject.java:1222)
at common.udd.object.EntityObject.bulkSave(EntityObject.java:1404)
at common.udd.object.ApiEntityObject.apiBulkSave(ApiEntityObject.java:1046)
at common.api.soap.Soap.save(Soap.java:271)
at common.api.soap.Soap.update(Soap.java:221)
at sun.reflect.GeneratedMethodAccessor203.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at org.apache.axis.providers.java.RPCProvider.invokeMethod(RPCProvider.java:402)
at org.apache.axis.providers.java.RPCProvider.processMessage(RPCProvider.java:309)
at common.api.soap.SProvider.processMessage(SProvider.java:81)
at org.apache.axis.providers.java.JavaProvider.invoke(JavaProvider.java:333)
at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:71)
at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:150)
at org.apache.axis.SimpleChain.invoke(SimpleChain.java:120)
at org.apache.axis.handlers.soap.SOAPService.invoke(SOAPService.java:481)
at org.apache.axis.server.AxisServer.invoke(AxisServer.java:323)
at org.apache.axis.transport.http.AxisServlet.doPost(AxisServlet.java:854)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:165)
at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:339)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:103)
at com.caucho.server.dispatch.ServletFilterChain.doFilter(ServletFilterChain.java:113)
at shared.filter.SoapPostGzipFilter.doFilter(SoapPostGzipFilter.java:25)
at com.caucho.server.dispatch.FilterFilterChain.doFilter(FilterFilterChain.java:84)
at com.caucho.filters.GzipFilter.doFilter(GzipFilter.java:176)
at com.caucho.server.dispatch.FilterFilterChain.doFilter(FilterFilterChain.java:84)
at system.filter.SoapPreGzipFilter.doFilter(SoapPreGzipFilter.java:46)
at com.caucho.server.dispatch.FilterFilterChain.doFilter(FilterFilterChain.java:84)
at system.filter.PreGzipFilter.doFilter(PreGzipFilter.java:75)
at com.caucho.server.dispatch.FilterFilterChain.doFilter(FilterFilterChain.java:84)
at com.caucho.server.cache.CacheFilterChain.doFilter(CacheFilterChain.java:190)
at com.caucho.server.webapp.WebAppFilterChain.doFilter(WebAppFilterChain.java:177)
at com.caucho.server.dispatch.ServletInvocation.service(ServletInvocation.java:221)
at com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:263)
at com.caucho.server.port.TcpConnection.run(TcpConnection.java:323)
at com.caucho.util.ThreadPool.runTasks(ThreadPool.java:430)
at com.caucho.util.ThreadPool.run(ThreadPool.java:377)
at java.lang.Thread.run(Thread.java:534)
DevAngelDevAngel

Hi Jason,

Can you provide more information about the what you are updating?  Providing the actual soap message would be optimal.

JasonRogersJasonRogers
Unfortunately, no. I haven't been able to reproduce it again. Strangely, the updates to the accounts worked. This stack trace was obtained from the Error[] of a SaveResult[].

If it happens again I will send along the SOAP message.