Forum OpenACS Q&A: tdom compile in aolserver error.."TT"

openacs installation: installing openacs core services error

Failed to install ACS Kernel, version 4.7.2d. The following error was generated:

psql:postgresql.sql:1: ERROR: relation "dual" already exists psql:postgresql.sql:4: ERROR: relation "t_anon_func_seq" already exists psql:postgresql.sql:6: ERROR: relation "anon_func_seq" already exists psql:postgresql.sql:44: ERROR: function "instr" already exists with same argument types psql:postgresql.sql:54: ERROR: function "instr" already exists with same argument types psql:postgresql.sql:63: ERROR: function "instr" already exists with same argument types psql:postgresql.sql:97: ERROR: function "split" already exists with same argument types psql:postgresql.sql:142: ERROR: function "get_func_drop_command" already exists with same argument types psql:postgresql.sql:172: ERROR: function "drop_package" already exists with same argument types psql:postgresql.sql:197: ERROR: function "number_src" already exists with same argument types psql:postgresql.sql:247: ERROR: function "get_func_definition" already exists with same argument types psql:postgresql.sql:261: ERROR: function "get_func_header" already exists with same argument types psql:postgresql.sql:266: ERROR: relation "acs_func_defs" already exists psql:postgresql.sql:271: ERROR: relation "acs_func_headers" already exists psql:postgresql.sql:408: ERROR: function "int_to_tree_key" already exists with same argument types psql:postgresql.sql:444: ERROR: function "tree_key_to_int" already exists with same argument types psql:postgresql.sql:473: ERROR: function "tree_ancestor_key" already exists with same argument types psql:postgresql.sql:490: ERROR: function "tree_root_key" already exists with same argument types psql:postgresql.sql:519: ERROR: function "tree_leaf_key_to_int" already exists with same argument types psql:postgresql.sql:545: ERROR: function "tree_next_key" already exists with same argument types psql:postgresql.sql:560: ERROR: function "tree_increment_key" already exists with same argument types psql:postgresql.sql:575: ERROR: function "tree_left" already exists with same argument types psql:postgresql.sql:591: ERROR: function "tree_right" already exists with same argument types psql:postgresql.sql:622: ERROR: function "tree_level" already exists with same argument types psql:postgresql.sql:630: ERROR: function "tree_ancestor_p" already exists with same argument types psql:postgresql.sql:644: ERROR: function "tree_ancestor_keys" already exists with same argument types psql:postgresql.sql:703: ERROR: function "tree_ancestor_keys" already exists with same argument types psql:postgresql.sql:716: ERROR: relation "user_tab_columns" already exists psql:postgresql.sql:725: ERROR: relation "user_col_comments" already exists psql:postgresql.sql:738: ERROR: relation "user_tab_comments" already exists psql:postgresql.sql:751: ERROR: relation "acs_function_args" already exists psql:postgresql.sql:791: ERROR: function "define_function_args" already exists with same argument types psql:postgresql.sql:834: ERROR: function "trigger_type" already exists with same argument types psql:lob.sql:19: ERROR: relation "lob_sequence" already exists psql:lob.sql:24: ERROR: relation "lobs" already exists psql:lob.sql:30: ERROR: function "on_lobs_delete" already exists with same argument types psql:lob.sql:33: ERROR: trigger "lobs_delete_trig" for relation "lobs" already exists psql:lob.sql:41: ERROR: relation "lob_data" already exists psql:lob.sql:43: ERROR: relation "lob_data_index" already exists psql:lob.sql:77: ERROR: function "on_lob_ref" already exists with same argument types psql:lob.sql:82: ERROR: function "empty_lob" already exists with same argument types psql:lob.sql:96: ERROR: function "lob_get_data" already exists with same argument types psql:lob.sql:112: ERROR: function "lob_copy" already exists with same argument types psql:lob.sql:119: ERROR: function "lob_length" already exists with same argument types psql:acs-logs-create.sql:9: ERROR: relation "t_acs_log_id_seq" already exists psql:acs-logs-create.sql:11: ERROR: relation "acs_log_id_seq" already exists psql:acs-logs-create.sql:24: ERROR: relation "acs_logs" already exists psql:acs-logs-create.sql:67: ERROR: function "acs_log__notice" already exists with same argument types psql:acs-logs-create.sql:83: ERROR: function "acs_log__warn" already exists with same argument types psql:acs-logs-create.sql:99: ERROR: function "acs_log__error" already exists with same argument types psql:acs-logs-create.sql:115: ERROR: function "acs_log__debug" already exists with same argument types psql:acs-metadata-create.sql:53: ERROR: relation "acs_object_types" already exists psql:acs-metadata-create.sql:55: ERROR: relation "acs_obj_types_supertype_idx" already exists psql:acs-metadata-create.sql:56: ERROR: relation "acs_obj_types_tree_skey_idx" already exists psql:acs-metadata-create.sql:65: ERROR: function "acs_object_type_get_tree_sortkey" already exists with same argument types psql:acs-metadata-create.sql:84: ERROR: function "acs_object_type_insert_tr" already exists with same argument types psql:acs-metadata-create.sql:88: ERROR: trigger "acs_object_type_insert_tr" for relation "acs_object_types" already exists psql:acs-metadata-create.sql:132: ERROR: function "acs_object_type_update_tr" already exists with same argument types psql:acs-metadata-create.sql:137: ERROR: trigger "acs_object_type_update_tr" for relation "acs_object_types" already exists psql:acs-metadata-create.sql:238: ERROR: relation "acs_object_type_supertype_map" already exists psql:acs-metadata-create.sql:248: ERROR: relation "acs_object_type_tables" already exists psql:acs-metadata-create.sql:250: ERROR: relation "acs_objtype_tbls_objtype_idx" already exists psql:acs-metadata-create.sql:273: ERROR: relation "acs_datatypes" already exists psql:acs-metadata-create.sql:355: ERROR: duplicate key violates unique constraint "acs_datatypes_pk" CONTEXT: PL/pgSQL function "inline_0" line 2 at SQL statement psql:acs-metadata-create.sql:364: ERROR: relation "t_acs_attribute_id_seq" already exists psql:acs-metadata-create.sql:366: ERROR: relation "acs_attribute_id_seq" already exists psql:acs-metadata-create.sql:407: ERROR: relation "acs_attributes" already exists psql:acs-metadata-create.sql:411: ERROR: relation "acs_attrs_obj_type_idx" already exists psql:acs-metadata-create.sql:412: ERROR: relation "acs_attrs_tbl_name_idx" already exists psql:acs-metadata-create.sql:413: ERROR: relation "acs_attrs_datatype_idx" already exists psql:acs-metadata-create.sql:465: ERROR: relation "acs_enum_values" already exists psql:acs-metadata-create.sql:467: ERROR: relation "acs_enum_values_attr_id_idx" already exists psql:acs-metadata-create.sql:480: ERROR: relation "acs_attribute_descriptions" already exists psql:acs-metadata-create.sql:482: ERROR: relation "acs_attr_desc_obj_type_idx" already exists psql:acs-metadata-create.sql:483: ERROR: relation "acs_attr_desc_attr_name_idx" already exists psql:acs-metadata-create.sql:512: ERROR: relation "acs_object_type_attributes" already exists psql:acs-metadata-create.sql:569: ERROR: function "acs_object_type__create_type" already exists with same argument types psql:acs-metadata-create.sql:597: ERROR: function "acs_object_type__drop_type" already exists with same argument types psql:acs-metadata-create.sql:613: ERROR: function "acs_object_type__pretty_name" already exists with same argument types psql:acs-metadata-create.sql:644: ERROR: function "acs_object_type__is_subtype_p" already exists with same argument types psql:acs-metadata-create.sql:700: ERROR: function "acs_attribute__create_attribute" already exists with same argument types psql:acs-metadata-create.sql:706: ERROR: function "acs_attribute__create_attribute" already exists with same argument types psql:acs-metadata-create.sql:727: ERROR: function "acs_attribute__drop_attribute" already exists with same argument types psql:acs-metadata-create.sql:746: ERROR: function "acs_attribute__add_description" already exists with same argument types psql:acs-metadata-create.sql:763: ERROR: function "acs_attribute__drop_description" already exists with same argument types psql:acs-objects-create.sql:156: ERROR: duplicate key violates unique constraint "acs_object_types_pk" CONTEXT: PL/pgSQL function "acs_object_type__create_type" line 37 at SQL statement PL/pgSQL function "inline_0" line 7 at perform psql:acs-objects-create.sql:171: ERROR: relation "t_acs_object_id_seq" already exists psql:acs-objects-create.sql:173: ERROR: relation "acs_object_id_seq" already exists psql:acs-objects-create.sql:193: ERROR: relation "acs_objects" already exists psql:acs-objects-create.sql:196: ERROR: relation "acs_objects_context_object_idx" already exists psql:acs-objects-create.sql:198: ERROR: relation "acs_objs_tree_skey_idx" already exists psql:acs-objects-create.sql:202: ERROR: relation "acs_objects_creation_user_idx" already exists psql:acs-objects-create.sql:203: ERROR: relation "acs_objects_modify_user_idx" already exists psql:acs-objects-create.sql:205: ERROR: relation "acs_objects_object_type_idx" already exists psql:acs-objects-create.sql:213: ERROR: function "acs_objects_mod_ip_insert_tr" already exists with same argument types psql:acs-objects-create.sql:216: ERROR: trigger "acs_objects_mod_ip_insert_tr" for relation "acs_objects" already exists psql:acs-objects-create.sql:226: ERROR: function "acs_objects_last_mod_update_tr" already exists with same argument types psql:acs-objects-create.sql:229: ERROR: trigger "acs_objects_last_mod_update_tr" for relation "acs_objects" already exists psql:acs-objects-create.sql:238: ERROR: function "acs_objects_get_tree_sortkey" already exists with same argument types psql:acs-objects-create.sql:264: ERROR: function "acs_objects_insert_tr" already exists with same argument types psql:acs-objects-create.sql:268: ERROR: trigger "acs_objects_insert_tr" for relation "acs_objects" already exists psql:acs-objects-create.sql:323: ERROR: function "acs_objects_update_tr" already exists with same argument types psql:acs-objects-create.sql:328: ERROR: trigger "acs_objects_update_tr" for relation "acs_objects" already exists psql:acs-objects-create.sql:371: ERROR: relation "acs_object_context_index" already exists psql:acs-objects-create.sql:373: ERROR: relation "acs_obj_ctx_idx_ancestor_idx" already exists psql:acs-objects-create.sql:377: ERROR: relation "acs_object_paths" already exists psql:acs-objects-create.sql:382: ERROR: relation "acs_object_contexts" already exists psql:acs-objects-create.sql:413: ERROR: cannot change return type of existing function HINT: Use DROP FUNCTION first. psql:acs-objects-create.sql:416: ERROR: trigger "acs_objects_context_id_in_tr" for relation "acs_objects" already exists psql:acs-objects-create.sql:480: ERROR: cannot change return type of existing function HINT: Use DROP FUNCTION first. psql:acs-objects-create.sql:483: ERROR: trigger "acs_objects_context_id_up_tr" for relation "acs_objects" already exists psql:acs-objects-create.sql:492: ERROR: function "acs_objects_context_id_del_tr" already exists with same argument types psql:acs-objects-create.sql:495: ERROR: trigger "acs_objects_context_id_del_tr" for relation "acs_objects" already exists psql:acs-objects-create.sql:501: ERROR: relation "t_acs_attribute_value_id_seq" already exists psql:acs-objects-create.sql:503: ERROR: relation "acs_attribute_value_id_seq" already exists psql:acs-objects-create.sql:515: ERROR: relation "acs_attribute_values" already exists psql:acs-objects-create.sql:517: ERROR: relation "acs_attr_values_attr_id_idx" already exists psql:acs-objects-create.sql:535: ERROR: relation "acs_static_attr_values" already exists psql:acs-objects-create.sql:537: ERROR: relation "acs_stat_attrs_attr_id_idx" already exists psql:acs-objects-create.sql:587: ERROR: function "acs_object__initialize_attributes" already exists with same argument types psql:acs-objects-create.sql:629: ERROR: function "acs_object__new" already exists with same argument types psql:acs-objects-create.sql:668: ERROR: function "acs_object__new" already exists with same argument types psql:acs-objects-create.sql:676: ERROR: function "acs_object__new" already exists with same argument types psql:acs-objects-create.sql:730: ERROR: function "acs_object__delete" already exists with same argument types psql:acs-objects-create.sql:783: ERROR: function "acs_object__name" already exists with same argument types psql:acs-objects-create.sql:801: ERROR: function "acs_object__default_name" already exists with same argument types psql:acs-objects-create.sql:936: ERROR: function "acs_object__get_attribute_storage" already exists with same argument types psql:acs-objects-create.sql:952: ERROR: function "acs_object__get_attr_storage_column" already exists with same argument types psql:acs-objects-create.sql:973: ERROR: function "acs_object__get_attr_storage_table" already exists with same argument types psql:acs-objects-create.sql:994: ERROR: function "acs_object__get_attr_storage_sql" already exists with same argument types psql:acs-objects-create.sql:1027: ERROR: function "acs_object__get_attribute" already exists with same argument types psql:acs-objects-create.sql:1053: ERROR: function "acs_object__set_attribute" already exists with same argument types psql:acs-objects-create.sql:1101: ERROR: function "acs_object__check_context_index" already exists with same argument types psql:acs-objects-create.sql:1168: ERROR: function "acs_object__check_object_ancestors" already exists with same argument types psql:acs-objects-create.sql:1213: ERROR: function "acs_object__check_object_descendants" already exists with same argument types psql:acs-objects-create.sql:1249: ERROR: function "acs_object__check_path" already exists with same argument types psql:acs-objects-create.sql:1337: ERROR: function "acs_object__check_representation" already exists with same argument types psql:acs-objects-create.sql:1345: ERROR: function "acs_object__update_last_modified" already exists with same argument types psql:acs-objects-create.sql:1375: ERROR: function "acs_object__update_last_modified" already exists with same argument types psql:acs-objects-create.sql:1393: ERROR: relation "general_objects" already exists psql:acs-object-util.sql:16: ERROR: function "acs_object_util__object_type_exist_p" already exists with same argument types psql:acs-object-util.sql:35: ERROR: function "acs_object_util__get_object_type" already exists with same argument types psql:acs-object-util.sql:58: ERROR: function "acs_object_util__type_ancestor_type_p" already exists with same argument types psql:acs-object-util.sql:74: ERROR: function "acs_object_util__object_ancestor_type_p" already exists with same argument types psql:acs-object-util.sql:86: ERROR: function "acs_object_util__object_type_p" already exists with same argument types psql:acs-relationships-create.sql:22: ERROR: relation "acs_rel_roles" already exists psql:acs-relationships-create.sql:55: ERROR: relation "acs_rel_types" already exists psql:acs-relationships-create.sql:57: ERROR: relation "acs_rel_types_objtypeone_idx" already exists psql:acs-relationships-create.sql:58: ERROR: relation "acs_rel_types_role_one_idx" already exists psql:acs-relationships-create.sql:59: ERROR: relation "acs_rel_types_objtypetwo_idx" already exists psql:acs-relationships-create.sql:60: ERROR: relation "acs_rel_types_role_two_idx" already exists psql:acs-relationships-create.sql:97: ERROR: function "acs_rel_type__create_role" already exists with same argument types psql:acs-relationships-create.sql:106: ERROR: function "acs_rel_type__create_role" already exists with same argument types psql:acs-relationships-create.sql:119: ERROR: function "acs_rel_type__drop_role" already exists with same argument types psql:acs-relationships-create.sql:135: ERROR: function "acs_rel_type__role_pretty_name" already exists with same argument types psql:acs-relationships-create.sql:151: ERROR: function "acs_rel_type__role_pretty_plural" already exists with same argument types psql:acs-relationships-create.sql:205: ERROR: function "acs_rel_type__create_type" already exists with same argument types psql:acs-relationships-create.sql:261: ERROR: function "acs_rel_type__create_type" already exists with same argument types psql:acs-relationships-create.sql:279: ERROR: function "acs_rel_type__drop_type" already exists with same argument types psql:acs-relationships-create.sql:299: ERROR: duplicate key violates unique constraint "acs_object_types_pk" CONTEXT: PL/pgSQL function "acs_object_type__create_type" line 37 at SQL statement PL/pgSQL function "acs_rel_type__create_type" line 23 at perform psql:acs-relationships-create.sql:308: ERROR: relation "t_acs_rel_id_seq" already exists psql:acs-relationships-create.sql:310: ERROR: relation "acs_rel_id_seq" already exists psql:acs-relationships-create.sql:328: ERROR: relation "acs_rels" already exists psql:acs-relationships-create.sql:330: ERROR: relation "acs_rels_object_id_one_idx" already exists psql:acs-relationships-create.sql:331: ERROR: relation "acs_rels_object_id_two_idx" already exists psql:acs-relationships-create.sql:405: ERROR: function "acs_rels_in_tr" already exists with same argument types psql:acs-relationships-create.sql:408: ERROR: trigger "acs_rels_in_tr" for relation "acs_rels" already exists psql:acs-relationships-create.sql:466: ERROR: function "acs_rel__new" already exists with same argument types psql:acs-relationships-create.sql:478: ERROR: function "acs_rel__delete" already exists with same argument types psql:acs-relationships-create.sql:505: ERROR: relation "rel_types_valid_obj_one_types" already exists psql:acs-relationships-create.sql:526: ERROR: relation "rel_types_valid_obj_two_types" already exists psql:utilities-create.sql:53: ERROR: function "util__multiple_nextval" already exists with same argument types psql:utilities-create.sql:71: ERROR: function "rawtohex" already exists with same argument types psql:utilities-create.sql:80: ERROR: function "util__computehash_raw" already exists with same argument types psql:utilities-create.sql:93: ERROR: function "util__computehash" already exists with same argument types psql:utilities-create.sql:107: ERROR: function "util__logical_negation" already exists with same argument types psql:community-core-create.sql:237: ERROR: duplicate key violates unique constraint "acs_object_types_pk" CONTEXT: PL/pgSQL function "acs_object_type__create_type" line 37 at SQL statement PL/pgSQL function "inline_0" line 7 at perform psql:community-core-create.sql:256: ERROR: relation "parties" already exists psql:community-core-create.sql:296: ERROR: function "party__new" already exists with same argument types psql:community-core-create.sql:306: ERROR: function "party__delete" already exists with same argument types psql:community-core-create.sql:319: ERROR: function "party__name" already exists with same argument types psql:community-core-create.sql:334: ERROR: function "party__email" already exists with same argument types psql:community-core-create.sql:349: ERROR: relation "persons" already exists psql:community-core-create.sql:421: ERROR: function "person__new" already exists with same argument types psql:community-core-create.sql:436: ERROR: function "person__delete" already exists with same argument types psql:community-core-create.sql:453: ERROR: function "person__name" already exists with same argument types psql:community-core-create.sql:470: ERROR: function "person__first_names" already exists with same argument types psql:community-core-create.sql:487: ERROR: function "person__last_name" already exists with same argument types psql:community-core-create.sql:512: ERROR: relation "users" already exists psql:community-core-create.sql:524: ERROR: relation "user_preferences" already exists psql:community-core-create.sql:537: ERROR: duplicate key violates unique constraint "acs_object_type_tables_pk" CONTEXT: PL/pgSQL function "inline_1" line 3 at SQL statement psql:community-core-create.sql:547: ERROR: constraint "acs_objects_creation_user_fk" for relation "acs_objects" already exists psql:community-core-create.sql:550: ERROR: constraint "acs_objects_modifying_user_fk" for relation "acs_objects" already exists psql:community-core-create.sql:683: ERROR: function "acs_user__new" already exists with same argument types psql:community-core-create.sql:713: ERROR: function "acs_user__new" already exists with same argument types psql:community-core-create.sql:730: ERROR: function "acs_user__receives_alerts_p" already exists with same argument types psql:community-core-create.sql:744: ERROR: function "acs_user__approve_email" already exists with same argument types psql:community-core-create.sql:758: ERROR: function "acs_user__unapprove_email" already exists with same argument types psql:community-core-create.sql:776: ERROR: function "acs_user__delete" already exists with same argument types psql:groups-create.sql:24: ERROR: relation "composition_rels" already exists psql:groups-create.sql:35: ERROR: relation "membership_rels" already exists psql:groups-create.sql:125: ERROR: duplicate key violates unique constraint "acs_object_types_pk" CONTEXT: PL/pgSQL function "acs_object_type__create_type" line 37 at SQL statement PL/pgSQL function "inline_0" line 7 at assignment psql:groups-create.sql:143: ERROR: relation "group_types" already exists psql:groups-create.sql:160: ERROR: relation "groups" already exists psql:groups-create.sql:175: ERROR: relation "group_type_rels" already exists psql:groups-create.sql:178: ERROR: relation "group_type_rels_rel_type_idx" already exists psql:groups-create.sql:199: ERROR: relation "group_rels" already exists psql:groups-create.sql:202: ERROR: relation "group_rels_rel_type_idx" already exists psql:groups-create.sql:261: ERROR: relation "group_element_index" already exists psql:groups-create.sql:263: ERROR: relation "group_elem_idx_group_idx" already exists psql:groups-create.sql:264: ERROR: relation "group_elem_idx_element_idx" already exists psql:groups-create.sql:265: ERROR: relation "group_elem_idx_rel_id_idx" already exists psql:groups-create.sql:266: ERROR: relation "group_elem_idx_container_idx" already exists psql:groups-create.sql:267: ERROR: relation "group_elem_idx_rel_type_idx" already exists psql:groups-create.sql:285: ERROR: relation "group_element_map" already exists psql:groups-create.sql:290: ERROR: relation "group_component_map" already exists psql:groups-create.sql:295: ERROR: relation "group_member_map" already exists psql:groups-create.sql:301: ERROR: relation "group_approved_member_map" already exists psql:groups-create.sql:305: ERROR: relation "group_distinct_member_map" already exists psql:groups-create.sql:312: ERROR: relation "group_component_index" already exists psql:groups-create.sql:313: ERROR: relation "group_member_index" already exists psql:groups-create.sql:355: ERROR: function "group_contains_p" already exists with same argument types psql:groups-create.sql:378: ERROR: function "membership_rels_in_tr" already exists with same argument types psql:groups-create.sql:381: ERROR: trigger "membership_rels_in_tr" for relation "membership_rels" already exists psql:groups-create.sql:393: ERROR: function "composition_rels_in_tr" already exists with same argument types psql:groups-create.sql:396: ERROR: trigger "composition_rels_in_tr" for relation "composition_rels" already exists psql:groups-create.sql:409: ERROR: duplicate key violates unique constraint "gtr_group_rel_types_un" psql:groups-create.sql:414: ERROR: duplicate key violates unique constraint "gtr_group_rel_types_un" psql:rel-segments-create.sql:42: ERROR: duplicate key violates unique constraint "acs_object_types_pk" CONTEXT: PL/pgSQL function "acs_object_type__create_type" line 37 at SQL statement PL/pgSQL function "inline_0" line 7 at perform psql:rel-segments-create.sql:69: ERROR: relation "rel_segments" already exists psql:rel-segments-create.sql:72: ERROR: relation "rel_segments_rel_type_idx" already exists psql:rel-segments-create.sql:106: ERROR: relation "rel_segment_party_map" already exists psql:rel-segments-create.sql:110: ERROR: relation "rel_segment_distinct_party_map" already exists psql:rel-segments-create.sql:116: ERROR: relation "rel_segment_member_map" already exists psql:rel-segments-create.sql:127: ERROR: relation "rel_seg_approved_member_map" already exists psql:rel-segments-create.sql:131: ERROR: relation "rel_seg_distinct_member_map" already exists psql:rel-segments-create.sql:174: ERROR: relation "party_approved_member_map" already exists psql:rel-segments-create.sql:177: ERROR: relation "party_member_member_idx" already exists psql:rel-segments-create.sql:285: ERROR: cannot change return type of existing function HINT: Use DROP FUNCTION first. psql:rel-segments-create.sql:288: ERROR: trigger "parties_in_tr" for relation "parties" already exists psql:rel-segments-create.sql:299: ERROR: cannot change return type of existing function HINT: Use DROP FUNCTION first. psql:rel-segments-create.sql:302: ERROR: trigger "parties_del_tr" for relation "parties" already exists psql:rel-segments-create.sql:322: ERROR: cannot change return type of existing function HINT: Use DROP FUNCTION first. psql:rel-segments-create.sql:325: ERROR: trigger "rel_segments_in_tr" for relation "rel_segments" already exists psql:rel-segments-create.sql:339: ERROR: cannot change return type of existing function HINT: Use DROP FUNCTION first. psql:rel-segments-create.sql:342: ERROR: trigger "rel_segments_del_tr" for relation "rel_segments" already exists psql:rel-segments-create.sql:367: ERROR: relation "rel_segment_group_rel_type_map" already exists psql:rel-constraints-create.sql:39: ERROR: duplicate key violates unique constraint "acs_object_types_pk" CONTEXT: PL/pgSQL function "acs_object_type__create_type" line 37 at SQL statement PL/pgSQL function "inline_0" line 2 at perform psql:rel-constraints-create.sql:66: ERROR: relation "rel_constraints" already exists psql:rel-constraints-create.sql:69: ERROR: relation "rel_constraint_req_rel_seg_idx" already exists psql:rel-constraints-create.sql:134: ERROR: relation "constrained_rels1" already exists psql:rel-constraints-create.sql:141: ERROR: relation "rel_constraints_violated_one" already exists psql:rel-constraints-create.sql:176: ERROR: relation "constrained_rels2" already exists psql:rel-constraints-create.sql:184: ERROR: relation "rel_constraints_violated_two" already exists psql:rel-constraints-create.sql:226: ERROR: relation "rc_all_constraints" already exists psql:rel-constraints-create.sql:232: ERROR: relation "rc_all_distinct_constraints" already exists psql:rel-constraints-create.sql:255: ERROR: relation "rc_required_rel_segments" already exists psql:rel-constraints-create.sql:277: ERROR: relation "comp_or_member_rel_types" already exists psql:rel-constraints-create.sql:281: ERROR: relation "group_rel_type_combos" already exists psql:rel-constraints-create.sql:295: ERROR: relation "parties_in_required_segs" already exists psql:rel-constraints-create.sql:300: ERROR: relation "total_num_required_segs" already exists psql:rel-constraints-create.sql:323: ERROR: relation "rc_parties_in_required_segs" already exists psql:rel-constraints-create.sql:385: ERROR: relation "side_one_constraints" already exists psql:rel-constraints-create.sql:391: ERROR: relation "total_side_one_constraints" already exists psql:rel-constraints-create.sql:394: ERROR: relation "rc_all_constraints_view" already exists psql:rel-constraints-create.sql:411: ERROR: relation "rc_valid_rel_types" already exists psql:rel-constraints-create.sql:444: ERROR: relation "rc_violations_by_removing_rel" already exists psql:rel-constraints-create.sql:494: ERROR: relation "rc_segment_required_seg_map" already exists psql:rel-constraints-create.sql:497: ERROR: relation "rc_segment_required_seg_idx" already exists psql:rel-constraints-create.sql:536: ERROR: function "rel_constraints_ins_tr" already exists with same argument types psql:rel-constraints-create.sql:540: ERROR: trigger "rel_constraints_ins_tr" for relation "rel_constraints" already exists psql:rel-constraints-create.sql:586: ERROR: function "rel_constraints_del_tr" already exists with same argument types psql:rel-constraints-create.sql:590: ERROR: trigger "rel_constraints_del_tr" for relation "rel_constraints" already exists psql:rel-constraints-create.sql:642: ERROR: relation "rc_segment_dependency_levels" already exists psql:acs-permissions-create.sql:26: ERROR: relation "acs_privileges" already exists psql:acs-permissions-create.sql:37: ERROR: relation "acs_privilege_hierarchy" already exists psql:acs-permissions-create.sql:39: ERROR: relation "acs_priv_hier_child_priv_idx" already exists psql:acs-permissions-create.sql:49: ERROR: relation "acs_privilege_hierarchy_index" already exists psql:acs-permissions-create.sql:52: ERROR: relation "priv_hier_sortkey_idx" already exists psql:acs-permissions-create.sql:67: ERROR: relation "acs_privilege_descendant_map" already exists psql:acs-permissions-create.sql:72: ERROR: relation "acs_priv_desc_map_idx" already exists psql:acs-permissions-create.sql:180: ERROR: cannot change return type of existing function HINT: Use DROP FUNCTION first. psql:acs-permissions-create.sql:184: ERROR: trigger "acs_priv_hier_ins_del_tr" for relation "acs_privilege_hierarchy" already exists psql:acs-permissions-create.sql:194: ERROR: cannot change return type of existing function HINT: Use DROP FUNCTION first. psql:acs-permissions-create.sql:198: ERROR: trigger "acs_priv_del_tr" for relation "acs_privileges" already exists psql:acs-permissions-create.sql:253: ERROR: function "priv_recurse_subtree" already exists with same argument types psql:acs-permissions-create.sql:282: ERROR: function "acs_privilege__create_privilege" already exists with same argument types psql:acs-permissions-create.sql:290: ERROR: function "acs_privilege__create_privilege" already exists with same argument types psql:acs-permissions-create.sql:302: ERROR: function "acs_privilege__drop_privilege" already exists with same argument types psql:acs-permissions-create.sql:316: ERROR: function "acs_privilege__add_child" already exists with same argument types psql:acs-permissions-create.sql:329: ERROR: function "acs_privilege__remove_child" already exists with same argument types psql:acs-permissions-create.sql:348: ERROR: relation "acs_permissions" already exists psql:acs-permissions-create.sql:350: ERROR: relation "acs_permissions_grantee_idx" already exists psql:acs-permissions-create.sql:351: ERROR: relation "acs_permissions_privilege_idx" already exists psql:acs-permissions-create.sql:369: ERROR: relation "acs_privilege_descendant_map_view" already exists psql:acs-permissions-create.sql:374: ERROR: relation "acs_permissions_all" already exists psql:acs-permissions-create.sql:379: ERROR: relation "acs_object_grantee_priv_map" already exists psql:acs-permissions-create.sql:389: ERROR: relation "acs_object_party_privilege_map" already exists psql:acs-permissions-create.sql:392: ERROR: relation "all_object_party_privilege_map" already exists psql:acs-permissions-create.sql:408: ERROR: relation "acs_permissions_lock" already exists psql:acs-permissions-create.sql:414: ERROR: function "acs_permissions_lock_tr" already exists with same argument types psql:acs-permissions-create.sql:418: ERROR: trigger "acs_permissions_lock_tr" for relation "acs_permissions_lock" already exists psql:acs-permissions-create.sql:451: ERROR: function "acs_permission__grant_permission" already exists with same argument types psql:acs-permissions-create.sql:470: ERROR: function "acs_permission__revoke_permission" already exists with same argument types psql:groups-body-create.sql:86: WARNING: changing return type of function membership_rels_in_tr from "opaque" to "trigger" psql:groups-body-create.sql:110: ERROR: cannot change return type of existing function HINT: Use DROP FUNCTION first. psql:groups-body-create.sql:113: ERROR: trigger "membership_rels_up_tr" for relation "membership_rels" already exists psql:groups-body-create.sql:138: ERROR: cannot change return type of existing function HINT: Use DROP FUNCTION first. psql:groups-body-create.sql:141: ERROR: trigger "membership_rels_del_tr" for relation "membership_rels" already exists psql:groups-body-create.sql:250: WARNING: changing return type of function composition_rels_in_tr from "opaque" to "trigger" psql:groups-body-create.sql:347: ERROR: cannot change return type of existing function HINT: Use DROP FUNCTION first. psql:groups-body-create.sql:350: ERROR: trigger "composition_rels_del_tr" for relation "composition_rels" already exists psql:rel-segments-body-create.sql:45: ERROR: function "rel_segment__new" already exists with same argument types psql:rel-segments-body-create.sql:61: ERROR: function "rel_segment__new" already exists with same argument types psql:rel-segments-body-create.sql:85: ERROR: function "rel_segment__delete" already exists with same argument types psql:rel-segments-body-create.sql:103: ERROR: function "rel_segment__get" already exists with same argument types psql:rel-segments-body-create.sql:111: ERROR: function "rel_segment__get_or_new" already exists with same argument types psql:rel-segments-body-create.sql:159: ERROR: function "rel_segment__get_or_new" already exists with same argument types psql:rel-segments-body-create.sql:176: ERROR: function "rel_segment__name" already exists with same argument types psql:rel-constraints-body-create.sql:36: ERROR: function "rel_constraint__new" already exists with same argument types psql:rel-constraints-body-create.sql:71: ERROR: function "rel_constraint__new" already exists with same argument types psql:rel-constraints-body-create.sql:83: ERROR: function "rel_constraint__delete" already exists with same argument types psql:rel-constraints-body-create.sql:103: ERROR: function "rel_constraint__get_constraint_id" already exists with same argument types psql:rel-constraints-body-create.sql:151: ERROR: function "rel_constraint__violation" already exists with same argument types psql:rel-constraints-body-create.sql:191: ERROR: function "rel_constraint__violation_if_removed" already exists with same argument types psql:security-create.sql:30: ERROR: relation "sec_session_properties" already exists psql:security-create.sql:32: ERROR: relation "sec_property_names" already exists psql:security-create.sql:39: ERROR: relation "secret_tokens" already exists psql:security-create.sql:41: ERROR: relation "t_sec_security_token_id_seq" already exists psql:security-create.sql:43: ERROR: relation "sec_security_token_id_seq" already exists psql:security-create.sql:49: ERROR: relation "t_sec_id_seq" already exists psql:security-create.sql:51: ERROR: relation "sec_id_seq" already exists psql:journal-create.sql:35: ERROR: duplicate key violates unique constraint "acs_object_types_pk" CONTEXT: PL/pgSQL function "acs_object_type__create_type" line 37 at SQL statement PL/pgSQL function "inline_0" line 2 at perform psql:journal-create.sql:53: ERROR: relation "journal_entries" already exists psql:journal-create.sql:55: ERROR: relation "journal_entries_object_idx" already exists psql:journal-create.sql:122: ERROR: function "journal_entry__new" already exists with same argument types psql:journal-create.sql:135: ERROR: function "journal_entry__delete" already exists with same argument types psql:journal-create.sql:153: ERROR: function "journal_entry__delete_for_object" already exists with same argument types psql:site-nodes-create.sql:30: ERROR: duplicate key violates unique constraint "acs_object_types_pk" CONTEXT: PL/pgSQL function "acs_object_type__create_type" line 37 at SQL statement PL/pgSQL function "inline_0" line 4 at perform psql:site-nodes-create.sql:59: ERROR: relation "site_nodes" already exists psql:site-nodes-create.sql:61: ERROR: relation "site_nodes_object_id_idx" already exists psql:site-nodes-create.sql:62: ERROR: relation "site_nodes_parent_id_idx" already exists psql:site-nodes-create.sql:63: ERROR: relation "site_nodes_tree_skey_idx" already exists psql:site-nodes-create.sql:70: ERROR: function "site_node_get_tree_sortkey" already exists with same argument types psql:site-nodes-create.sql:95: ERROR: function "site_node_insert_tr" already exists with same argument types psql:site-nodes-create.sql:99: ERROR: trigger "site_node_insert_tr" for relation "site_nodes" already exists psql:site-nodes-create.sql:154: ERROR: function "site_node_update_tr" already exists with same argument types psql:site-nodes-create.sql:159: ERROR: trigger "site_node_update_tr" for relation "site_nodes" already exists psql:site-nodes-create.sql:249: ERROR: function "site_node__new" already exists with same argument types psql:site-nodes-create.sql:264: ERROR: function "site_node__delete" already exists with same argument types psql:site-nodes-create.sql:290: ERROR: function "site_node__find_pattern" already exists with same argument types psql:site-nodes-create.sql:351: ERROR: function "site_node__node_id" already exists with same argument types psql:site-nodes-create.sql:378: ERROR: function "site_node__url" already exists with same argument types psql:site-node-object-map-create.sql:21: ERROR: relation "site_node_object_mappings" already exists psql:site-node-object-map-create.sql:41: ERROR: function "site_node_object_map__new" already exists with same argument types psql:site-node-object-map-create.sql:56: ERROR: function "site_node_object_map__del" already exists with same argument types psql:apm-create.sql:37: ERROR: relation "apm_package_types" already exists psql:apm-create.sql:97: ERROR: duplicate key violates unique constraint "acs_object_types_pk" CONTEXT: PL/pgSQL function "acs_object_type__create_type" line 37 at SQL statement PL/pgSQL function "inline_0" line 3 at perform psql:apm-create.sql:209: ERROR: duplicate key violates unique constraint "acs_attributes_attr_name_un" CONTEXT: PL/pgSQL function "acs_attribute__create_attribute" line 30 at SQL statement PL/pgSQL function "inline_1" line 5 at assignment psql:apm-create.sql:225: ERROR: relation "apm_packages" already exists psql:apm-create.sql:227: ERROR: relation "apm_packages_package_key_idx" already exists psql:apm-create.sql:245: ERROR: column "enabled_p" of relation "apm_packages" does not exist psql:apm-create.sql:298: ERROR: relation "apm_package_versions" already exists psql:apm-create.sql:651: ERROR: duplicate key violates unique constraint "acs_object_types_pk" CONTEXT: PL/pgSQL function "acs_object_type__create_type" line 37 at SQL statement PL/pgSQL function "inline_2" line 4 at assignment psql:apm-create.sql:666: ERROR: relation "apm_package_owners" already exists psql:apm-create.sql:668: ERROR: relation "apm_pkg_owners_version_idx" already exists psql:apm-create.sql:684: ERROR: relation "apm_package_callbacks" already exists psql:apm-create.sql:714: ERROR: relation "apm_package_version_info" already exists psql:apm-create.sql:720: ERROR: relation "apm_enabled_package_versions" already exists psql:apm-create.sql:727: ERROR: relation "apm_package_file_types" already exists psql:apm-create.sql:757: ERROR: duplicate key violates unique constraint "apm_package_file_types_pk" CONTEXT: PL/pgSQL function "inline_3" line 2 at SQL statement psql:apm-create.sql:766: ERROR: relation "apm_package_db_types" already exists psql:apm-create.sql:792: ERROR: relation "apm_package_files" already exists psql:apm-create.sql:794: ERROR: relation "apm_pkg_files_file_type_idx" already exists psql:apm-create.sql:795: ERROR: relation "apm_pkg_files_db_type_idx" already exists psql:apm-create.sql:822: ERROR: relation "apm_file_info" already exists psql:apm-create.sql:851: ERROR: relation "apm_parameters" already exists psql:apm-create.sql:853: ERROR: relation "apm_parameters_package_idx" already exists psql:apm-create.sql:905: ERROR: relation "apm_parameter_values" already exists psql:apm-create.sql:907: ERROR: relation "apm_par_vals_parameter_idx" already exists psql:apm-create.sql:1036: ERROR: duplicate key violates unique constraint "acs_object_types_pk" CONTEXT: PL/pgSQL function "acs_object_type__create_type" line 37 at SQL statement PL/pgSQL function "inline_4" line 4 at assignment psql:apm-create.sql:1113: ERROR: duplicate key violates unique constraint "acs_object_types_pk" CONTEXT: PL/pgSQL function "acs_object_type__create_type" line 37 at SQL statement PL/pgSQL function "inline_5" line 4 at assignment psql:apm-create.sql:1133: ERROR: relation "apm_package_dependencies" already exists psql:apm-create.sql:1149: ERROR: relation "apm_applications" already exists psql:apm-create.sql:1161: ERROR: relation "apm_services" already exists psql:apm-create.sql:1190: ERROR: duplicate key violates unique constraint "acs_object_types_pk" CONTEXT: PL/pgSQL function "acs_object_type__create_type" line 37 at SQL statement PL/pgSQL function "inline_6" line 5 at assignment psql:apm-create.sql:1220: ERROR: duplicate key violates unique constraint "acs_object_types_pk" CONTEXT: PL/pgSQL function "acs_object_type__create_type" line 37 at SQL statement PL/pgSQL function "inline_7" line 5 at assignment psql:apm-create.sql:1250: ERROR: function "apm__register_package" already exists with same argument types psql:apm-create.sql:1280: ERROR: function "apm__update_package" already exists with same argument types psql:apm-create.sql:1296: ERROR: function "apm__unregister_package" already exists with same argument types psql:apm-create.sql:1312: ERROR: function "apm__register_p" already exists with same argument types psql:apm-create.sql:1341: ERROR: function "apm__register_application" already exists with same argument types psql:apm-create.sql:1357: ERROR: function "apm__unregister_application" already exists with same argument types psql:apm-create.sql:1386: ERROR: function "apm__register_service" already exists with same argument types psql:apm-create.sql:1402: ERROR: function "apm__unregister_service" already exists with same argument types psql:apm-create.sql:1459: ERROR: function "apm__register_parameter" already exists with same argument types psql:apm-create.sql:1487: ERROR: function "apm__update_parameter" already exists with same argument types psql:apm-create.sql:1505: ERROR: function "apm__parameter_p" already exists with same argument types psql:apm-create.sql:1521: ERROR: function "apm__unregister_parameter" already exists with same argument types psql:apm-create.sql:1539: ERROR: function "apm__id_for_name" already exists with same argument types psql:apm-create.sql:1556: ERROR: function "apm__get_value" already exists with same argument types psql:apm-create.sql:1577: ERROR: function "apm__get_value" already exists with same argument types psql:apm-create.sql:1608: ERROR: function "apm__set_value" already exists with same argument types psql:apm-create.sql:1638: ERROR: function "apm__set_value" already exists with same argument types psql:apm-create.sql:1668: ERROR: function "apm_package__initialize_parameters" already exists with same argument types psql:apm-create.sql:1746: ERROR: function "apm_package__new" already exists with same argument types psql:apm-create.sql:1773: ERROR: function "apm_package__delete" already exists with same argument types psql:apm-create.sql:1790: ERROR: function "apm_package__initial_install_p" already exists with same argument types psql:apm-create.sql:1807: ERROR: function "apm_package__singleton_p" already exists with same argument types psql:apm-create.sql:1825: ERROR: function "apm_package__num_instances" already exists with same argument types psql:apm-create.sql:1838: ERROR: function "apm_package__name" already exists with same argument types psql:apm-create.sql:1849: ERROR: function "apm_package__enable" already exists with same argument types psql:apm-create.sql:1860: ERROR: function "apm_package__disable" already exists with same argument types psql:apm-create.sql:1878: ERROR: function "apm_package__highest_version" already exists with same argument types psql:apm-create.sql:1897: ERROR: function "apm_package__parent_id" already exists with same argument types psql:apm-create.sql:1946: ERROR: function "apm_package_version__new" already exists with same argument types psql:apm-create.sql:1970: ERROR: function "apm_package_version__delete" already exists with same argument types psql:apm-create.sql:1983: ERROR: function "apm_package_version__enable" already exists with same argument types psql:apm-create.sql:1997: ERROR: function "apm_package_version__disable" already exists with same argument types psql:apm-create.sql:2053: ERROR: function "apm_package_version__copy" already exists with same argument types psql:apm-create.sql:2108: ERROR: function "apm_package_version__edit" already exists with same argument types psql:apm-create.sql:2143: ERROR: function "apm_package_version__add_file" already exists with same argument types psql:apm-create.sql:2158: ERROR: function "apm_package_version__remove_file" already exists with same argument types psql:apm-create.sql:2185: ERROR: function "apm_package_version__add_interface" already exists with same argument types psql:apm-create.sql:2198: ERROR: function "apm_package_version__remove_interface" already exists with same argument types psql:apm-create.sql:2216: ERROR: function "apm_package_version__remove_interface" already exists with same argument types psql:apm-create.sql:2243: ERROR: function "apm_package_version__add_dependency" already exists with same argument types psql:apm-create.sql:2256: ERROR: function "apm_package_version__remove_dependency" already exists with same argument types psql:apm-create.sql:2274: ERROR: function "apm_package_version__remove_dependency" already exists with same argument types psql:apm-create.sql:2350: ERROR: function "apm_package_version__sortable_version_name" already exists with same argument types psql:apm-create.sql:2370: ERROR: function "apm_package_version__version_name_greater" already exists with same argument types psql:apm-create.sql:2417: ERROR: function "apm_package_version__upgrade_p" already exists with same argument types psql:apm-create.sql:2437: ERROR: function "apm_package_version__upgrade" already exists with same argument types psql:apm-create.sql:2467: ERROR: function "apm_package_type__create_type" already exists with same argument types psql:apm-create.sql:2497: ERROR: function "apm_package_type__update_type" already exists with same argument types psql:apm-create.sql:2535: ERROR: function "apm_package_type__drop_type" already exists with same argument types psql:apm-create.sql:2551: ERROR: function "apm_package_type__num_parameters" already exists with same argument types psql:apm-create.sql:2585: ERROR: function "apm_parameter_value__new" already exists with same argument types psql:apm-create.sql:2599: ERROR: function "apm_parameter_value__delete" already exists with same argument types psql:apm-create.sql:2629: ERROR: function "apm_application__new" already exists with same argument types psql:apm-create.sql:2645: ERROR: function "apm_application__delete" already exists with same argument types psql:apm-create.sql:2679: ERROR: function "apm_service__new" already exists with same argument types psql:apm-create.sql:2695: ERROR: function "apm_service__delete" already exists with same argument types psql:acs-create.sql:14: ERROR: relation "acs_magic_objects" already exists psql:acs-create.sql:16: ERROR: relation "acs_mo_object_id_idx" already exists psql:acs-create.sql:74: ERROR: function "acs__add_user" already exists with same argument types psql:acs-create.sql:85: ERROR: function "acs__remove_user" already exists with same argument types psql:acs-create.sql:100: ERROR: function "acs__magic_object_id" already exists with same argument types psql:acs-create.sql:117: ERROR: relation "registered_users" already exists psql:acs-create.sql:130: ERROR: relation "cc_users" already exists psql:acs-create.sql:165: ERROR: duplicate key violates unique constraint "acs_objects_pk" CONTEXT: PL/pgSQL function "acs_object__new" line 24 at SQL statement PL/pgSQL function "inline_0" line 5 at assignment psql:acs-create.sql:178: ERROR: duplicate key violates unique constraint "acs_privileges_pk" CONTEXT: PL/pgSQL function "acs_privilege__create_privilege" line 6 at SQL statement psql:acs-create.sql:179: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:acs-create.sql:180: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:acs-create.sql:181: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:acs-create.sql:182: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:acs-create.sql:188: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:acs-create.sql:189: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:acs-create.sql:190: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:acs-create.sql:191: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:acs-create.sql:261: ERROR: duplicate key violates unique constraint "acs_objects_pk" CONTEXT: PL/pgSQL function "inline_2" line 8 at SQL statement psql:acs-create.sql:306: ERROR: duplicate key violates unique constraint "acs_objects_pk" CONTEXT: PL/pgSQL function "acs_object__new" line 24 at SQL statement PL/pgSQL function "party__new" line 12 at assignment PL/pgSQL function "acs_group__new" line 16 at assignment PL/pgSQL function "inline_3" line 8 at assignment psql:acs-create.sql:317: ERROR: duplicate key violates unique constraint "acs_objects_pk" CONTEXT: PL/pgSQL function "acs_object__new" line 24 at SQL statement psql:acs-create.sql:322: ERROR: duplicate key violates unique constraint "acs_magic_objects_pk" psql:acs-create-2.sql:16: ERROR: duplicate key violates unique constraint "acs_privileges_pk" CONTEXT: PL/pgSQL function "acs_privilege__create_privilege" line 6 at SQL statement PL/pgSQL function "acs_privilege__create_privilege" line 4 at return psql:acs-create-2.sql:17: ERROR: duplicate key violates unique constraint "acs_privilege_hierarchy_pk" CONTEXT: PL/pgSQL function "acs_privilege__add_child" line 5 at SQL statement

