An error just started occurring at 2:30 today with something that has been working for awhile. I am stumped because it is actually loading the opportunity but returning an error.
API 2.5, C# if ( saveResults[0].success ) { 'continue with code } else { 'throw error (i am getting here which means i didn't have a success.) }
UNKNOWN_EXCEPTION java.lang.ClassCastException at sales.opportunity.OpportunityObject.executeOpportunityAlertInternal(OpportunityObject.java:314) at sales.opportunity.OpportunityObject.saveHook_PostCommit(OpportunityObjec t.java:261) at common.udd.object.EntityObject.save(EntityObject.java:1040) at common.udd.object.ApiEntityObject.apiSave(ApiEntityObject.java:933) at common.udd.object.EntityObject.apiSave(EntityObject.java:1694) at common.api.soap.Soap.save(Soap.java:276) at common.api.soap.Soap.create(Soap.java:225) at sun.reflect.GeneratedMethodAccessor139.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor Impl.java:25) at java.lang.reflect.Method.invoke(Method.java:324) at org.apache.axis.providers.java.RPCProvider.invokeMethod(RPCProvider.java402) at org.apache.axis.providers.java.RPCProvider.processMessage(RPCProvider.ja va: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.j ava: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.j ava:339) at javax.servlet.http.HttpServlet.service(HttpServlet.java:103) at com.caucho.server.http.FilterChainServlet.doFilter(FilterChainServlet.ja va:96) at shared.filter.SoapPostGzipFilter.doFilter(SoapPostGzipFilter.java:25) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java88) at com.caucho.http.filter.GzipFilter.doFilter(GzipFilter.java:137) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java88) at shared.filter.SoapPreGzipFilter.doFilter(SoapPreGzipFilter.java:33) at com.caucho.server.http.FilterChainFilter.doFilter(FilterChainFilter.java88) at com.caucho.server.http.Invocation.service(Invocation.java:315) at com.caucho.server.http.CacheInvocation.service(CacheInvocation.java:135) at com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:246) at com.caucho.server.http.HttpRequest.handleConnection(HttpRequest.java:164 ) at com.caucho.server.TcpConnection.run(TcpConnection.java:139) at java.lang.Thread.run(Thread.java:534)
Ok, here is the problem I'm having. I run the following query on Account table:
select Name, Id from Account where Name='O'Neill, Eric 19046894'
Am guessing that the problem arises because of the single quote after O. I just wonder how you guys dealt with this problem... The number is an ID from my DB.
