System

Current SP Level

Confirmed SP Level

SAP ECC 6.0

SP Stack 11

SP Stack 20

SAP ECC 6.0

Kernel 145

Kernel 185

S No

Task

SAP ECC Side
(Yes / No)

SAP BI Side (Yes / No)

How-To

1

Stop V3 Delta Collection Jobs

Yes

No

Stop Delta Collection Jobs in ECC side after executing them manually till the time they bring ZERO records. We can monitor these jobs log and status in SM37 Transaction in ECC side.

2

Clearing the delta queues before the upgrade and trigger delta loads in BI side manially.

Yes

Yes

After executing these delta collection jobs manually, the records will move from extraction queue to delta queue (RSA7).
In RSA7 make sure all the delta Data Sources should remains empty by repetitive triggering of corresponding  Delta Data Loads in BI side.

In BI side, Data Loads Monitor is showing below:

3

All extraction queues and open update orders in all clients must be processed.

Yes

No

Call transaction SMQ1 and check whether all queues in all clients (client = '', queue name 'MCEX') have been processed. To process the queues, start the collective run report for each application in the displayed clients. If we no longer need the data in the BW system, deactivate the relevant extraction queues and DataSource in the LO cockpit (transaction LBWE) and delete the queue entries in transaction SMQ1.

4

Check V3 Update – Serialization issue.

Yes

No

If we use the V3 update that is not serialized (usually only for application 03): Start collective run report RMBWV303. Then check the update orders in transaction SM13. If there are incorrect update orders in transaction SM13, correct the orders and then start the collective run report again. If you no longer require the update orders, you can delete them. There may be inconsistencies between tables VBMOD and VBHDR. For further information about this, see Notes 652310 and 67014.

5

The content of the setup tables must be deleted

Yes

No

Before the upgrade, delete the contents of the setup tables. Execute report RMCEX_SETUP_ENTRIES to find out which setup tables still contain entries.




You can use transaction LBWG to delete the contents of the setup tables for all clients. Unfortunately the check that the system carries out during the upgrade or when you import a Support Package does not display all affected applications. Therefore, Note 1083709 provides a check report that you can use to determine all affected applications and tables or queues.

6

Stop all Process Chains

No

Yes

Remove all Process Chains from schedule.

S No

Task

SAP ECC Side
(Yes / No)

SAP BI Side (Yes / No)

How-To

1

Test the RFC connection between SAP ECC to SAP BI system

Yes

Yes

Check Source system connection in RSA1 à Source Systems.

2

Replication of extractors / Activation of Transfer Rules.

No

Yes

3

List down some sample loads – For master data / Transaction data Full and Deltas.

No

Yes

4

Do a count of the no of records for the loads and reconcile the number with ECC. Run some reports to check data integrity for the above loads.

Yes

Yes

5

Put V3 Delta Collection Jobs back in to schedule.

Yes

No

6

Put all Process Chains in to Schedule.

No

Yes

Activity Description

Phase

1

Open Transports Clean up. Make sure that all transports in DEV system should be released and imported to all downstream systems QA and PRD systems.

Check Open Transports in the system and clean up the same.
o Go to SE10 and check the open transports in the system.

PRE Upgrade

60 mins

2

Check SM13 (Administrate Update Records)

In this transation we can found the update statistics..means update error,which program/function module..etc used to update the db,user etc...if found any update error found we will find out the cause . More information can be found from below path.
[http://help.sap.com/saphelp_nw04/helpdata/en/e5/de870535cd11d3acb00000e83539c3/frameset.htm
]

PRE Upgrade

10 mins

3

Check SMQ1 / SMQ2 & SM58 on BW side.

·        SMQ1 – qRFC Monitor for the outbound queue You use this transaction to monitor the status of the LUWs in the outbound queue and restart any hanging queues manually.
·        SMQ2 – qRFC Monitor for the inbound queue. You use this transaction to monitor the status of the LUWs in the outbound queue.
.        SM58 - Check the tRFC Status.

PRE Upgrade

30 mins

4

Check Open Jobs.

Check SM37 for any scheduled / Active Jobs.

PRE Upgrade

10 mins

5

Check for Inconsistent Infoobjects and repair inconsistent Infoobjects as much as possible.

