Errors Encountered During The Upgrade From 4.2 Hf2b To 4.2 Sp1 Hf1b (Doc ID 1341237.1)

Last updated on JULY 13, 2023

Applies to:

Goal

The following 9 errors were encountered during the upgrade from Safety 4.2 HF2B to 4.2 SP1 HF1B:

Error 1:
ALTER table ARGUS_APP.CASE_MASTER ADD (LAST_UPDATE_EVENT DATE);

SQL execution error, ORA-01430: column being added already exists in table

Error 2:
CREATE TABLE ARGUS_APP.IF_LM_ACTIONS
(
TABLE_ID NUMBER NOT NULL,
ID NUMBER NOT NULL,
SEQ_NUM NUMBER NOT NULL,
USER_ID NUMBER,
DATE_OPEN DATE,
DATE_DUE DATE,
DATE_DONE DATE,
DESCRIPTION VARCHAR2(1000),
SORT_ID NUMBER,
CODE NUMBER,
GROUP_ID NUMBER,
SYSTEM_CREATED NUMBER(1),
DELETED DATE
)
PCTFREE 10
PCTUSED 40
INITRANS 1
MAXTRANS 255
TABLESPACE ARGUS_DATA_01
NOLOGGING
STORAGE (
INITIAL 256K
NEXT 256K
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
)
;

SQL execution error, ORA-00955: name is already used by an existing object


Error 3:
CREATE UNIQUE INDEX ARGUS_APP.PK_IF_LM_ACTIONS ON ARGUS_APP.IF_LM_ACTIONS
(
TABLE_ID, ID, SEQ_NUM
)
TABLESPACE ARGUS_INDEX_01
NOLOGGING
PCTFREE 10
STORAGE (
INITIAL 128K
NEXT 128K
PCTINCREASE 0
);

SQL execution error, ORA-00955: name is already used by an existing object

Error 4:
ALTER TABLE ARGUS_APP.IF_LM_ACTIONS ADD ( CONSTRAINT PK_IF_LM_ACTIONS PRIMARY KEY (TABLE_ID, ID, SEQ_NUM));
SQL execution error, ORA-02260: table can have only one primary key

Error 5:
CREATE SEQUENCE ARGUS_APP.S_IF_LM_ACTIONS START WITH 1 NOCACHE;
SQL execution error, ORA-00955: name is already used by an existing object

Error 6:
CREATE PUBLIC SYNONYM S_IF_LM_ACTIONS FOR ARGUS_APP.S_IF_LM_ACTIONS;
SQL execution error, ORA-00955: name is already used by an existing object

Error 7:
insert into CFG_M2 (PROFILE ,M2,DESCRIPTION,DTD_ELEMENT )
SELECT DISTINCT CE.PROFILE AS PROFILE ,upper('backlog') AS M2
,'ICSRS RELATED TO THE RETROSPECTIVE POPULATION' AS DESCRIPTION
, 'MESSAGETYPE' AS DTD_ELEMENT FROM CFG_E2B CE
, CFG_PROFILE CP WHERE CP.PROFILE = CE.PROFILE
AND CP.PROFILE_TYPE ='MSG_DEFINED'
AND CE.DTD_ELEMENT ='MESSAGETYPE';

SQL execution error, ORA-00001: unique constraint (ESM_OWNER.PK_CFG_M2) violated

Error 8:
CREATE PUBLIC SYNONYM IF_LM_ACTIONS FOR ARGUS_APP.V$IF_LM_ACTIONS;
SQL execution error, ORA-00955: name is already used by an existing object

Error 9:
CREATE PUBLIC SYNONYM PKG_ARG_DMS FOR ARGUS_APP.PKG_ARG_DMS;
SQL execution error, ORA-00955: name is already used by an existing object

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.