Problem

The upgrade with Patch 28 or later for ST 5.4 EC with Oracle DB can fail, and the following error messages will be observed in the install.log file:

DEBUG com.axway.st.sustaining.patch.custom.impl.RDST21868.onEndingUpdate()
ERROR Failed to execute query from /conf/sql/RDST21868.oracle.update.sql Statement: 
ERROR An error occurred while performing database update. Reason: java.sql.SQLSyntaxErrorException: ORA-01722: invalid number
ORA-06512: at line 12

Resolution

The upgrade fails due to lack of records in the LOGGING_EVENT table. The number of records in the table can be confirmed by executing the SQL statement:

SELECT count (*) FROM LOGGING_EVENT;

In order for the upgrade to complete successfully, the LOGGING_EVENT table must contain at least a few records, in other words - some messages must be logged in the ST ServerLog. If the above SQL statement returns zero records, you can start or stop one of the ST protocol daemons to generate log messages and respectively - records in the table.

The protocol daemon you choose to stop or start must be logging its output in the database instead of a flat file.

Follow the below steps to retry the upgrade:

Restore the DB to the state before the upgrade

Restore the full backup of your SecureTransport installation before the failed upgrade.

Refer to KB article 180639 (Linux) or KB article 180641 (Windows) for information how to take and restore a full ST backup.

Start the ST services and confirm that there are logged messages in the ST ServerLog and the LOGGING_EVENT table.

Stop the ST services and proceed with the upgrade.