SAP Knowledge Base Article - Preview

2727254 - sp_downgrade_ esd from ASE 16 SP02 PL07 HF1 to SP02 SP05 - SAP ASE

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

SAP Adaptive Server Enterprise 16.0

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.