Skip to Content

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

/wp-content/uploads/2013/08/1_260420.jpg

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.

To report this post you need to login first.

1 Comment

You must be Logged on to comment or reply to a post.

Leave a Reply