Executing the BRW_Upgrade_Database.sql Script is Causing an Error
(Doc ID 2729394.1)
Last updated on NOVEMBER 29, 2023
Applies to:
Oracle WebCenter Forms Recognition - Version 12.2.1.4.0 and laterInformation 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
-----------------------
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 |