on 03-19-2015 1:12 PM
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 ?
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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.
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.