Once again I welcome all of you to my blog !! This time, I thought to introduce set of steps for upgrading MS SQL 2008 R2 to 2012 in Solution Manager. Though I already have mentioned the steps incurred in general MS SQL upgrade in my earlier document “http://scn.sap.com/docs/DOC-42596“, but this document contains some additional steps which are pre-requisite requirement in Solution Manager before upgrading the same.
System Configuration Details :-
Solution Manager (Source Configuration) : Solman 7.1 SP8 (With netweaver version 7.0 EHP2 )
Kernel version : 720 (SP Level: 401) Unicode (EXTENDED).
MS SQL version : MS SQL 2008 R2 SP1
So, now in order to proceed for database upgrade, following steps need to be taken :-
1. Take the complete back-up of Solution Manager server.
2. Then as per following requirement, update your solution manager server software components :-
It’s recommended to upgrade to (n+1) version i.e SP12 for both the components i.e. SAP_BASIS & SAP_BW .
To update above components , following dependant components are also required to be updated. Below mentioned components will automatically appear (will be shown as pre-requisite )once you will start update in SPAM :-
Apart from these updates, also following Add Ons are required to be uploaded through SAINT (as per the pre-requisite list shown during above updates):-
After update, SW component levels are :-
NB: During updating above patches , you may face “COMPUTE_INT_PLUS_OVERFLOW” error during “DDIC_ACTIVATION” phase. You need to follow below steps to overcome this issue:-
Call Tx SE38 – SDB1FHDB
Select Source Code and Display
Switch to edit mode and replace:
limit-secindcnt = 2147483647.
limit-secindcnt = 1023.
You will require developer key to perform above changes.
3. Now upgrade your MS SQL database as per “http://scn.sap.com/docs/DOC-42596” document.