Jivespace : Popular Threads - Developers

Need help with userUpdate REST API

matt.baylor@fotf.org — Thu, 12 Nov 2009 15:54:15 GMT

Hi All,

I'm trying to use the REST API to update the user's first name and last name. I've tried both the PUT and POST http methods and I'm getting different errors with each. If you could just hive me some pointers as to what I'm missing that would be most helpful! THanks!

Here's the POST method error:

<ns1:XMLFault xmlns:ns1="http://cxf.apache.org/bindings/xformat"><ns1:faultstring xmlns:ns1="http://cxf.apache.org/bindings/xformat">java.lang.RuntimeException: Failed to create application user User: -2 [null] [null] </ns1:faultstring></ns1:XMLFault>

Here's the code (PHP) for the PUT method:

private function updateUser($fname,$lname,$uid) {
        $credentials = $this->jiveSystemUser . ":" . $this->jiveSystemPass; 
        $payload = '<updateUser>
                        <user>
                               <ID>' . $uid . '</ID>
                            <firstName>' . $fname . '</firstName>
                            <lastName>' . $lname . '</lastName>
                        </user>
                    </updateUser>';
         
        $url = "https://" . $this->jiveSystemURL . "/rpc/rest/userService/users";
        $page = "/rpc/rest/userService/users";
        $headers = array(
            "POST ".$page." HTTP/1.0",
            "Content-type: text/xml;charset=\"utf-8\"",
            "Accept: text/xml",
            "Cache-Control: no-cache",
            "Pragma: no-cache",
            "SOAPAction: \"run\"",
            "Content-length: ".strlen($payload),
            "Authorization: Basic " . base64_encode($credentials)
        );
    
        $ch = curl_init();
        curl_setopt($ch, CURLOPT_URL,$url);
        curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
        curl_setopt($ch, CURLOPT_TIMEOUT, 60);
           curl_setopt($ch, CURLOPT_HTTPHEADER, $headers);
        curl_setopt($ch, CURLOPT_POST, 1);
        curl_setopt($ch, CURLOPT_POSTFIELDS, $payload);
 
    
        $response = curl_exec($ch);
    
        if (curl_errno($ch)) {
            print "Error: " . curl_error($ch);
        } else {
            // Show me the result
            echo "<pre>".htmlspecialchars($response)."</pre>";
        }
    
        curl_close($ch);
    
    }

Here's the error when I use the PUT method:

Request Entity Too Large

The requested resource
/rpc/rest/userService/users
does not allow request data with PUT requests, or the amount of data provided in the request exceeds the capacity limit.

Request Entity Too Large

Your browser sent a request that this server could not understand.

Here's the code (PHP) for the PUT Method:

private function updateUser($fname,$lname,$uid) {
        $credentials = $this->jiveSystemUser . ":" . $this->jiveSystemPass; 
        $payload = '<updateUser>
                        <user>
                               <ID>' . $uid . '</ID>
                            <firstName>' . $fname . '</firstName>
                            <lastName>' . $lname . '</lastName>
                        </user>
                    </updateUser>';
         
        $url = "https://" . $this->jiveSystemURL . "/rpc/rest/userService/users";
        $page = "/rpc/rest/userService/users";
        $headers = array(
            "PUT ".$page." HTTP/1.0",
            "Content-type: text/xml;charset=\"utf-8\"",
            "Accept: text/xml",
            "Cache-Control: no-cache",
            "Pragma: no-cache",
            "SOAPAction: \"run\"",
            "Content-length: ".strlen($payload),
            "Authorization: Basic " . base64_encode($credentials)
        );
        
        /* Prepare the data for HTTP PUT. */
        $putData = tmpfile();
        fwrite($putData, $payload);
        fseek($putData, 0); 
    
        $ch = curl_init();
        curl_setopt($ch, CURLOPT_URL,$url);
        curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
        curl_setopt($ch, CURLOPT_TIMEOUT, 60);
        curl_setopt($ch, CURLOPT_HTTPHEADER, $headers);
        curl_setopt($ch, CURLOPT_PUT, 1);
        curl_setopt($ch, CURLOPT_INFILESIZE, strlen($payload));
        curl_setopt($ch, CURLOPT_INFILE, $putData); 
    
        $response = curl_exec($ch);
        fclose($putData); 
    
        if (curl_errno($ch)) {
            print "Error: " . curl_error($ch);
        } else {
            // Show me the result
            echo "<pre>".htmlspecialchars($response)."</pre>";
        }
    
        curl_close($ch);
    
    }

