[mashup-dev] [jira] Commented: (MASHUP-453) Error when adding a new user

[Channa Gunawardena (JIRA)]

    [ http://wso2.org/jira/browse/MASHUP-453?page=comments#action_14259 ] 
            
Channa Gunawardena commented on MASHUP-453:
-------------------------------------------

The add user link is only displayed to an admin user and the name of the new user is validated to be unique before attempting to create the user.

> Error when adding a new user
> ----------------------------
>
>                 Key: MASHUP-453
>                 URL: http://wso2.org/jira/browse/MASHUP-453
>             Project: WSO2 Mashup Server
>          Issue Type: Bug
>    Affects Versions: 0.2
>         Environment: WinXP, JDK1.5, IE7
>            Reporter: Yumani Ranaweera
>         Assigned To: Channa Gunawardena
>            Priority: Critical
>             Fix For: 0.3
>
>
> Steps to recreate:
> --------------------
> 1. Login to the Mashup UI as a normal user.
> 2. Add a new user.
> Issue:
> ------
> User is not added.
> It gives an error as given below. 
> ERROR [2007-12-14 08:18:25,000]  Error adding user in user manager
> org.wso2.usermanager.UserManagerException: Error modifying the database
>         at org.wso2.usermanager.readwrite.DefaultUserStoreAdmin.addUser(DefaultUserStoreAdmin.java:54)
>         at org.wso2.mashup.webapp.userprofile.AddUserBean.createUser(AddUserBean.java:173)
>         at org.wso2.mashup.webapp.userprofile.AddUserBean.addUser(AddUserBean.java:119)
>         at org.apache.jsp.org.add_005fuser_jsp._jspService(org.apache.jsp.org.add_005fuser_jsp:152)
>         at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
>         at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
>         at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:332)
>         at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
>         at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
>         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.solutions.identity.relyingparty.servletfilter.RelyingPartyFilter.doFilter(RelyingPartyFilter.java:156)
>         at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
>         at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
>         at org.wso2.mashup.transport.ServiceUIFilter.doFilter(ServiceUIFilter.java:186)
>         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: SQL Exception: The statement was aborted because it would have caused a duplicate key value in a unique or primary key constraint or unique
>  index identified by 'SQL071214050636030' defined on 'UM_USERS'.
>         at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
>         at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
>         at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
>         at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
>         at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
>         at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source)
>         at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown Source)
>         at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown Source)
>         at org.wso2.usermanager.readwrite.DefaultUserStoreAdmin.addUser(DefaultUserStoreAdmin.java:49)
>         ... 29 more

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