System refresh from production and init load settings

[Former Member]

We are carrying out a refresh from production. With the refresh does the init value come across as part of the InfoPackages if it exists and thereafter can I carry out delta loads with these settings

Thanks

[Former Member · Accepted solution]

Hi Niten,

if there are probs (like we often had with inits after refresh) look at oss 424848:

P18:SDL:Init sels in source sys lost after upgrade Symptom

After the BW upgrade from 1.2B to 2.0B or 2.1C or after an upgradeof an OLTP from an R/3 release lower than 40B to an R/3 release version 40B or higher, the Init selections in the source system in tables ROOSPRMSC and ROOSPRMSF are not filled because these were not filled for BW 1.2 or for an OLTP release lower than 4.0B, but are required for a BW 2.0/2.1 or for an OLTP release version 4.0B or higher. For this reason, the MESSAGE_TYPE_X short dump may occur when you maintain InfoPackages.

This dump also occurs if a backup was imported in BW or in the source systembecause the administrative information of the roosprmsc/f- tables no longer corresponds to the equivalent BW management tables rssdlinit/sel.

In addition, the dump may occur if the delta administration was deleted in the source system.

Other terms

'RSSM_OLTP_INIT_DELTA_UPDATE',dump in the scheduler in the ABAP program "SAPLRSS1", perform "RSM1_CHECK_FOR_DELTAUPD", row 1271, LRSSMU36

Reason and Prerequisites

The problem is caused by a program error.

Solution

To receive delta initializations in the source system and immediatelybe able to request deltas, run the 'RSSM_OLTP_INIT_DELTA_UPDATE' report for the DataSource and the source system for which the Init selections are transferred from BW to the ROOSPRMSC and ROOSPRMSF tables in the source system so that the delta can continue. The report is provided with Support Package 18 for BW 2.0B or Support Package 10 for BW 2.1C.

BW2.0B

ImportSupport Package 18 for Release 2.0B (BW2.0B Patch 18 or SAPKW20B18) into your BW system. The Support Package will be available when N ote 414720, "SAPBWNews BW 2.0B Support Package 18", which describes this Support Package in more detail, has been released for customers.

BW2.1C

Import Support Package 10 for 2.1C (BW2.1C Patch 10 or SAPKW21C10 ) into yourBW system. The SupportPackagewill be available when N ote 414725, "SAPBWNews BW 2.1C Support Package 10", has been released for customers.

The report specified above is available after this patch.

The report is always available for BW 3.X.

/manfred

Caution:

Youcanuse this report ONLY if NOTHING is entered for this DataSource/source system in source system tables roosprmsc and roosprmsf.

If there are entries in the source system that do NOT correspond to the entries in the rssdlinitand rssdlinitsel tables in BW, you must NOT use this report but must instead try to determine the reason for the discrepencies.

Then create a customer message if you are unable to eliminate the discrepencies yourself.

Refer to Note 110934, which contains information about BW Support Packages.

[Former Member]

Hi Niten,

Yes..All the data would come across. Generally the refresh is done simultaneouly on both the R/3 and BW system. If your BASIS has maintained the settings then you should be able to do the delta load.

Just check with your BASIS.

Bye

Dinesh

[Former Member]

Thanks for that so just to recap:

1) Refresh will bring the data

2) If the InfoPackage is a Delta and has been initialised I can run that same delta package on the refreshed system and no dependency is required on whether the system now is not the original production OLTP?