On Thu, Jul 18, 2013 at 12:54 PM, Darshana Gunawardana <[email protected]>wrote:
> Hi Amila, > > Database scripts are updated and tested with a new IS pack. Users and > roles can be added successfully using a JDBC user store manager. > Great. Can you also build a AS pack and see whether all security scenarios working? thanks, Amila. > > Thanks, > Darshana > > > On Wed, Jul 17, 2013 at 7:21 PM, Amila Suriarachchi <[email protected]>wrote: > >> >> >> -- >> *Amila Suriarachchi* >> >> Software Architect >> WSO2 Inc. ; http://wso2.com >> lean . enterprise . middleware >> >> phone : +94 71 3082805 >> Caused by: org.wso2.carbon.user.core.UserStoreException: 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.wso2.carbon.user.core.util.DatabaseUtil.udpateUserRoleMappingInBatchMode(DatabaseUtil.java:471) >> at >> org.wso2.carbon.user.core.jdbc.JDBCUserStoreManager.persistUser(JDBCUserStoreManager.java:1004) >> ... 125 more >> Caused by: 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:460) >> ... 126 more >> [2013-07-17 19:16:56,506] ERROR >> {org.wso2.carbon.user.mgt.ui.UserAdminClient} - 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.wso2.carbon.user.mgt.stub.UserAdminUserAdminException: >> UserAdminUserAdminException >> >> thanks, >> Amila. >> >> >> _______________________________________________ >> Dev mailing list >> [email protected] >> http://wso2.org/cgi-bin/mailman/listinfo/dev >> >> > > > -- > Regards, > > * > Darshana Gunawardana > *Software Engineer > WSO2 Inc.; http://wso2.com* > E-mail: [email protected] > **Mobile: +94718566859 > *Lean . Enterprise . Middleware > -- *Amila Suriarachchi* Software Architect WSO2 Inc. ; http://wso2.com lean . enterprise . middleware phone : +94 71 3082805
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
