server 5.11.1 profile manager migration failed
Hi
I updated my Server from 5.10 to 5.11.1
turn on Profile manager and get the message :
Error reading settings
Service functionality and administration may be affected
Click Continue to administer this server
I click continue to set and get the message :
An error with code -1 occurred
I see this in migration_tool.log:
0:: [13772] [2021-05-10 10:15:08.441] Waiting for postgres to startup....
0:: [13772] [2021-05-10 10:15:08.952] Loaded schema from /Applications/Server.app/Contents/ServerRoot/usr/share/devicemgr/migration/v2m1.dmmd.bz2
0:: [13772] [2021-05-10 10:15:09.044] Dropping views...
0:: [13772] [2021-05-10 10:15:09.053] Dropping materialized views...
0:: [13772] [2021-05-10 10:15:09.055] Dropping trigger functions...
0:: [13772] [2021-05-10 10:15:09.077] Dropping extensions...
0:: [13772] [2021-05-10 10:15:09.153] Dropping remaining non-dependent functions...
0:: [13772] [2021-05-10 10:15:09.888] Re-creating runtime functions...
0:: [13772] [2021-05-10 10:15:10.156] EXCEPTION: Postgres <-[PGConnection executeCSQL:] (PGConnection.m:598): "Postgres error 2BP01 (ERROR: cannot drop table abstract_asm_library_items because other objects depend on it
DETAIL: table user_groups depends on table abstract_asm_library_items
constraint edu_classes_user_groups_user_group_id_fkey on table edu_classes_user_groups depends on table user_groups
constraint user_group_memberships_child_id_fkey on table user_group_memberships depends on table user_groups
constraint user_group_memberships_parent_id_fkey on table user_group_memberships depends on table user_groups
constraint user_groups_users_user_group_id_fkey on table user_groups_users depends on table user_groups
HINT: Use DROP ... CASCADE to drop the dependent objects too.
)">
USERINFO: {
SQLSTATE = 2BP01;
errorMessage = "ERROR: cannot drop table abstract_asm_library_items because other objects depend on it\nDETAIL: table user_groups depends on table abstract_asm_library_items\nconstraint edu_classes_user_groups_user_group_id_fkey on table edu_classes_user_groups depends on table user_groups\nconstraint user_group_memberships_child_id_fkey on table user_group_memberships depends on table user_groups\nconstraint user_group_memberships_parent_id_fkey on table user_group_memberships depends on table user_groups\nconstraint user_groups_users_user_group_id_fkey on table user_groups_users depends on table user_groups\nHINT: Use DROP ... CASCADE to drop the dependent objects too.\n";
}
0:: [13772] [2021-05-10 10:15:10.157] Migration “MIGRATE_00945.000.01” failed at statement:
--------------------------------------------------------------------------------------
DROP TABLE abstract_asm_library_items;
--------------------------------------------------------------------------------------
-[PGConnection executeCSQL:] (PGConnection.m:598): "Postgres error 2BP01 (ERROR: cannot drop table abstract_asm_library_items because other objects depend on it
DETAIL: table user_groups depends on table abstract_asm_library_items
constraint edu_classes_user_groups_user_group_id_fkey on table edu_classes_user_groups depends on table user_groups
constraint user_group_memberships_child_id_fkey on table user_group_memberships depends on table user_groups
constraint user_group_memberships_parent_id_fkey on table user_group_memberships depends on table user_groups
constraint user_groups_users_user_group_id_fkey on table user_groups_users depends on table user_groups
HINT: Use DROP ... CASCADE to drop the dependent objects too.
)"
What can I do?
