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

[Former Member]

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  "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 :-

SAP_ABAP

WEBCUIF

BBPCRM

BI_CONT

SAP_BS_FND

ST-SER

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):-

GW_CORE

IW_BEP

CTS_PLUG

IW_FND

IW_GIL

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
WEBCUIF	701	9
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.

with

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.

Regards,

Nilutpal.