Hi Lakmali, I tested the above scenario with latest user.core and it works fine. Issue you faced might be fixed with other fixes we added.
Can you please take a svn up in user.core and check again? Thanks, Hasini. On Thu, Feb 28, 2013 at 5:36 PM, Lakmali Baminiwatta <[email protected]>wrote: > Hi , > > > On Thursday, 28 February 2013, Nuwan Dias <[email protected]> wrote: > > Hi, > > Are you having multiple user stores enabled in the user-mgt.xml? I have > seen this error before when I try to assign a role in one user store to a > user in another user store. > > No this is in the standalone mode. Also I am getting these errors with > latest user core changes. > > Thanks, > Lakmali > > > > Thanks, > > NuwanD. > > > > On Thu, Feb 28, 2013 at 5:06 PM, Lakmali Baminiwatta <[email protected]> > wrote: > >> > >> Hi all, > >> > >> In APIM management console, I created a new role with API create > permission. > >> The created a new user, and selected the above role for that user. > >> Then when I save the user, following exceptions are thrown. > >> > >> > >> ERROR - DatabaseUtil NULL not allowed for column "UM_ROLE_ID"; SQL > statement: > >> INSERT INTO UM_USER_ROLE (UM_ROLE_ID, UM_USER_ID, UM_TENANT_ID) VALUES > ((SELECT UM_ID FROM UM_ROLE WHERE UM_ROLE_NAME=? AND > UM_TENANT_ID=?),(SELECT UM_ID FROM UM_USER WHERE UM_USER_NAME=? AND > UM_TENANT_ID=?), ?) [90006-140] > >> org.h2.jdbc.JdbcBatchUpdateException: NULL not allowed for column > "UM_ROLE_ID"; SQL statement: > >> INSERT INTO UM_USER_ROLE (UM_ROLE_ID, UM_USER_ID, UM_TENANT_ID) VALUES > ((SELECT UM_ID FROM UM_ROLE WHERE UM_ROLE_NAME=? AND > UM_TENANT_ID=?),(SELECT UM_ID FROM UM_USER WHERE UM_USER_NAME=? AND > UM_TENANT_ID=?), ?) [90006-140] > >> at > org.h2.jdbc.JdbcPreparedStatement.executeBatch(JdbcPreparedStatement.java:1098) > >> at > org.wso2.carbon.user.core.util.DatabaseUtil.udpateUserRoleMappingInBatchMode(DatabaseUtil.java:352) > >> at > org.wso2.carbon.user.core.jdbc.JDBCUserStoreManager.persistUser(JDBCUserStoreManager.java:1003) > >> at > org.wso2.carbon.user.core.jdbc.JDBCUserStoreManager.doAddUser(JDBCUserStoreManager.java:910) > >> at > org.wso2.carbon.user.core.common.AbstractUserStoreManager.addUser(AbstractUserStoreManager.java:1078) > >> at > org.wso2.carbon.user.mgt.UserRealmProxy.addUser(UserRealmProxy.java:360) > >> at org.wso2.carbon.user.mgt.UserAdmin.addUser(UserAdmin.java:119) > >> 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:597) > >> at > org.apache.axis2.rpc.receivers.RPCUtil.invokeServiceClass(RPCUtil.java:212) > >> at > org.apache.axis2.rpc.receivers.RPCMessageReceiver.invokeBusinessLogic(RPCMessageReceiver.java:117) > >> at > org.apache.axis2.receivers.AbstractInOutMessageReceiver.invokeBusinessLogic(AbstractInOutMessageReceiver.java:40) > >> at > org.apache.axis2.receivers.AbstractMessageReceiver.receive(AbstractMessageReceiver.java:110) > >> at org.apache.axis2.engine.AxisEngine.receive(AxisEngine.java:180) > >> at > org.apache.axis2.transport.local.LocalTransportReceiver.processMessage(LocalTransportReceiver.java:169) > >> at > org.apache.axis2.transport.local.LocalTransportReceiver.processMessage(LocalTransportReceiver.java:82) > >> at > org.wso2.carbon.core.transports.local.CarbonLocalTransportSender.finalizeSendWithToAddress(CarbonLocalTransportSender.java:45) > >> at > org.apache.axis2.transport.local.LocalTransportSender.invoke(LocalTransportSender.java:77) > >> at org.apache.axis2.engine.AxisEngine.send(AxisEngine.java:442) > >> at > org.apache.axis2.description.OutInAxisOperationClient.send(OutInAxisOperation.java:398) > >> at > org.apache.axis2.description.OutInAxisOperationClient.executeImpl(OutInAxisOperation.java:224) > >> at > org.apache.axis2.client.OperationClient.execute(OperationClient.java:149) > >> at > org.wso2.carbon.user.mgt.stub.UserAdminStub.addUser(UserAdminStub.java:1529) > >> at > org.wso2.carbon.user.mgt.ui.UserAdminClient.addUser(UserAdminClient.java:105) > >> at > org.apache.jsp.user.add_002dfinish_jsp._jspService(add_002dfinish_jsp.java:132) > >> at > org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97) > >> at javax.servlet.http.HttpServlet.service(HttpServlet.java:722) > >> 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:722) > >> at org.wso2.carbon.ui.JspServlet.service(JspServlet.java:161) > >> at > org.wso2.carbon.ui.TilesJspServlet.service(TilesJspServlet.java:80) > >> at javax.servlet.http.HttpServlet.service(HttpServlet.java:722) > >> at > org.eclipse.equinox.http.helper.ContextPathServletAdaptor.service(ContextPathServletAdaptor.java:36) > >> at > org.eclipse.equinox.http.servlet.internal.ServletRegistration.handleRequest(ServletRegistration.java:90) > >> at > org.eclipse.equinox.http.servlet.internal.ProxyServlet.processAlias(ProxySer > >> _______________________________________________ > >> Dev mailing list > >> [email protected] > >> http://wso2.org/cgi-bin/mailman/listinfo/dev > >> > > > > > > > > -- > > Nuwan Dias > > Member, Management Committee - Solutions Technology Group > > Software Engineer - WSO2, Inc. http://wso2.com > > email : [email protected] > > Phone : +94 777 775 729 > > -- > Lakmali Baminiwatta* > * > Software Engineer > WSO2, Inc.: http://wso2.com > lean.enterprise.middleware > mobile: +94 71 2335936 > * > * > > > _______________________________________________ > Dev mailing list > [email protected] > http://wso2.org/cgi-bin/mailman/listinfo/dev > >
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
