Symptom
-
After upgrade to ASE 16.0 SP03 PL0x
-
The versiondbid column from sysdatabase system table shows incorrect value(s)
- For example below query could return versiondbid 123 , 2 or another invalid number:
select versiondbid,name from master..sysdatabases
versiondbid name
--------------- -----------
123 master
123 model
123 tempdb
- These incorrect versiondbid values can cause problems when attempting to downgrade from ASE 16.0 SP03 PL0X to pre-SP03 versions (such as ASE 16.0 SP02, SP02 PL04, etc.) For example, when running sp_downgrade_esd to downgrade, an error message can occur:
"Database master: Catalog sysdatabases found with 3 rows with versiondbid column still in use"
Read more...
Environment
SAP Adaptive Server Enterprise (ASE) 16.0 SP03
Product
SAP Adaptive Server Enterprise 16.0
Keywords
KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , Bug Filed
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.