Errors Encountered During Upgrade From Argus Safety 4.2_sp1 Hf2 To 5.0 (Doc ID 1341254.1)

Last updated on JULY 25, 2011

Applies to:

Oracle Argus Safety - Version: 4.2.0.2B and later   [Release: and later ]
Information in this document applies to any platform.

Goal

The following errors observed when upgrading from Argus Safety 4.2 SP1 HF2  to 5.0:

Error 1:
CREATE TABLE ARGUS_APP.LM_EVT_NATURE
(
EVT_NATURE_ID NUMBER NOT NULL,
EVT_NATURE VARCHAR2(40) NOT NULL,
PROTECTED NUMBER,
DISPLAY NUMBER,
DELETED DATE
)
PCTFREE 10
PCTUSED 40
INITRANS 1
MAXTRANS 255
TABLESPACE ARGUS_DATA_01
STORAGE (
     INITIAL 128K
     MINEXTENTS 1
     MAXEXTENTS UNLIMITED
     PCTINCREASE 10
     );

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


Error 2:
CREATE INDEX ARGUS_APP.PK_LM_EVT_NATURE ON ARGUS_APP.LM_EVT_NATURE
(
     EVT_NATURE_ID
)
     PCTFREE 10
     INITRANS 2
     MAXTRANS 255
     TABLESPACE ARGUS_INDEX_06
     STORAGE (
            INITIAL 10K
            NEXT 10K
            MINEXTENTS 1
            MAXEXTENTS UNLIMITED
            PCTINCREASE 0
     )
;

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


Error 3:
ALTER TABLE ARGUS_APP.LM_EVT_NATURE
     ADD  ( CONSTRAINT PK_LM_EVT_NATURE PRIMARY KEY (EVT_NATURE_ID) ) ;

SQL execution error, ORA-02260: table can have only one primary key


Error 4:
CREATE SEQUENCE ARGUS_APP.S_LM_EVT_NATURE START WITH 100000 INCREMENT BY 1 NOCACHE;

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


Error 5:
CREATE TABLE ARGUS_APP.CASE_EVENT_NATURE (
CASE_ID  NUMBER NOT NULL,
SEQ_NUM  NUMBER NOT NULL,
EVENT_SEQ_NUM  NUMBER NOT NULL,
EVT_NATURE_ID  NUMBER NOT NULL,
DELETED  DATE
)
PCTFREE 10
PCTUSED 40
INITRANS 1
MAXTRANS 255
TABLESPACE ARGUS_DATA_03
STORAGE (
     INITIAL 256K
     MINEXTENTS 1
     MAXEXTENTS UNLIMITED
     PCTINCREASE 10
     );

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


Error 6:
CREATE INDEX ARGUS_APP.PK_CASE_EVENT_NATURE ON ARGUS_APP.CASE_EVENT_NATURE
(
     CASE_ID,SEQ_NUM
)
     PCTFREE 10
     INITRANS 2
     MAXTRANS 255
     TABLESPACE ARGUS_DATA_01
     STORAGE (
            INITIAL 1024K
            NEXT 1024K
            MINEXTENTS 1
            MAXEXTENTS UNLIMITED
            PCTINCREASE 0
     )
;

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


Error 7:
CREATE INDEX ARGUS_APP.FK_CASE_EVT_NTRE_EVT_NTRE_ID ON ARGUS_APP.CASE_EVENT_NATURE
(
     EVT_NATURE_ID
)
     PCTFREE 10
     INITRANS 2
     MAXTRANS 255
     TABLESPACE ARGUS_DATA_01
     STORAGE (
            INITIAL 1024K
            NEXT 1024K
            MINEXTENTS 1
            MAXEXTENTS UNLIMITED
            PCTINCREASE 0
     )
;

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


Error 8:
ALTER TABLE ARGUS_APP.CASE_EVENT_NATURE
     ADD  ( CONSTRAINT PK_CASE_EVENT_NATURE PRIMARY KEY (CASE_ID,SEQ_NUM) ) ;

SQL execution error, ORA-02260: table can have only one primary key


Error 9:
ALTER TABLE ARGUS_APP.CASE_EVENT_NATURE
     ADD  ( CONSTRAINT FK_CASE_EVT_NTRE_EVT_NTRE_ID
            FOREIGN KEY (EVT_NATURE_ID)
                           REFERENCES ARGUS_APP.LM_EVT_NATURE ) ;

SQL execution error, ORA-02275: such a referential constraint already exists in the table


Error 10:
CREATE SEQUENCE ARGUS_APP.S_CASE_EVENT_NATURE START WITH 100000 INCREMENT BY 1 NOCACHE;

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


Error 11:
ALTER TABLE ARGUS_APP.CASE_MASTER ADD  (INITIAL_JUSTIFICATION VARCHAR2(2000)) ;

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


Error 12:
ALTER TABLE ARGUS_APP.LM_REGULATORY_CONTACT ADD(AUTO_ACCEPT_ICSR NUMBER DEFAULT 0 NOT NULL CHECK (AUTO_ACCEPT_ICSR IN (0,1)) );

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


Error 13:
ALTER TABLE ARGUS_APP.LM_REGULATORY_CONTACT ADD(TRANSMIT_E2B_ATTACHMENT NUMBER DEFAULT 0 NOT NULL CHECK (TRANSMIT_E2B_ATTACHMENT IN (0,1)) );

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


Error 14:
ALTER TABLE ARGUS_APP.CMN_REG_REPORTS ADD (AUTO_DISTRIBUTE_REPORTS NUMBER);

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



Error 15:
Update cmn_profile set value ='CASE' WHERE KEY = 'NUMBERING_DATE' AND VALUE = 1;

SQL execution error, ORA-01722: invalid number

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms