Many Errors In The Log File Generated In Database Upgrade While Applying Patch 4.6.1.5

(Doc ID 557182.1)

Last updated on APRIL 29, 2008

Applies to:

Adverse Event Reporting System - Version: 4.6
This problem can occur on any platform.

Symptoms

-- Problem Statement:
On AERS 4.6:
Found a lot of errors while running the aersupg461to4615drvr.sql script as part of applying patch
4.6.1.5 in AERS.

ERROR
alter table CIOMS1TEMP add IV24D_SOURCE_CONSUMER VARCHAR2(4000)
*
ERROR at line 1:
ORA-01430: column being added already exists in table


alter table E2B_RECEIVERS ADD (INCLUDE_CO_ASSESSMENT VARCHAR2(5) )
*
ERROR at line 1:
ORA-01430: column being added already exists in table
RROR at line 1:
ORA-00001: unique constraint (AERS.REPORT_PARAMS_PK) violated


insert into program_parameters
*
ERROR at line 1:
ORA-00001: unique constraint (AERS.PARAMETERS_PK) violated

-- Steps To Reproduce:
The issue can be reproduced at will with the following steps:
1) Download patch 4.6.1.5
2) Run aersupg461to4615drvr.sql as part of installing the patch.
3) Review the logfile and you will a lot of errors.

Cause

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