Skip to Content
Author's profile photo Nilutpal Sharmah

MS SQL Database Upgrade from 2008 R2 to 2012 in Solution Manager 7.1

Hello Friends,

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  ““, 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 :-

Software Component Release Level
SAP_BASIS 702 12
SAP_ABA 702 12
CTS_PLUG 200 5
PI_BASIS 702 12
ST-PI 2008_1_700 7
GW_CORE 200 3
IW_BEP 200 4
SAP_BS_FND 702 10
SAP_BW 702 12
IW_FND 250 3
IW_GIL 100 0
SAP_AP 700 28
BBPCRM 701 9
BI_CONT 706 2
CPRXRPM 500_702 5
ST 710 8
ST-BCO 710 2
SOCO 101 1
ST-A/PI 01N_700SOL 1
ST-ICO 150_700 31
ST-SER 701_2010_1 10

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 “” document.



Assigned Tags

      1 Comment
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Thanks Nilutpal, it's really helpful..!!

      Cheers SCN