Check the InfoObjects and repair them if necessary.
o Transaction RSD1 (Edit InfoObjects),
     o Extras > Rapir InfoObjects
     o Execute Repair
     o Expert Mode > Select Objects

o Select following checkboxes:
   • Check Generated Objects
   • Activate Inconsistent InfoObjects
   • Delete DDIC Objects
   • Display Log

o Execute Program.
o Check Log and prepare excel with inconsistent object details. Capture details like - Object Tech name - Description, What is the inconsistency, Any resolution given by SAP in Log.
o If we found any inconsistent InfoObject that exists in the system, execute the report RSDG_IOBJ_ACTIVATE and activate a single InfoObject.

PRE Upgrade

30 mins

6

Finding and fixing Inconsistent DataSource

OSS #579022 (Execute RSAR_TRANSTRUCTURE_CHECK)

PRE Upgrade

10 mins

7

Check Inactive Infoobjects

Check for Inactive InfoObjects and activate.

PRE Upgrade

10 mins

8

All ODS data loads must be activated

Activate all ODS Object where the activation queue is not empty. 
Refer to OSS: #905029 & #861890
RSDG_ODSO_ACTIVATE program
There must be no data load request in the ODS objects with a yellow status. If any such entry is found, delete the request.

PRE Upgrade

10 mins

9

All Transfer and Update rules should be active

Check for inactive Update and Transfer Rules
o All update rules and transfer rules should be active.
Execute ABAP RSUPGRCHECK to locate any inactive Update and Transfer Rules
See SAP note 555717 and 449160.

PRE Upgrade

60 mins

10

All InfoCubes should be active

Check for inactive InfoCubes / Multicubes and Aggregates (Aggregates are InfoCubes too!)
o All InfoCubes should be activated
o Execute ABAP RSUPGRCHECK to locate any inactive InfoCubes
See SAP note 555717 and 449160.

PRE Upgrade

30 mins

11

Save entries from table EDIFCT

Any customer specific entries on this tables that needs to be saved. If there are some, then identify by comparing the entries before and after upgrade, since the upgrade will truncate the table during the upgrade and repopulate it with new entries.  Possibly, try to export these and import them back after the upgrade.

PRE Upgrade

15 mins

12

Check table RSBFILE

Check the table RSBFILE (Open Hub Destinations: Files) for APPEND ENTRIES (Logical file name & Logical system)

PRE Upgrade

15 mins

13

Reschedule process chains. Execute Process Chains

Execute Process Chains and trouble shoot errors if any.

POST Upgrade

60 mins

14

Execute BW Statistics Process chain

1. Execute BW Statistics process chains.
2. Execute sample Standard statistics report to see Query statistics and capture results.

POST Upgrade

10 mins

15

Check Missing Indexes for Cubes (DB02)

You can also list missing indexes using transaction DB02, pushbutton Missing Indexes. If a lot of indexes are missing, it can be useful to run the ABAP reports SAP_UPDATE_DBDIFF and SAP_INFOCUBE_INDEXES_REPAIR. Refer following link information on Misiing Indexes for InfoCube.
http://help.sap.com/saphelp_nw2004s/helpdata/en/80/1a6473e07211d2acb80000e829fbfe/frameset.htm

POST Upgrade

20 mins

16

Remove All Process Chains from schedule.

Check Any Process chains are scheduled to run Daily / Weekly / Monthly and remove all from Schedule.
No process chains should be in schedule mode. Go to RSPC & click on schedule tab & remove the chains from schedule.

PRE Upgrade

10 mins

17

Clean-up Inconsistent PSA directory entries

Execute this program in TCODE SE38. Program Name: RSAR_PSA_CLEANUP_DIRECTORY.
With this function we delete requests from the PSA. This reduces the volume of data in the PSA. It is a good idea to delete incorrect requests or deltas for a data target, to which you do not want to load any more delta.

PRE Upgrade

30 mins

18

Check consistency of PSA partitions.

RSRV - PSA Check.

PRE Upgrade

10 mins

19

Check compounding consistency in Multiproviders.

When MultiProviders are activated, a check is made to establish whether the identification of characteristics and navigation attributes is consistent with respect to compounding.
Report RSCOMPCONS helps you to identify inconsistent MultiProviders. When you execute the report, it lists MultiProviders that are inconsistent with respect to compounding

