Symptom
- Trying to downgrade ASE from 15.7 to ASE 15.5
- Getting the following errors:
Downgrade from 15.7.0.5 to 15.5.0.5 (command: 'prepare')
This is a re-run of sp_downgrade; skip sp_encryption Checking sysdams in preparation for downgrade Running CHECKPOINT on database 'master' for option 'prepare' to take effect.
Running CHECKPOINT on database 'model' for option 'prepare' to take effect.
Msg 207, Level 16, State 4: Server 'ASE_standby_test', Line 1: Invalid column name 'lobcomp_lvl'. Error: Database 'model' has tables configured for LOB compression.
Msg 207, Level 16, State 4: Server 'ASE_standby_test', Line 1: Invalid column name 'lobcomp_lvl'. Msg 207, Level 16, State 4: Server 'ASE_standby_test', Line 1: Invalid column name 'lobcomp_lvl'.
Msg 207, Level 16, State 4: Server 'ASE_standby_test', Line 1: Invalid column name 'inrowlen'. Msg 207, Level 16, State 4: Server 'ASE_standby_test', Line 1: Invalid column name 'inrowlen'.
Running CHECKPOINT on database 'tempdb' for option 'prepare' to take effect.
Msg 207, Level 16, State 4: Server 'ASE_standby_test', Line 1: Invalid column name 'lobcomp_lvl'. Error: Database 'tempdb' has tables configured for LOB compression.
Msg 207, Level 16, State 4: Server 'ASE_standby_test', Line 1: Invalid column name 'lobcomp_lvl'.
Msg 207, Level 16, State 4: Server 'ASE_standby_test', Line 1: Invalid column name 'lobcomp_lvl'.
Read more...
Environment
- SAP Adaptive Server Enterprise Cluster Edition (ASE CE) 15.7
- Dataserver
Product
Keywords
CR745963, CR#745963, 745963, sp_downgrade, sa_serverprivs_role, sysusers, sysroles, sysprotects , KBA , BC-SYB-ASE-CE , ASE Cluster Edition (Standalone) , 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.