ERROR impl.QueryCache - Error retrieving count

communities@jivesoftware.com — Sat, 31 Jan 2009 14:00:01 GMT

I am try to better understand why the following errors are showing up in the clearspace.log files often. If you can direct or lead me on how to better diagnose this issues I would appreciate it. I have no idea if this is user related / Clearspace related / Pages related. I also do not know what is going on, but these dumps show up often.

I am most concerned with the following statement:

< 31 Jan 2009 08:34:52,098 [TP-Processor14] ERROR impl.QueryCache - Error retrieving count

< java.sql.SQLException: ORA-00903: invalid table name

The full core dump is below:

91413,91590c91413

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

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

< at com.jivesoftware.util.NoCacheFilter.doFilter(NoCacheFilter.java:66)

< at org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:98)

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

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

< at org.directwebremoting.servlet.DwrWebContextFilter.doFilter(DwrWebContextFilter.java:91)

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

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

< at com.jivesoftware.base.plugin.PluginFilter.doFilter(PluginFilter.java:75)

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

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

< at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:265)

< at com.jivesoftware.community.aaa.JiveAuthenticationTranslationFilter.doFilter(JiveAuthenticationTranslationFilter.java:164)

< at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)

< at org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:124)

< at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)

< at com.jivesoftware.community.aaa.FeedsBasicProcessingFilter.doFilter(FeedsBasicProcessingFilter.java:146)

< at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)

< at org.acegisecurity.ui.rememberme.RememberMeProcessingFilter.doFilter(RememberMeProcessingFilter.java:135)

< at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)

< at org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:271)

< at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)

< at com.jivesoftware.community.aaa.SessionTrackingFilter.doFilter(SessionTrackingFilter.java:53)

< at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)

< at org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:249)

< at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275)

< at org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:149)

< at org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:98)

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

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

< at com.jivesoftware.community.web.filter.ApplicationStateFilter.doFilter(ApplicationStateFilter.java:145)

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

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

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

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

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

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

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

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

< at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190)

< at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:283)

< at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:767)

< at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:697)

< at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:889)

< at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690)

< at java.lang.Thread.run(Unknown Source)

< 31 Jan 2009 08:34:52,098 [TP-Processor14] ERROR impl.QueryCache - Error retrieving count

< java.sql.SQLException: ORA-00903: invalid table name

< at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:124)

< at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:315)

< at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:281)

< at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:638)

< at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:184)

< at oracle.jdbc.driver.T4CPreparedStatement.execute_for_describe(T4CPreparedStatement.java:502)

< at oracle.jdbc.driver.OracleStatement.execute_maybe_describe(OracleStatement.java:964)

< at oracle.jdbc.driver.T4CPreparedStatement.execute_maybe_describe(T4CPreparedStatement.java:534)

< at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1050)

< at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:2983)

< at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3025)

< at sun.reflect.GeneratedMethodAccessor54.invoke(Unknown Source)

< at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

< at java.lang.reflect.Method.invoke(Unknown Source)

< at org.logicalcobwebs.proxool.ProxyStatement.invoke(ProxyStatement.java:100)

< at org.logicalcobwebs.proxool.ProxyStatement.intercept(ProxyStatement.java:57)

< at oracle.jdbc.OracleStatement$$EnhancerByProxool$$a6b52f27.executeQuery(<generated>)

< at com.jivesoftware.community.impl.QueryCache.getCount(QueryCache.java:461)

< at com.jivesoftware.community.impl.DbTagManager.getTaggableContentCount(DbTagManager.java:347)

< at com.jivesoftware.community.proxy.TagManagerProxy.getTaggableContentCount(TagManagerProxy.java:148)

< at com.jivesoftware.community.action.TaggableContentAction.execute(TaggableContentAction.java:65)

< at sun.reflect.GeneratedMethodAccessor986.invoke(Unknown Source)

< at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

< at java.lang.reflect.Method.invoke(Unknown Source)

< at com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:376)

< at com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:239)

< at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:213)

< at com.jivesoftware.community.web.struts.FlashInterceptor.intercept(FlashInterceptor.java:41)

< at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:211)

< at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:88)

< at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:211)

< at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:88)

< at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:211)

