The upgrade from iProcess Engine (Oracle) 11.6.0 to 11.6.0 HF 21 is applying database updates when no database updates are required.

The upgrade from iProcess Engine (Oracle) 11.6.0 to 11.6.0 HF 21 is applying database updates when no database updates are required.

book

Article ID: KB0077725

calendar_today

Updated On:

Products Versions
TIBCO iProcess Engine (Oracle) 11.6.0.21

Description

The upgrade from iProcess Engine 11.6.0 (Oracle) to 11.6.0 HF 21 should not run any database updated.

The output from the upgrade (swinstall) indicates that the following database upgrade script are applied:
    Running upgrade script uorai115_00.sql
    Running upgrade script uorai116_00.sql

Issue/Introduction

The upgrade from iProcess engine 11.6.0 (Oracle) to 11.6.0 HF 21 should not run any database updated. The output from the upgrade (swinstall) indicates that the following database upgrade script are applied: Running upgrade script uorai115_00.sql Running upgrade script uorai116_00.sql

Environment

TIBCO iProcess Engine (Oracle) 11.6.x on UNIX platforms

Resolution

The file SWDIR/swdefs.orig existed from a previous upgrade and contained the version 11.4.1.0

The iProcess Engine (Oracle) installer on UNIX reads the iProcess version from in the swdefs.orig file (if the file is present) and therefore applied the database upgrade scripts from 11.4.1 to 11.6.0.21

The resolution is to:
1 Restore the iProcess database and SWDIR to the pre-upgraded version
2 Delete the file SWDIR/swdef.orig
3 Re-run the iProcess upgrade (swinstall)

The installer will upgrade from 11.6.0 to 11.6.1.21 without applying any database updates.