Cannot add <USER> but the <USER> doesn't exist in the User Management
Symptoms
When trying to create a new user the following ERROR
occurs:
Could not execute JDBC batch update
Duplicate entry '<USER>' for key 2
You are running release CR2.7.3 FE2.7.3 (20110920012939 2011-09-20), please report your release number when reporting bugs.
Cause
This is probably happening because Fisheye and Crucible are disabled for that user.
Resolution
You should query you FeCru database to check that user:
mysql> SELECT * cru_user_id, cru_fisheye_enabled, cru_crucible_enabled FROM cru_user where cru_user_name = <USER>;
This will bring the value for both collums, if they are empty here is the problem and we should do the following:
mysql> UPDATE cru_user SET cru_fisheye_enabled = '1',cru_crucible_enabled = '1' WHERE cru_user_id = '<USER_ID>';
This will enable Fisheye and Crucible for the <USER>.
Last modified on Jul 31, 2018
Powered by Confluence and Scroll Viewport.