#Sharpdesk 3.5 code
(CPS_ID, CP_TYPE, USERNAME), add constraint cp_unique_group unique (CPS_ID, CP_TYPE, GROUPNAME)] SQL state error code Įrror on rename of './confluence_dbo/#sql-12e1_43c' to './confluence_dbo/content_perm' (errno: 150) nested exception is :Įrror on rename of './confluence_dbo/#sql-12e1_43c' to './confluence_dbo/content_perm' (errno: 150) .UpgradeException:Įrror on rename of './confluence_dbo/#sql-12e1_43c' to './confluence_dbo/content_perm' (errno: 150) Cause
StatementCallback uncategorized SQLException for SQL [alter table CONTENT_PERM modify CPS_ID bigint not null, add constraint cp_unique_user unique
#Sharpdesk 3.5 upgrade
Upgrade task failed during the SCHEMA_UPGRADE phase due to: 11:48:32,779 ERROR contextInitialized Upgrade failed, application will not start: 11:48:32,754 ERROR alterTable Failed to run alter table commands Unique constraints on Content Permissions and Content Permission Set columns 11:48:32,716 INFO doUpgrade Beginning task to add not null and SQL: alter table BANDANA add constraint bandana_unique_key unique (BANDANACONTEXT, BANDANAKEY) 11:48:32,690 INFO alterTableUngrouped Database is reporting that the column already has the
11:48:32,636 INFO ] doUpgrade Ignoring non-existence of band_key_idx constraint 11:48:32,631 INFO ] doUpgrade Adding not null and unique constraints on 11:48:32,621 INFO ] cleanUp Checking for invalid entries in the Bandana table 11:48:32,607 WARN doUpgrade Could not create unique constraint:Īlter table cwd_membership add constraint cwd_unique_group_membership unique (parent_id, child_group_id), StatementCallback bad SQL grammarĬom.4.MySQLSynta圎rrorException: Duplicate key name 'cwd_unique_group_membership' Nested exception is .jdbc4.MySQLSynta圎rrorException: Duplicate key name 'cwd_unique_grp_attr' 11:48:32,606 WARN ] doUpgrade Could not create unique constraint:Īlter table cwd_group_attribute add constraint cwd_unique_grp_attr unique (directory_id, group_id, attribute_name, attribute_lower_value), StatementCallback Nested exception is .jdbc4.MySQLSynta圎rrorException: Duplicate key name 'cwd_unique_usr_attr' 11:48:32,604 WARN ] doUpgrade Could not create unique constraint:Īlter table cwd_user_attribute add constraint cwd_unique_usr_attr unique (directory_id, user_id, attribute_name, attribute_lower_value), StatementCallback īad SQL grammar
11:48:32,602 WARN ] doUpgrade Could not create unique constraint:Īlter table cwd_group add constraint cwd_group_name_dir_id unique (lower_group_name, directory_id), StatementCallback bad SQL grammarĬom.4.MySQLSynta圎rrorException: Duplicate key name 'cwd_group_name_dir_id' 11:48:32,601 WARN doUpgrade Could not create unique constraint:Īlter table cwd_user add constraint cwd_user_name_dir_id unique (lower_user_name, directory_id), StatementCallback bad SQL grammarĬ.jdbc4.MySQLSynta圎rrorException: Duplicate key name 'cwd_user_name_dir_id' nested exception isĬom.4.MySQLSynta圎rrorException: Duplicate key name 'cwd_unique_user_membership' 11:48:32,599 WARN doUpgrade Could not create unique constraint:Īlter table cwd_membership add constraint cwd_unique_user_membership unique (parent_id, child_user_id), StatementCallback bad SQL grammar