My Oracle Support Banner

Executing the BRW_Upgrade_Database.sql Script is Causing an Error (Doc ID 2729394.1)

Last updated on NOVEMBER 20, 2020

Applies to:

Oracle WebCenter Forms Recognition - Version 12.2.1.4.0 and later
Information in this document applies to any platform.

Symptoms

When upgrading WebCenter Forms Recognition (WFR) to version 12.2.1.4, the below error occurs while executing the BRW_Upgrade_Database.sql script:

ERROR
-----------------------
ERROR:
ORA-01756: quoted string not properly terminated


CREATE OR REPLACE TRIGGER "BDD_EXTERNALDOCUMENT_ID_TRG" BEFORE INSERT OR UPDATE ON BDD_EXTERNALDOCUMENT FOR EACH ROW
  *
ERROR at line 1:
ORA-00942: table or view does not exist


ALTER TRIGGER "BDD_EXTERNALDOCUMENT_ID_TRG" ENABLE
*
ERROR at line 1:
ORA-04080: trigger 'BDD_EXTERNALDOCUMENT_ID_TRG' does not exist


ALTER TRIGGER "BDD_EXTERNALDOCUMENT_ID_TRG" ENABLE
*
ERROR at line 1:
ORA-04080: trigger 'BDD_EXTERNALDOCUMENT_ID_TRG' does not exist

 

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution


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