SAP Knowledge Base Article - Preview

2168250 - Error 207 "Invalid column name" with sp_downgrade - SAP ASE

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

Sybase Adaptive Server Enterprise Cluster Edition 15.7

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.