Menu
▾
▴
#991 ERROR: relation "im_ticket_priority_map_seq" already exists
http://localhost:8000/acs-admin/apm/packages-install-4
Failed to install ]project-open[ Service Level Agreement Management, version 5.0.2.4.0. The following error was generated:
psql:/web/projop/packages/intranet-sla-management/sql/postgresql/intranet-sla-management-create.sql:105: ERROR: relation "im_ticket_priority_map_seq" already exists
CONTEXT: SQL statement "create sequence im_ticket_priority_map_seq"
PL/pgSQL function inline_0() line 14 at SQL statement
System: Debian 9 (Strech), psql (PostgreSQL) 9.6.10
Discussion
Anonymous
The first one error message comes after SLA Management package new install.
The second comes after SLA MAnagement package upgrade:
Failed to install ]project-open[ Service Level Agreement Management, version 5.0.2.4.0. The following error was generated:
CONTEXT: SQL statement "create sequence im_ticket_priority_map_seq"
PL/pgSQL function inline_0() line 14 at SQL statement
psql:/web/projop/packages/intranet-sla-management/sql/postgresql/intranet-sla-management-create.sql:144: ERROR: duplicate key value violates unique constraint "acs_object_type_tables_pk"
DETAIL: Key (object_type, table_name)=(im_sla_parameter, im_sla_parameters) already exists.
psql:/web/projop/packages/intranet-sla-management/sql/postgresql/intranet-sla-management-create.sql:152: ERROR: duplicate key value violates unique constraint "im_biz_obj_urls_pk"
DETAIL: Key (object_type, url_type)=(im_sla_parameter, view) already exists.
psql:/web/projop/packages/intranet-sla-management/sql/postgresql/intranet-sla-management-create.sql:154: ERROR: duplicate key value violates unique constraint "im_biz_obj_urls_pk"
DETAIL: Key (object_type, url_type)=(im_sla_parameter, edit) already exists.
psql:/web/projop/packages/intranet-sla-management/sql/postgresql/intranet-sla-management-create.sql:209: ERROR: relation "im_sla_parameters" already exists
psql:/web/projop/packages/intranet-sla-management/sql/postgresql/intranet-sla-management-create.sql:214: ERROR: relation "im_sla_parameters_sla_idx" already exists
psql:/web/projop/packages/intranet-sla-management/sql/postgresql/intranet-sla-management-create.sql:222: ERROR: relation "im_sla_parameters_un_idx" already exists
psql:/web/projop/packages/intranet-sla-management/sql/postgresql/intranet-sla-management-create.sql:430: ERROR: relation "im_sla_param_indicator_rels" already exists
psql:/web/projop/packages/intranet-sla-management/sql/postgresql/intranet-sla-management-create.sql:448: ERROR: duplicate key value violates unique constraint "acs_rel_types_pk"
DETAIL: Key (rel_type)=(im_sla_param_indicator_rel) already exists.
CONTEXT: SQL statement "insert into acs_rel_types
(rel_type,
object_type_one, role_one,
min_n_rels_one, max_n_rels_one,
object_type_two, role_two,
min_n_rels_two, max_n_rels_two)
values
(create_typerel_type,
create_typeobject_type_one, create_typerole_one,
create_typemin_n_rels_one, create_typemax_n_rels_one,
create_typeobject_type_two, create_typerole_two,
create_typemin_n_rels_two, create_typemax_n_rels_two)"
PL/pgSQL function acs_rel_typecreate_type(character varying,character varying,character varying,character varying,character varying,character varying,character varying,character varying,character varying,integer,integer,character varying,character varying,integer,integer) line 36 at SQL statement
psql:/web/projop/packages/intranet-sla-management/sql/postgresql/intranet-sla-management-create.sql:546: ERROR: relation "im_sla_service_hours" already exists