We found an issue when a customer upgrades from an existing v15.3 HF5 (or HF6) environment the v15.4 database utility is adding a duplicate global parameter which causes an error in a later SU update, in this case SU4.
Use this script to see the problem after running the upgrade to SP4 and then updating to SU4.
SELECT * FROM ap_glb_param WHERE ap_glb_param_code = 'glb_views_ignore_culture'Two rows will be returned for id 305166 and 305167. The 305167 row should be removed before running the db upgrade for SU4 on the database as there should only be one row and the param_id should be 305166.
This caused the error in the SU4 upgrade and was found specifically by reviewing the results.log:
29/03/2023 11:33:43 Script: exec sp_application_views_culturefix
29/03/2023 11:33:43 Status: Error, Error Message: Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression. Error number: 512
Command timeout: 14400 s.
