Symptom
The following messages are in the errorlog after using sp_downgrade_esd from SP02 PL07 HF1 to SP02 SP05
1> sp_downgrade_esd 'testdb','SP02 PL05'
2> go
Reverting database 'testdb' to SP02 PL05.
Running CHECKPOINT on database 'testdb' for option 'downgrade' to take effect.
Downgrade is complete.
Database 'testdb' is now suitable for use by SP02 PL05.
Errorlog:
00:0000:00000:00000:2018/11/29 15:59:36.69 kernel Adaptive Server Enterprise/16.0 SP02 PL05/EBF 26670 SMP/P/x86_64/Enterprise Linux/ase160sp02pl05x/2714/64-bit/FBO/Sun Dec 4 07:35:11 2016
00:0000:00000:00002:2018/11/29 15:59:38.03 server Database 'master' appears to be at an older version '16.0 SP02 PL05' than the present installation at version '16.0 SP02 PL05'; ASE will assess it, and upgrade it as required.
00:0000:00000:00002:2018/11/29 15:59:38.04 server Database 'master': beginning upgrade step [ID 2]: validate basic system type dat
00:0000:00000:00002:2018/11/29 15:59:38.15 server Database 'master': beginning upgrade step [ID 75]: executing SQL statement ("update syscolumns set type=66, user...
00:0000:00000:00002:2018/11/29 15:59:38.21 server Database 'master': beginning upgrade step [ID 9]: executing SQL statement ("if exists (select 1 from syscolumns...")
00:0000:00000:00002:2018/11/29 15:59:38.23 server Database 'master': beginning upgrade step [ID 69]: executing SQL statement ("if 2 = (select count(name) from sys...")
(lines removed for brevity)
00:0000:00000:00002:2018/11/29 15:59:40.20 server Database 'master': beginning upgrade step [ID 1702]: noting the present database upgrade level
00:0000:00000:00002:2018/11/29 15:59:40.20 server Database 'master': beginning upgrade step [ID 1719]: executing SQL statement ("update sysattributes set object_inf...")
00:0000:00000:00002:2018/11/29 15:59:40.20 server Database 'master': beginning upgrade step [ID 1720]: noting the present database upgrade level
00:0000:00000:00002:2018/11/29 15:59:40.20 server Database 'master': beginning upgrade step [ID 1740]: noting the present database upgrade level
00:0000:00000:00002:2018/11/29 15:59:40.20 server Database 'master': beginning upgrade step [ID 1800]: noting the present database upgrade level
00:0000:00000:00002:2018/11/29 15:59:40.20 server Upgrade has finished in database 'master'. ASE is now updating table level statistics for its system tables. Please be patient.
Read more...
Environment
SAP Adaptive Server Enterprise (ASE) 16.x
Product
Keywords
KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem
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.