Advanced upgrade from R80.10 to R80.40 Jumbo Hotfix Take 83/87/89 fails

Support Center > Search Results > SecureKnowledge Details

Technical Level

Solution ID	sk170313
Technical Level
Product	Quantum Security Management
Version	R80.10, R80.20, R80.30, R80.40
Date Created	02-Nov-2020
Last Modified	07-Jan-2021

Symptoms

Advanced upgrade from R80.10 to R80.40 Jumbo Hotfix Take 83/87 fails.
$MDS_TEMPLATE/log/cpm.elg shows the following exception:
CpmGeneralException{base='com.checkpoint.management.is.exceptions.CpmGeneralException: Couldn't connect to database', errorCode='CP_ERR_DATABASE_CONNECTION', errorFamily='null', messageForUser='null', message='Couldn't connect to database'} at com.checkpoint.management.object_store.DatabaseOperationsHelperBean.executeCommand(DatabaseOperationsHelperBean.java:35) at com.checkpoint.management.object_store.DatabaseOperationsHelperBean.runDbScript(DatabaseOperationsHelperBean.java:32) at com.checkpoint.management.cpm.commands.SchemaChangesCommand.runSqlChanges(SchemaChangesCommand.java:245) at com.checkpoint.management.cpm.commands.SchemaChangesCommand.run(SchemaChangesCommand.java:84) at com.checkpoint.management.cpm.Cpm.main(Cpm.java:204) Caused by: org.postgresql.util.PSQLException: ERROR: syntax error at or near "RETURN"

Cause

Bad syntax of a schema change fails the upgrade.

Solution

Note: To view this solution you need to Sign In .