BW 7.0 to 7.4 upgrade (Developers perspective)
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
1. Activate all the inactive objects in the system
2. Check the loading performance prior to upgrade.
3. Check reporting performance prior to 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 ??
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
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
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