My Oracle Support Banner

Validation Check Batch Installation Failed with Error "PARAM3=PL/SQL source code is not properly terminated. Failed to insert security code into the package." (Doc ID 2796211.1)

Last updated on AUGUST 31, 2021

Applies to:

Oracle Health Sciences Data Management Workbench - Version 2.5.3 and later
Information in this document applies to any platform.

Symptoms

On Oracle Data Management WorkBench (DMW) 2.5.3 version, Validation Check Batch Installation Fails with below error:


XFM_INSTALL:XXX:*** ERROR: Error during Workarea Install : &PARAM0 (PARAM2=Cdr_Exe_Installation) (PARAM3=PL/SQL source code is not properly terminated. Failed to insert security code into the package. The package should end with "END;" or "END <my_package>;")
XFM_INSTALL:XXX:*** ERROR: Error during Workarea Install : Please see the Installation log for detailed error information.
XFM_INSTALL:XXX:*** ERROR: There may be errors during work area installation for the target model. Please try re-deploying the map.

Error from OWB/CDR DB Server-PLSQL Operator: statement:"begin WORKAREA_SCHEMA.PLSQL_UTIL_PROG_PKG.PROCESSPLSQLUTILJOB ; end;" caught:java.sql.SQLException: ORA-20200: *** ERROR: Exception while Installing the VC Batch..Hence cannot proceed further
ORA-06512: at "APPS.CDR_ATK_UTILS", line 866
ORA-06512: at "APPS.DME_INST_XFORM_MAP", line 12768
ORA-06512: at "APPS.DME_DF_XFORM_MAP", line 23124
ORA-06512: at "APPS.CDR_EXE_RUNTIME", line 15933
ORA-06512: at "CDR_WE7D_21021_1.PLSQL_UTIL_PROG_PKG", line 4
ORA-06512: at line 1

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.