Error "invalid identifier" during upgrade to IDSP 4.0.4

Products

• Symantec Identity Security Platform - IDSP (formerly VIP Authentication Hub)

Issue/Introduction

When upgrade IDSP 4.0.3 to 4.0.4, the dataseed job errors out. It reports "invalid identifier". 

Bootstrap: Failed initialization. Reason: JDBC exception executing SQL [select ae1_0.APPLICATION_ID,ae1_0.TENANT_ID,.... from T_APPLICATION ae1_0 where ae1_0.TENANT_ID=? and ae1_0.CLIENT_NAME=?] [ORA-00904: \"AE1_0\".\"IS_SOFT_DELETE_ENABLED\": invalid identifier

Environment

IDSP 4.0.4

Oracle database

Resolution

Required incremental SQL files (IDSP_4.0.4_Oracle_SQL_upgrade_file.sql) needs to be applied to Oracle SQL database prior upgrade.

According to documentation:

"For upgrades from previous versions of IDS,  incremental SQL files must be applied in the correct sequence to ensure proper schema migration.

If you are on a specific patch version of IDSP and you intend to upgrade to another patch version, download and apply only the Oracle SQL files relevant to the patches you are moving to. and you intend to upgrade to another patch version, download and apply only the Oracle SQL files relevant to the patches you are moving to."

https://techdocs.broadcom.com/us/en/symantec-security-software/identity-security/identity-security-platform/4-0/isp-release-notes/release-notes--4-0/oracle-sql-file-updates.html