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
