3572965 - Upgrading 16.0 SP02 PL08 EBF 30911 to 16 SP04 PL06 fails with 2705 error - ASE

• Upgrading 16.0 SP02 PL08 EBF 30911 to 16 SP04 PL06
• syscolumns contains the following row

select name, id from syscolumns where name = "clientport"
go

name          id
-------        -----

clientport    32                                                                                                                                                                                                                                                                                                                                                                                                                                              (1 row affected)

• upgrade fails with the following errors in the ASE error log:

Database 'master': beginning upgrade step [ID    35]: alter table (table sysprocesses)
Error: 2705, Severity: 16, State: 2
Column names in each table must be unique. Column name 'clientport' in table 'sysprocesses' is specified more than once.
Error: 3461, Severity: 20, State: 1
Database 'master': upgrade could not install required upgrade item '35'. Please refer to previous error messages to determine the problem. Fix the problem, then try again.
Error: 3452, Severity: 20, State: 1
Database 'master': upgrade item 1804 depends on item 35, which could not be installed. Please refer to previous messages for the cause of the failure, correct the problem and try again.
Error: 3451, Severity: 20, State: 1
Database 'master': upgrade has failed for this database.  Please refer to previous messages for the cause of the failure, correct the problem and try again.
Error: 3454, Severity: 20, State: 1
Database 'master': ASE could not completely upgrade this database; upgrade item 1804 could not be installed.
00:0003:00000:00002:2025/02/08 11:48:40.35 server  ASE could not completely upgrade database 'master', but the database was online when upgrade began, so it will be left online.
The transaction log in the database 'master' will use I/O size of 2 Kb.
[140735508625152] Begin processing to generate RSA keypair.
server name is '<SERVER>'

• SAP Adaptive Server Enterprise (ASE)
• upgrade 16.0 SP02 PL08 EBF 30911 to 16.0 SP04 PL06

upgrade, 1604, system, table, 2705, clientport, syscolumns, CR 830393, 830393  , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Product Enhancement