Hi Hasini,
On 28 February 2013 17:52, Hasini Gunasinghe <[email protected]> wrote: > 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? > I took a svn up in user.core and replaced it. But still I am getting the error when above given steps are followed. Will check in the next pack as well. Thanks, Lakmali > > 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 >> >> > -- 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
