Thursday, March 28, 2013

Program : Display Transformation Metadata

Purpose:

While transporting developed objects from one system to another system, transport request might fail due to following reason (for example)

  • Dependent objects missed or inactive in target system

Error details would be more technical format as like below

Routine set to inactive N6LZSYWU4B5BM8TBEHHQX493

Here we don't know what is N6LZSYWU4B5BM8TBEHHQX493 and which routine it is.

In such a case to see Meta data for one particular TRANSFORMATION use following ABAP program

RSTRAN_DDIS

1. Se38--> Execute RSTRAN_DDIS

2 Provide Transformation ID and Execute


Output:



Monday, March 4, 2013

Short Dump (MESSAGE_TYPE_X) while trying to open an Info package.

Issue: MESSAGE_TYPE_X short dump while trying to create or open an Infopackage.

please follow the instructions in the below note which will resolve the issue.

When an Init data load fails for an Infopackage. Sometimes you end up getting short dumps when running the infopackage.
When init fails and you have to reset the init conditions . The symptoms for the same ar a Message Type X dump when trying to open the info package with a dump in RSM1_CHECK_FOR_DELTAUPD
do the following :
In the BW System:
Tables RSSDLINIT and RSSDLINITSEL have the init conditions stored. Delete these records from BW.
In SAp R/3
Tables ROOSPRMSF and ROOSPRMSC have the init conditions - delete these entries.
Now you can open your infopackage.
For  program RSSM_OLTP_INIT_DELTA_UPDATE in the BW system further information can be found in
note 852443 Dump in include LRSSMU36/RSSM_OLTPSOURCE_SELECTIONS.

 Note 852443 - Dump in include LRSSMU36/RSSM_OLTPSOURCE_SELECTIONS

Summary
Symptom
If a MESSAGE_TYPE_X runtime error occurs in the LRSSMU36 include program in the SAPLRSSM ABAP program of the RSSM_OLTPSOURCE_SELECTIONS function module, proceed as described in the solution below.
This dump occurs if you try to open an InfoPackage for a DataSource/source system combination for which an initialization terminated incorrectly and a new INIT with overlapping selections was executed without the delta-administration being cleaned up.

The dump can also occur if you import a system copy/backup into only one of the two BW/OLTP systems without first deleting all delta queues for this BW/OLTP combination because the delta administration is always inconsistent.

A similar dump occurs in
perform "RSM1_CHECK_FOR_DELTAUPD in the LRSS1F11 include if the source system does not recognize any more inits (the roosprmsc and roosprmsf tables are empty) but if there are still entries in the RSSDLINIT/RSSDLINITSEL tables in the BW system.
This is the same as the problem described in Notes 424848 and 591382.
Other terms
Dump, include LRSSMU36, RSSM_OLTPSOURCE_SELECTIONS, MESSAGE_TYPE_X
Init, delta queue, system copy, backup, initialization, InfoPackage
RSM1_CHECK_FOR_DELTAUPD, LRSSMU36, LRSS1F11
RSSDLINIT, RSSDLINITSEL, RSSM_OLTP_INIT_DELTA_UPDATE
Reason and Prerequisites
This problem is caused by a program error.
Solution

If you load from an OLTP system, you can simply implement the solution described below because transaction RSA7 is used for delta administration and for deleting.
For a DataMart, you may have to delete using transaction SE16 or a native SQL.
    1. The entries for the initialization in the BW system are contained in the RSSDLINIT table for the DataSource/source system combination. Compare these with the entries in the ROOSPRMSC table in the OLTP system.
    2. If there are NO entries in the RSSDLINIT table in BW, use transaction RSA7 to delete the delta queue for this DataSource/BW application combination in the source system (OLTP). For a DataMart source system, manually delete the entries in the ROOSPRMSC and ROOSPRMSF tables for your DataSource using transaction SE16 or a native SQL on the database. A DataMart can be identified by the DataSource that starts with '8', and by the fact that you CANNOT find it in RSA7 of the source system.
    3. If the RSSDLINIT table in the BW system already contains entries, check the requests listed there in the RNR column in the monitor (transaction RSRQ). Compare these entries with the entries in the ROOSPRMSF and ROOSPRMSC tables with the INITRNR field. If, in the ROOSPRMSF and ROOSPRMSC tables for your DataSource source system combination, there are more entries with different INITRNR numbers, use transaction RSA7 in an OLTP source system to delete all entries and then use the RSSM_OLTP_INIT_DELTA_UPDATE report mentioned in the next section. For a DataMart source system, delete the entries that you cannot find in the RSSDLINIT table using the procedure described above.
    4. Read also Notes 591382 and 424848. The errors described there also occur if you delete entries using transaction RSA7 in the source system but there is no RFC connection to the BW system. In the source system, there are no more entries in the ROOSPRMSC and ROOSPRMSF tables, but in the BW system, there are still entries in the RSSDLINIT and RSSDLINITSEL tables. Execute the RSSM_OLTP_INIT_DELTA_UPDATE report and then delete all init selections in the 'Scheduler/Init selections in the source system' menu in the InfoPackage.
    5. When you have completed this procedure, you should be able to create a new InfoPackage or open an InfoPackage.

You can then open the InfoPackage again.
Check that there are no more entries in the
'Scheduler'/'Initialization options for source system' menu

If you do find some entries, delete them.

You can then start a new initialization.

If, despite the first incorrect init, you want to be able to create a second init with overlapping selections, which means that this dump will then occur, enter a detailed description of your procedure in a customer message and send it to Development. SAP has never been able to reproduce this behavior, therefore, a great deal of testing and the option to debug in your system would be required.

Deviation of seconds between qRFC counter and current time


Error:
Deviation of seconds between qRFC counter  and current time

Scenario:
While trying to perform Init with data transfer, the process is getting terminated with the below error message.

Deviation of 1,431 seconds between qRFC counter 000012983760510000060000 and current time 22.02.2011 RSQU 101     
Deviation of 172 seconds between qRFC counter 000013619012840000010000 and current time 26.02.2013 17:51:52

Cause:
The error caused because of the time difference between the Application serve of Source system and DS server of source system.
Also time difference between BW system and ECC system.
Solution:
To synch the times between the server and systems , just run the report Program :RSDBTIME. This program will check the time Inconsistencies between ECC n BW systems.