SAP Knowledge Base Article - Preview

2100610 - Downgrade from ASE 15.7 SP130 to ASE 15.5 hangs or is running extremely slow.

Symptom

  • Downgrade from ASE 15.7 SP130 to ASE 15.5 hangs or is running extremely slow.
     
  • A server process executing  sp_downgrade seems like hanging for hours at Step 999 at the very end of downgrade process.
    This is the end of the output:

1> sp_downgrade 'downgrade', @toversion='155', @override=1, @verbose=1
2> go
@fromversid = 15700' @fromversion = '15.7.0.0' @toversid = 155
Downgrade from 15.7.0.0 to 15.5.0.0 (command: 'downgrade')
...
Executing downgrade step 999 [declare @d int select @d=dbinfo_update(@dbid, 'ASEvers', 15500)] for :
- Database: master (dbid: 1)
- Database: tempdb (dbid: 2)
- Database: model (dbid: 3)
- Database: mydb1 (dbid: 4)
- Database: mydb2 (dbid: 5)
- Database: auditdata (dbid: 6)
- Database: mda_history (dbid: 8)
- Database: sybsystemdb (dbid: 31513)
- Database: sybsystemprocs (dbid: 31514)
- Database: dbccdb (dbid: 31515)
 
Dropping and recreating index on Sysprotects for database master

DBCC execution completed. If DBCC printed error messages, contact a user with System Administrator (SA) role.
 
Dropping and recreating index on Sysattributes for database master

DBCC execution completed. If DBCC printed error messages, contact a user with System Administrator (SA) role.
 
Dropping and recreating index on Sysprotects for database tempdb

DBCC execution completed. If DBCC printed error messages, contact a user with System Administrator (SA) role.
 
Dropping and recreating index on Sysattributes for database tempdb

DBCC execution completed. If DBCC printed error messages, contact a user with System Administrator (SA) role.
 
Dropping and recreating index on Sysprotects for database model

DBCC execution completed. If DBCC printed error messages, contact a user with System Administrator (SA) role.
 
Dropping and recreating index on Sysattributes for database model


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 15.7

Product

SAP Adaptive Server Enterprise 15.7

Keywords

775241, CR775241, async, log, service, CR#775241 , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , 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.