Ora-0001 Running 452to46_configdeltas.Sql -During Upgrade To Aers 4.6

(Doc ID 866692.1)

Last updated on AUGUST 02, 2009

Applies to:

Adverse Event Reporting System - Version: 4.6.1
Information in this document applies to any platform.

Goal

Upgrading from 4.5.2 -> 4.6 and logs show that following excerpt.



No errors.
running 452to46_configdeltas.sql
[452to46_configdeltas.sql]
[Updating CASE_STATUS]
[CODE_LISTS]
[CODE_LIST_DTLS]
[ERROR_CODES]
[ERROR_MSGS]
[RG_ATTRIBUTES]
[FIELD_ATTRIBUTES]
[FIELD_LOV_COLUMN_MAPPINGS]
INSERT INTO FIELD_LOV_COLUMN_MAPPINGS T (FORM_NAME, BLOCK_NAME, ITEM_NAME, COLUMN_NBR, COLUMN_TITLE, COLUMN_WIDTH, RETURN_ITEM)
*
ERROR at line 1:
ORA-00001: unique constraint (ENSITE.FIELD_LOV_COLUMN_MAPPINGS_PK) violated


INSERT INTO FIELD_LOV_COLUMN_MAPPINGS T (FORM_NAME, BLOCK_NAME, ITEM_NAME, COLUMN_NBR, COLUMN_TITLE, COLUMN_WIDTH, RETURN_ITEM)
*
ERROR at line 1:
ORA-00001: unique constraint (ENSITE.FIELD_LOV_COLUMN_MAPPINGS_PK) violated


INSERT INTO FIELD_LOV_COLUMN_MAPPINGS T (FORM_NAME, BLOCK_NAME, ITEM_NAME, COLUMN_NBR, COLUMN_TITLE, COLUMN_WIDTH, RETURN_ITEM)
*
ERROR at line 1:
ORA-00001: unique constraint (ENSITE.FIELD_LOV_COLUMN_MAPPINGS_PK) violated

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