< at com.opensymphony.xwork2.interceptor.ConversionErrorInterceptor.intercept(ConversionErrorInterceptor.java:123)

< at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:211)

< at com.jivesoftware.community.web.struts.JiveConversionErrorInterceptor.intercept(JiveConversionErrorInterceptor.java:35)

< at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:211)

< at com.jivesoftware.community.action.LocaleInterceptor.intercept(LocaleInterceptor.java:68)

< at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:211)

< at com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:167)

< at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:86)

< at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:211)

< at com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.intercept(StaticParametersInterceptor.java:105)

< at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:211)

< at org.apache.struts2.interceptor.CheckboxInterceptor.intercept(CheckboxInterceptor.java:83)

< at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:211)

< at org.apache.struts2.interceptor.FileUploadInterceptor.intercept(FileUploadInterceptor.java:207)

< at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:211)

< at com.opensymphony.xwork2.interceptor.ModelDrivenInterceptor.intercept(ModelDrivenInterceptor.java:74)

< at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:211)

< at com.opensymphony.xwork2.interceptor.ScopedModelDrivenInterceptor.intercept(ScopedModelDrivenInterceptor.java:127)

< at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:211)

< at org.apache.struts2.interceptor.debugging.DebuggingInterceptor.intercept(DebuggingInterceptor.java:206)

< at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:211)

< at com.opensymphony.xwork2.interceptor.I18nInterceptor.intercept(I18nInterceptor.java:143)

< at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:211)

< at com.opensymphony.xwork2.interceptor.PrepareInterceptor.doIntercept(PrepareInterceptor.java:121)

< at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:86)

< at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:211)

< at org.apache.struts2.interceptor.ServletConfigInterceptor.intercept(ServletConfigInterceptor.java:170)

< at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:211)

< at com.opensymphony.xwork2.interceptor.AliasInterceptor.intercept(AliasInterceptor.java:123)

< at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:211)

< at com.opensymphony.xwork2.interceptor.ExceptionMappingInterceptor.intercept(ExceptionMappingInterceptor.java:176)

< at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:211)

< at com.jivesoftware.community.web.struts.RequireFeatureInterceptor.intercept(RequireFeatureInterceptor.java:36)

< at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:211)

< at com.jivesoftware.community.web.struts.ModuleCheckInterceptor.intercept(ModuleCheckInterceptor.java:47)

< at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:211)

< at com.jivesoftware.community.aaa.authz.GuestAuthorizationInterceptor.intercept(GuestAuthorizationInterceptor.java:56)

< at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:211)

< at org.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.java:50)

< at org.apache.struts2.components.ActionComponent.executeAction(ActionComponent.java:255)

< at org.apache.struts2.components.ActionComponent.end(ActionComponent.java:155)

< at org.apache.struts2.views.freemarker.tags.CallbackWriter.afterBody(CallbackWriter.java:83)

< at freemarker.core.Environment.visit(Environment.java:299)

< at freemarker.core.UnifiedCall.accept(UnifiedCall.java:130)

< at freemarker.core.Environment.visit(Environment.java:208)

< at freemarker.core.MixedContent.accept(MixedContent.java:92)

< at freemarker.core.Environment.visit(Environment.java:208)

< at freemarker.core.Environment.process(Environment.java:188)

< at freemarker.template.Template.process(Template.java:237)

< at com.jivesoftware.community.web.struts.FreemarkerResult.doExecute(FreemarkerResult.java:107)

< at org.apache.struts2.dispatcher.StrutsResultSupport.execute(StrutsResultSupport.java:178)

< at com.opensymphony.xwork2.DefaultActionInvocation.executeResult(DefaultActionInvocation.java:320)

< at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:229)

< at com.jivesoftware.community.action.RecentHistoryInterceptor.doIntercept(RecentHistoryInterceptor.java:72)

< at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:86)

< at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:211)

< at com.jivesoftware.community.action.ViewCountInterceptor.doIntercept(ViewCountInterceptor.java:68)

< at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:86)

< at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:211)

< at com.jivesoftware.community.web.struts.FlashInterceptor.intercept(FlashInterceptor.java:41)

< at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:211)

< at com.opensymphony.xwork2.interceptor.DefaultWorkflowInterceptor.doIntercept(DefaultWorkflowInterceptor.java:221)

< at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:86)

< at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:211)

< at com.opensymphony.xwork2.validator.ValidationInterceptor.doIntercept(ValidationInterceptor.java:150)