[mashup-dev] [jira] Commented: (MASHUP-829) Error when deleting a user - (while in default context)

Keith Godwin Chapman (JIRA) jira at wso2.org
Mon Jun 2 02:33:48 PDT 2008


    [ https://wso2.org/jira/browse/MASHUP-829?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17130#action_17130 ] 

Keith Godwin Chapman commented on MASHUP-829:
---------------------------------------------

Fixed in revision 17770.

> Error when deleting a user - (while in default context)
> -------------------------------------------------------
>
>                 Key: MASHUP-829
>                 URL: https://wso2.org/jira/browse/MASHUP-829
>             Project: WSO2 Mashup Server
>          Issue Type: Bug
>          Components: Admin UI
>    Affects Versions: Nightly
>         Environment: WinXP, JDK1.5 
>            Reporter: Yumani Ranaweera
>            Assignee: Channa Gunawardena
>             Fix For: Future
>
>
> Steps:
> --------
> 1. Login as admin
> 2. Add a new user, change to that user's login, create a new mashup
> 3. Sign-out and login as admin
> 4. Delete the user (purge data)
> Issue:
> ------- The error below appear;
> ERROR [2008-06-02 11:11:26,406]  Failed to execute query /querystore/userscomments. All database operations will be rolled back. Syntax error: Encount
> ered "AND" at line 1, column 86.
> org.wso2.registry.exceptions.RegistryException: Syntax error: Encountered "AND" at line 1, column 86.
>         at org.wso2.registry.jdbc.queries.SQLQueryProcessor.executeQuery(SQLQueryProcessor.java:115)
>         at org.wso2.registry.jdbc.queries.QueryProcessorManager.executeQuery(QueryProcessorManager.java:96)
>         at org.wso2.registry.jdbc.BasicRegistry.executeQuery(BasicRegistry.java:619)
>         at org.wso2.registry.jdbc.AtomicRegistry.executeQuery(AtomicRegistry.java:879)
>         at org.wso2.registry.jdbc.JDBCRegistry.executeQuery(JDBCRegistry.java:543)
>         at org.wso2.registry.session.UserRegistry.executeQuery(UserRegistry.java:402)
>         at org.wso2.mashup.admin.service.MashupAdminService.deleteUserServices(MashupAdminService.java:443)
>         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>         at java.lang.reflect.Method.invoke(Method.java:585)
>         at org.apache.axis2.rpc.receivers.RPCUtil.invokeServiceClass(RPCUtil.java:194)
>         at org.apache.axis2.rpc.receivers.RPCMessageReceiver.invokeBusinessLogic(RPCMessageReceiver.java:102)
>         at org.apache.axis2.receivers.AbstractInOutMessageReceiver.invokeBusinessLogic(AbstractInOutMessageReceiver.java:40)
>         at org.apache.axis2.receivers.AbstractMessageReceiver.receive(AbstractMessageReceiver.java:100)
>         at org.apache.axis2.engine.AxisEngine.receive(AxisEngine.java:176)
>         at org.apache.axis2.transport.http.HTTPTransportUtils.processHTTPPostRequest(HTTPTransportUtils.java:275)
>         at org.apache.axis2.transport.http.AxisServlet.doPost(AxisServlet.java:131)
>         at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
>         at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
>         at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
>         at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
>         at org.wso2.mashup.transport.ServiceUIFilter.doFilter(ServiceUIFilter.java:210)
>         at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
>         at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
>         at org.wso2.adminui.AdminUIServletFilter.doFilter(AdminUIServletFilter.java:135)
>         at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
>         at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
>         at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
>         at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
>         at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
>         at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
>         at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
>         at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
>         at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
>         at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:667)
>         at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
>         at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
>         at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
>         at java.lang.Thread.run(Thread.java:595)
> ERROR [2008-06-02 11:11:26,484]  Exception occured while deleting services of user test. Reason :  Failed to execute query /querystore/userscomments.
> All database operations will be rolled back. Syntax error: Encountered "AND" at line 1, column 86.
> org.wso2.mashup.MashupFault: Exception occured while deleting services of user test. Reason :  Failed to execute query /querystore/userscomments. All
> database operations will be rolled back. Syntax error: Encountered "AND" at line 1, column 86.
>         at org.wso2.mashup.admin.service.MashupAdminService.deleteUserServices(MashupAdminService.java:454)
>         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>         at java.lang.reflect.Method.invoke(Method.java:585)
>         at org.apache.axis2.rpc.receivers.RPCUtil.invokeServiceClass(RPCUtil.java:194)
>         at org.apache.axis2.rpc.receivers.RPCMessageReceiver.invokeBusinessLogic(RPCMessageReceiver.java:102)
>         at org.apache.axis2.receivers.AbstractInOutMessageReceiver.invokeBusinessLogic(AbstractInOutMessageReceiver.java:40)
>         at org.apache.axis2.receivers.AbstractMessageReceiver.receive(AbstractMessageReceiver.java:100)
>         at org.apache.axis2.engine.AxisEngine.receive(AxisEngine.java:176)
>         at org.apache.axis2.transport.http.HTTPTransportUtils.processHTTPPostRequest(HTTPTransportUtils.java:275)
>         at org.apache.axis2.transport.http.AxisServlet.doPost(AxisServlet.java:131)
>         at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
>         at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
>         at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
>         at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
>         at org.wso2.mashup.transport.ServiceUIFilter.doFilter(ServiceUIFilter.java:210)
>         at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
>         at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
>         at org.wso2.adminui.AdminUIServletFilter.doFilter(AdminUIServletFilter.java:135)
>         at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
>         at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
>         at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
>         at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
>         at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
>         at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
>         at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
>         at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
>         at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
>         at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:667)
>         at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
>         at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
>         at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
>         at java.lang.Thread.run(Thread.java:595)
> Caused by: org.wso2.registry.exceptions.RegistryException: Failed to execute query /querystore/userscomments. All database operations will be rolled b
> ack. Syntax error: Encountered "AND" at line 1, column 86.
>         at org.wso2.registry.jdbc.AtomicRegistry.executeQuery(AtomicRegistry.java:894)
>         at org.wso2.registry.jdbc.JDBCRegistry.executeQuery(JDBCRegistry.java:543)
>         at org.wso2.registry.session.UserRegistry.executeQuery(UserRegistry.java:402)
>         at org.wso2.mashup.admin.service.MashupAdminService.deleteUserServices(MashupAdminService.java:443)
>         ... 33 more
> Caused by: org.wso2.registry.exceptions.RegistryException: Syntax error: Encountered "AND" at line 1, column 86.
>         at org.wso2.registry.jdbc.queries.SQLQueryProcessor.executeQuery(SQLQueryProcessor.java:115)
>         at org.wso2.registry.jdbc.queries.QueryProcessorManager.executeQuery(QueryProcessorManager.java:96)
>         at org.wso2.registry.jdbc.BasicRegistry.executeQuery(BasicRegistry.java:619)
>         at org.wso2.registry.jdbc.AtomicRegistry.executeQuery(AtomicRegistry.java:879)
>         ... 36 more

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://wso2.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        



More information about the Mashup-dev mailing list