[ https://wso2.org/jira/browse/REGISTRY-185?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Krishantha Samaraweera closed REGISTRY-185.
-------------------------------------------
Resolution: Duplicate
There is an another issue open for this. So this issue will be closed now.
> Incorrect error when adding the same role twice
> -----------------------------------------------
>
> Key: REGISTRY-185
> URL: https://wso2.org/jira/browse/REGISTRY-185
> Project: WSO2 Registry
> Issue Type: Bug
> Environment: WinXp, JDK1.5, FF
> Reporter: Yumani Ranaweera
> Assignee: Chathura Ekanayake
>
> Steps:
> -------
> 1. Login as admin
> 2. Add a person
> 3. Assign him admin role
> 4. Assign the admin role again
> It gives an error message as below;
> Could not add the user yumani to the role admin. Caused by: Error adding user to role. Violation of unique constraint SYS_CT_144: duplicate value(s) for column(s) $$ in statement [insert into um_user_roles (id, user_id, role_id) values (?, ?, ?)]
> ********** Its more infomative if you say "The role is already assigned". Also can we NOT have the 'Caused by: details of the error in the UI.
> FYI - the stack trace of the error is as below;
> org.wso2.registry.RegistryException: Could not add the user yum to the role admin. Caused by: Error adding user to role. Violation of unique constrain
> t SYS_CT_144: duplicate value(s) for column(s) $$ in statement [insert into um_user_roles (id, user_id, role_id) values (?, ?, ?)]
> at org.wso2.registry.web.actions.AddUserRoleAction.execute(AddUserRoleAction.java:46)
> at org.wso2.registry.web.ControllerServlet.doPost(ControllerServlet.java:295)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:228)
> at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
> at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
> at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)
> at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
> at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:216)
> at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
> at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:634)
> at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:445)
> at java.lang.Thread.run(Thread.java:595)
--
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