NOTE: If the error comes from a sql script you may try to source it manually. When you are done with that you should revisit the APM and try again but remember to leave the manually souced sql scipts unchecked on the previous page.

Installing Search 4.6

# Installing data model for Search 4.6...

* Loading data model /web/dotlrn/packages/search/sql/postgresql/search-create.sql...

acs_sc_operation__new
-----------------------
766
(1 row)
acs_sc_operation__new
-----------------------
769
(1 row)
acs_sc_operation__new
-----------------------
772
(1 row)
acs_sc_operation__new
-----------------------
775
(1 row)
acs_sc_operation__new
-----------------------
778
(1 row)
acs_sc_operation__new
-----------------------
781
(1 row)
acs_sc_operation__new
-----------------------
785
(1 row)
acs_sc_operation__new
-----------------------
788
(1 row)

Failed to install Search, version 4.6. The following error was generated:

psql:search-tables-create.sql:7: ERROR: relation "search_observer_queue" already exists psql:search-packages-create.sql:21: ERROR: function "search_observer__enqueue" already exists with same argument types psql:search-packages-create.sql:39: ERROR: function "search_observer__dequeue" already exists with same argument types CONTEXT: PL/pgSQL function "acs_object__new" line 12 at select into variables PL/pgSQL function "acs_sc_contract__new" line 7 at assignment psql:search-sc-create.sql:8: ERROR: duplicate key violates unique constraint "acs_sc_contracts_name_un" CONTEXT: PL/pgSQL function "acs_sc_contract__new" line 16 at SQL statement psql:search-sc-create.sql:14: ERROR: duplicate key violates unique constraint "acs_sc_msg_types_name_un" CONTEXT: PL/pgSQL function "acs_sc_msg_type__new" line 16 at SQL statement psql:search-sc-create.sql:18: ERROR: duplicate key violates unique constraint "acs_sc_msg_types_name_un" CONTEXT: PL/pgSQL function "acs_sc_msg_type__new" line 16 at SQL statement psql:search-sc-create.sql:34: ERROR: duplicate key violates unique constraint "acs_sc_msg_types_name_un" CONTEXT: PL/pgSQL function "acs_sc_msg_type__new" line 16 at SQL statement psql:search-sc-create.sql:38: ERROR: duplicate key violates unique constraint "acs_sc_msg_types_name_un" CONTEXT: PL/pgSQL function "acs_sc_msg_type__new" line 16 at SQL statement psql:search-sc-create.sql:54: ERROR: duplicate key violates unique constraint "acs_sc_msg_types_name_un" CONTEXT: PL/pgSQL function "acs_sc_msg_type__new" line 16 at SQL statement psql:search-sc-create.sql:58: ERROR: duplicate key violates unique constraint "acs_sc_msg_types_name_un" CONTEXT: PL/pgSQL function "acs_sc_msg_type__new" line 16 at SQL statement psql:search-sc-create.sql:74: ERROR: duplicate key violates unique constraint "acs_sc_msg_types_name_un" CONTEXT: PL/pgSQL function "acs_sc_msg_type__new" line 16 at SQL statement psql:search-sc-create.sql:78: ERROR: duplicate key violates unique constraint "acs_sc_msg_types_name_un" CONTEXT: PL/pgSQL function "acs_sc_msg_type__new" line 16 at SQL statement psql:search-sc-create.sql:94: ERROR: duplicate key violates unique constraint "acs_sc_msg_types_name_un" CONTEXT: PL/pgSQL function "acs_sc_msg_type__new" line 16 at SQL statement psql:search-sc-create.sql:98: ERROR: duplicate key violates unique constraint "acs_sc_msg_types_name_un" CONTEXT: PL/pgSQL function "acs_sc_msg_type__new" line 16 at SQL statement psql:search-sc-create.sql:113: ERROR: duplicate key violates unique constraint "acs_sc_msg_types_name_un" CONTEXT: PL/pgSQL function "acs_sc_msg_type__new" line 16 at SQL statement psql:search-sc-create.sql:117: ERROR: duplicate key violates unique constraint "acs_sc_msg_types_name_un" CONTEXT: PL/pgSQL function "acs_sc_msg_type__new" line 16 at SQL statement psql:search-sc-create.sql:136: ERROR: duplicate key violates unique constraint "acs_sc_contracts_name_un" CONTEXT: PL/pgSQL function "acs_sc_contract__new" line 16 at SQL statement psql:search-sc-create.sql:141: ERROR: duplicate key violates unique constraint "acs_sc_msg_types_name_un" CONTEXT: PL/pgSQL function "acs_sc_msg_type__new" line 16 at SQL statement psql:search-sc-create.sql:145: ERROR: duplicate key violates unique constraint "acs_sc_msg_types_name_un" CONTEXT: PL/pgSQL function "acs_sc_msg_type__new" line 16 at SQL statement psql:search-sc-create.sql:161: ERROR: duplicate key violates unique constraint "acs_sc_msg_types_name_un" CONTEXT: PL/pgSQL function "acs_sc_msg_type__new" line 16 at SQL statement psql:search-sc-create.sql:165: ERROR: duplicate key violates unique constraint "acs_sc_msg_types_name_un" CONTEXT: PL/pgSQL function "acs_sc_msg_type__new" line 16 at SQL statement

NOTE: If the error comes from a sql script you may try to source it manually. When you are done with that you should revisit the APM and try again but remember to leave the manually souced sql scipts unchecked on the previous page.

* Completing Install sequence by mounting the main site and other core packages.

CREATE FUNCTION
DROP FUNCTION