cancel
Showing results for 
Search instead for 
Did you mean: 

Any experience of downgrading ASE 15.7 SP122 to SP100

Former Member
0 Kudos

Anyone got any experience of downgrading ASE 15.7 SP122 to SP100 ?

Is this a simply a change to the binaries or is there anything else required ?

Should I expect any issues ?

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member188958
Active Contributor
0 Kudos

Hi Mike,

You should run sp_downgrade_esd on each database before doing the downgrade.

There was a persistent bug in sp_downgrade_esd for a number of the releases, in that the current ASE version is hardcoded in the procedure text, but didn't get updated for each new ESD.  So if you get an error like "This version of sp_downgrade_esd is specific to 15.7 SP 120. It cannot be used on your current", you need to extract the source code for this procedure, find the line that sets @sp_now to the version in the error message (120) to your SP number (122 in your case).  You want to be sure the version of sp_downgrade_esd is the one provided with the installmaster script of your release (output for "installmaster" in sp_version should match @@version).       

-bret

Former Member
0 Kudos

Thanks - we have one version at SP132 and one at SP122.

Both give the error

This version of sp_downgrade_esd is specific to 15.7 SP 120. It cannot be used on your current ASE.

Your version: Adaptive Server Enterprise/15.7/EBF 22779 SMP SP122 /P/x86_64/Enterprise Linux/ase157sp12x/3662/64-bit/FBO/Sat Apr 19 05:48:19 2014

This version of sp_downgrade_esd is specific to 15.7 SP 131. It cannot be used on your current ASE.

Your version: Adaptive Server Enterprise/15.7/EBF 23821 SMP SP132 /P/x86_64/Enterprise Linux/ase157sp131x/3919/64-bit/FBO/Tue Jan 20 04:44:18 2015

So I guess the bug in sp_downgrade_esd is in both of these versions.

Thanks - will now try and downgrade them

Former Member
0 Kudos

For SP132, the issue is documented in the SAP ASE cover letter:

CR 778174 - sp_downgrade_esd issue for SAP ASE 15.7 SP132


  sp_downgrade_esd will report "This version of sp_downgrade_esd
  is specific to 15.7 SP 131. It cannot be used on your current ASE.".

  To work around this issue, change the line in the sp_downgrade_esd
  stored procedure that sets the @sp_now variable from:

  ,@sp_now = 131

  to

  ,@sp_now = 132

  and then recompile the stored procedure.

Former Member
0 Kudos

Thanks - where can we see the SAP ASE cover letter ?

former_member188958
Active Contributor
0 Kudos

When the ESD is downloaded from service marketplace, there is an "info" link to the right on the same line.  That takes you to a window that has a link to an SAP Note.  The SAP Note has the coverletters (READMEs) for each platform of the release,

Former Member
0 Kudos

Thanks - thats excellent.

Former Member
0 Kudos

Just FYI - The downgrade from ASE15.7 SP122 to SP62 worked fine for me.

syntax:

sp_downgrade_esd sybsystemprocs ,SP62;

....

then start with a SP62 software.

then run the installmaster/installcommit scripts....

Thanks Bret and Paul for your answers on that thread!

Vincent