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

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.