2552823 - Spurious message "'master': upgrade has failed for this database" after upgrade from SP0x from SP03 - SAP ASE | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2552823 - Spurious message "'master': upgrade has failed for this database" after upgrade from SP0x from SP03 - SAP ASE

Symptom

  • When downgrading ASE SP03 PL0x to SP0x PL0x
  • And subsequently upgrading back up to SP03
  • ASE reports failure to upgrade master with messages including:

Database 'master' appears to be at an older version '16.0 SP02 PL05' than the present installation at version '16.0 SP03 PL01'; ASE will assess it, and upgrade it as required.
Database 'master': beginning upgrade step [ID 2]: validate basic system type data
...
Database 'master': beginning upgrade step [ID 21]: alter table (table sysdatabases)
Error: 2702, Severity: 16, State: 2
Database 'master' does not exist.
Error: 11050, Severity: 16, State: 6410879
Adaptive Server cannot process this ALTER TABLE statement due to one or more preceding errors. If there are no preceding errors, please contact SAP Technical Support.
Error: 3461, Severity: 20, State: 1
Database 'master': upgrade could not install required upgrade item '21'. Please refer to previous error messages to determine the problem. Fix the problem, then try again.
Error: 3462, Severity: 18, State: 1
Database 'master': upgrade could not install optional upgrade item '1800'. Please refer to previous error messages to determine the problem. Upgrade will continue.
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 1800 could not be installed.
ASE could not completely upgrade database 'master', but the database was online when upgrade began, so it will be left online.


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 16.0

Product

SAP Adaptive Server Enterprise 16.0

Keywords

811504, CR811504, CR#811504, item, sysdatabases, upg, in-memory structure , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.