Using copa_setup after 4.6 Upgrade Throws RXC_ROOT: Undefined Variable (Doc ID 1219048.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Clinical Remote Data Capture Option - Version: 4.6.0 to 4.6.0 - Release: 4.6 to 4.6
Information in this document applies to any platform.

Symptoms


You have recently upgraded to 4.6 and are trying to use the copa_setup.sh .

After it fails you examine the log file and find the following error message:

ERROR MESSAGES:


> echo 'basename $0'
tcsh
> pwd
/app/opapps/bin
> setenv p1 ocd46
> setenv p2 46
> copa_setup ocd46 46
Found line in oratab file for database "ocd46".
RXC_ROOT: Undefined variable
>



Following is the opa_settings file:

$ pwd
/app/opapps/bin
$ cat opa_settings
opa_home:/app/opapps
oratab_filespec:/var/opt/oracle/oratab
tnsnames_filespec:/app/oracle/tnscfg/tnsnames.ora
db_env_setting:_DEFAULT_:RXC_DEBUG_BUFFER_SIZE:1000000
db_env_setting:_DEFAULT_:NLS_DATE_FORMAT:DD-MON-RRRR
db_env_setting:_DEFAULT_:NLS_LANG:american_america.we8iso8859p1
db_env_setting:_DEFAULT_:RXC_BATCH_QUEUE:a
db_env_setting:_DEFAULT_:RXC_IMMED_QUEUE:a
db_env_setting:_DEFAULT_:RXC_BV_QUEUE:a
db_env_setting:_DEFAULT_:RXC_MAA_TAB_SPACE:TEMP1
db_env_setting:_DEFAULT_:RXC_NOW_STRING:now
db_env_setting:_DEFAULT_:RXC_SAS_BATCH_QUEUE:a
db_env_setting:_DEFAULT_:RXC_SAS_BASE:/oraclin/sasview
db_env_setting:_DEFAULT_:RXC_USER:${RXC_ROOT}/user
db_env_setting:_DEFAULT_:SASORA:V9
code_environment:46:/app/opapps/oc/46
code_environment:453:/app/opapps/oc/453
db_code_pair:ocd46:46
db_code_pair:ocdar453:453
$



This appears to be where the script fails:

# ------------------------------------------------------------------------
#
# Read file locations portion of opa_settings file
# Extract values for oratab and tnsnames from mapping file.

# Read the value of RXC_ROOT associated with the requested code env.
if ( $codeenv_requested == TRUE ) then
  if ( $use_cc_view == FALSE ) then  # This is the norm for end-users
    set codeenv_root = \
      `grep -i "^code_environment:${codeenv}:" $OPA_BIN/opa_settings |  awk -F: '{print $3}'`


Apparently the setting of codeenv_root does not succeed, because later this is used to populate  $RXC_ROOT. The text thrown in the log information shows "RXC_ROOT: Undefined variable"




Changes

Previously, this worked with 4.5.3.

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