Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

BW 7.0 to 7.4 upgrade (Developers perspective)

Hello All,

I know this is a very age old topic, I have gone through some blogs etc. to understand the basic differences between Upgrade process (Technical and Functional upgrade)

I also note that the technical upgrade is more of a combination of Basis activity and developers activity.

Technical upgrade is a version upgrade say from 7.0 SP level to BW 7.4 SP9 (say)

In this case, I would like to know what checks (Pre-upgrade and post upgrade) a developer needs to look at.

There is a lot of Bespoke code in our system (how to make sure all the objects are migrated correctly). We are also looking at upgrading ECC to a different SP level. So what happens to all the Data sources (Enhanced and standard and Generic)

One thing is that if the Data source enhancement is done only like using ZZ<fieldname> while creating the include structure, then only it will be taken care by SAP while doing the upgrade.. I would like to know things like these...so that we can correct all such things (atleast maximum of such things) well in hand.

I have added some points here that I know, can you please add the missing points to the list...

Run report RDSR_PSA_NEWDS_MAPPING_CHECK to check all inconsistencies in Data sources after upgrade..

Regenerate all inconsistent BADI'S

Rreport ENHS_BADI_ANALYZE_GENERATE_ALL OR BADI_RSANALYZE

RSMDATASTATE INCONSISTENCIES CAN BE ANALYZED USING FM RSDDTREX_AFTER_UPGRADE*

To repair compounding Multiprovider run RSCOMPCONS

See several SAP Notes to check SAP standard checks / errors for resolution

Pre Upgrade:

1. Activate all the inactive objects in the system

2. Check the loading performance prior to upgrade.

3. Check reporting performance prior to upgrade.

Post Upgrade:

1. Do the functional testing of the reports. (To check if the reports are running as expected)

2. Check the loading performance after upgrade.

3. Check reporting performance after upgrade.

4. Check inactivated objects.

What other Cut-over activities that I need to look at. What happens to the Data in 7.0 before and after upgrade..Process Chains..etc.

I am thinking, we need to re-initialize all the Loads. (please explain in Detail).

How should I make use of new Info Providers like Composite Providers available in new system...

If we are running on HANA .. Do we need to re-write all the Data source code which is more HANA optimized like replacing simple selects with SQL Script select so that Push down operation is enabled ??

Kind Regards

Krishna

Former Member replied

Hi Krishna,


Pre Upgrate activities:

01 Correct indices of InfoCube fact tables SAP_INFOCUBE_INDEXES_REPAIR

02 Correct partition assignment of PSA requests SAP_PSA_PARTNO_ CORRECT

03 Correct inconsistencies of PSA tables RSAR_PSA_CLEANUP_ DIRECTORY or RSAR_PSA_CLEANUP_ DIRECTORY_MS

04 Correct indexing of partitioned tables RSAR_PSA_PARTITION_ CHECK

05 Correct DataSource segment assignment to PSA RSAR_PSA_NEWDS_ MAPPING_CHECK

06 Check inactive BW objects RSUPGRCHECK

07 Delete data from Table RSIXWWW (preliminary calculations of web reporting components) RSRA_CLUSTER_ TABLE_REORG

08 Delete or reorganize bookmark IDs and view IDs RSRD_BOOKMARK_ REORGANISATION

09 Delete logs of the RS trace tool (RSTT) RSTT_TRACE_DELETE

10 Delete BW statistical data RSDDSTAT_DATA_ DELETE

11 Delete application logs SBAL_DELETE

12 Delete DTP error logs RSO_DTP_ERROR_ LOG_DELETE_UI

13 Delete process chain logs and outdated instances RSPC_INSTANCE_ CLEANUP

14 Delete OLAP cache RSR_CACHE_FULL_ RESET

15 Clean up log records for table changes SCU3, RSTBPDEL

16 TemSe reorganization SP12, RSPO1041

17 Delete old background jobs RSBTCDEL2

18 Delete “abandoned” job logs RSTS0024 SAP Note 666290

19 Reorganize SAP Office documents RSBCS_REORG

20 Delete Old Background Jobs  RSBTCDEL2

21 Delete temporary SAP tables SAP_DROP_TMPTABLES

22 Delete outdated messages, parameters, and temporary DTP data RSBATCH_DEL_MSG_ PARM_DTPTEMP

    DEL_MSG = 3

    DEL_PAR = 3

    DEL_DTP = x

23 Delete DTP error stacks RSB_ANALYZE_ERRORLOG, RSBM_ERRORLOG_DELETE

24 Archiving of BW objects SARA

Post Upgrate

Check RFC Conections---> WE20, WE21

Check Maintain DBA Planning Calendar---> DB13

Execute program---> RS_BW_POST_MIGRATION

Delete inconsistencies in  PSA---> RSAR_PSA_NEWDS_MAPPING_CHECK

Check and Activate all objects---> RSUPGRCHECK

InfoObject: RSDG_IOBJ_ACTIVATE

DSO: RSDG_ODSO_ACTIVATE

InfoCube: RSDG_CUBE_ACTIVATE

MultiProvider: RSDG_MPRO_ACTIVATE

Transformation: RSDG_TRFN_ACTIVATE

DataSource: RSDS_DATASOURCE_ACTIVATE_ALL

DTP: RSBKDTPREPAIR

Update rule: RSAU_UPDR_REACTIVATE_ALL

Transfer structure: RS_TRANSTRU_ACTIVATE_ALL

Check consistence tables---> RSDU_TABLE_CONSISTENCY

Check RZ tables---> ANALYZE_RSZ_TABLES SAP Note 1930178.

Solve  DDIC inconsistency---> RUTMSJOB

Delete Cache Multi providers---> RSR_MULTIPROV_CHECK SAP Note 1626753.

Convert standar infocube to HANA---> RSMIGRHANADB

Activate  JOBS---> BTCTRNS2

Delete Aggregate tables---> RSDU_AGGR_GARBAGE_DEL_HDB

Check Consistences in PSA---> RSAR_PSA_CLEANUP_DEFINITION

Best regards.

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question