iPE 11.6.1 Error in instuil script when using the swinstall "Use Existing database" option

iPE 11.6.1 Error in instuil script when using the swinstall "Use Existing database" option

book

Article ID: KB0082609

calendar_today

Updated On:

Products Versions
TIBCO iProcess Engine (Oracle) 11.6.1

Description

Issue when running swinstall with the database option of "Use existing database". The installer checks to see if the machine name is in the iProcess database. This fails due to an error in the instutil script. The following shows the output generated:

Checking DB connectivity and users ...
WARNING: iPE Tables already exist for user (pjrpro11) node (phil11)
./swinstall[2472]: [: argument expected
An entry for this machine (hapi) is already in the NODE_CLUSTER table
Do you want to overwrite the tables for user pjrpro11 (Y/N - default N) :


The install indicates that the machine is already in the iProcess NODE_CLUSETR database table when no entry exists.
 

Issue/Introduction

Issue when running swinstall with the database option of "Use existing database"

Environment

TIBCO iProcess Engine 11.6.1 (Oracle)

Resolution

The error is generated in the iProcess instuil script which is supplied with the iProcess Engine 11.6.1 release.

The script contains the line:

    tn_code=`$ECHO "$SQLRET" | grep -i "^$THISNODE\$" > /dev/null`

This should be changed to:
    echo "$SQLRET" | grep -i "^$THISNODE\$" > /dev/null
    tn_code=$?

 
The tn_code variable should contain the return / exit  status code of the command.
 
An updated version of the instuil script is attached to this article
 
If you are using the ““Use existing database” option to install the iProcess engie 11.6.1 then:
1). Download the updated instutil script from this article
2). Copy the updated instutil script to the iProcess Engine release directory (overwrite the existing file)
3).  Run swinstall


See the attached (Filename: instutil ) for reference.

Attachments

iPE 11.6.1 Error in instuil script when using the swinstall "Use Existing database" option get_app