Enforce upgrade to v14.6 fails with java.sql.SQLException: ORA-06550

Products

• Data Loss Prevention Enforce

Issue/Introduction

Upgrading Enforce to v14.6 fails.

Upgrading Enforce to v14.6 fails with the following error

Database upgrade failed due to SQL exception:
java.sql.SQLException: ORA-06550: line 1, column 7:
PLS-00201: identifier 'UPGRADESCHEMA_V14_6_0.MAIN_DRIVER' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

Resolution

For Windows

1. Extract Upgrade_Windows.jar
2. Open command prompt Window and change to SQL directory <path>\sql\ (You will see SQL directory in the extracted Upgrade_windows.jar)
3. Login to database from SQL directory using protect account.
4. Run compile_PKG.sql

Run the upgrade wizard again.

For Linux

1. Extract Upgrade_Linux.jar
2. Open command prompt Window and change to SQL directory <path>\sql\ (You will see SQL directory in the extracted Upgrade_Linux.jar)
3. Login to database from SQL directory using protect account.
4. Run @compile_PKG.sql

Run the upgrade wizard again.