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.
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
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
