My Oracle Support Banner

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

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

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.

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