SHARPDESK 3.5 UPGRADE
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

Sharpdesk 3.5