sp_application_views_culturefix Error upgrading from 15.3HF5 to v15.4SU4

  • 30 March 2023
  • 2 replies
  • 38 views
Phil Seifert
Rank
Userlevel 7
Badge +21

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.

 

2 replies

A
Rank
Userlevel 7
Badge +10

Thanks for this.  So the SQL that needs to be executed is this?

delete from ap_glb_param where ap_glb_param_code = 'glb_views_ignore_culture' and ap_module_name = 'app_setup_itil';

Is this correct?

Phil Seifert
Rank
Userlevel 7
Badge +21

Hi Andrew,

The DBA said to delete the ID 305167 when I confirmed which row is correct.

Your script should work in the case described  above but I would not use the Y value as customer might have changed it to N.

Reply


Terms & ConditionsCookie settings