PRE Upgrade

20 mins

20

Time Characteristics Considerations

Special consideration for modifications to time characteristics  0CURRENCY, 0UNIT, 0DATE, 0DATEFROM, 0DATETO, 0SOURCESYSTEM and 0TIME.

POST Upgrade

15 mins

21

Validate BW Objects.

BW Analyses Tool: RSRV to be run prior to upgrade to check for potential inconsistencies in BW

PRE Upgrade

30 Hrs

22

Ensure DB Statistics are uptodate prior to upgrade.

You can use this BRCONNECT function to update the statistics on the Oracle database for the cost-based optimizer.
BRCONNECT supports update statistics for the following:

·        Partitioned tables, except where partitioned tables are explicitly excluded by setting the active flag in the DBSTATCtable to I. For more information, see SAP Note 424243.
·        InfoCube tables for the SAP Business Information Warehouse (SAP BW)

PRE Upgrade

20 mins

23

Finding and fixing Inconsistent DataSource

OSS #579022 (Execute RSAR_TRANSTRUCTURE_CHECK)

POST Upgrade

30 mins

24

All ODS data loads must be activated

Activate all ODS Object where the activation queue is not empty. 
Refer to OSS: #905029 & #861890
RSDG_ODSO_ACTIVATE program

POST Upgrade

15 mins

25

All ODS data loads must be activated

Activate all inactivated ODS object requests. All ODS 'M' tables must be emptied prior to the upgrade as a new activate process implemented. Inactivated ODS request can be located via the                                                   Administrative workbench -> "Monitoring" -> "ODS Status Overview"

POST Upgrade

15 mins

26

All Transfer and Update rules should be active

Check for inactive Update and Transfer Rules
o All update rules and transfer rules should be active or deleted.
Execute ABAP RSUPGRCHECK to locate any inactive Update and Transfer Rules
See SAP note 555717 and 449160.

POST Upgrade

15 mins

27

All InfoCubes should be active

Check for inactive InfoCubes and Aggregates (Aggregates are InfoCubes too!)
o All InfoCubes should be activated or deleted.
o Execute ABAP RSUPGRCHECK to locate any inactive InfoCubes
See SAP note 555717 and 449160.

POST Upgrade

15 mins

28

Save entries from table EDIFCT

Any customer specific entries on this tables that needs to be saved. If there are some, then identify by comparing the entries before and after upgrade, since the upgrade will truncate the table during the upgrade and repopulate it with new entries.  Possibly, try to export these and import them back after the upgrade.

POST Upgrade

10 mins

29

Check table RSBFILE

Check the table RSBFILE (Open Hub Destinations: Files) for APPEND ENTRIES (Logical file name & Logical system)

POST Upgrade

10 mins

30

Check for possible inconsistencies with RSZ* tables in BW system

Check any inconsistency in the system with RSZ* tables.
Execute the report ANALYZE_RSZ_TABLES.
Correct any such inconsistency.
Also refer SAP Note 792779

PRE Upgrade

10 mins

31

Check Master Data Consistency

Check the consistency of master data objects by executing the report RSDMD_CHECKPRG_ALL. If there is any inconsistency, run the same report with the Repair option.

PRE Upgrade

15 mins

32

Check for invalid temp tables

Check for invalid temp tables from transaction SE14->Extras->Invalid Temp Tables. If an entry exists, delete them from this screen.

PRE Upgrade

10 mins

33

Activate the Myself source system and replicate all datasources.

Reactivate the BI source system. Also replicate all the source system data sources.

POST Upgrade

30 mins

34

Activate all Transfer structures and Update rules.

Execute report RS_TRANSTRU_ACTIVATE_ALL for myself system and the source systems.
Execute the report RSAU_UPDR_REACTIVATE_ALL to activate the update rules.

POST Upgrade

60 mins

35

Migration for BEx history, variables personalization, Web Report Personalization

Execute report RS_PERS_ACTIVATE

POST Upgrade

20 mins

36

Rename the duplicate queries and then delete.  Also correct the other errors.

Execute program ANALYZE_RSZ_TABLES and rename the duplicate queries and then delete

PRE Upgrade

120 mins