Error 6 in function module RSS_PROGRAM_GENERATE Message no. RJ028

The below error has been encountered in the extract checker(RSA3).

Error 6 in function module RSS_PROGRAM_GENERATE
Message no. RJ028

https://websmp130.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/sapnotes/index2.htm?numm=705212

SNOTE: 705212

Summary

Symptom

You notice the error by one of the following symptoms:

• The loading of transaction data from an R/3 system terminates with a syntax error in the generated extraction program. The monitor displays the error messages:

                       R3027 "Error & during the generation of the data transfer program"

                       RSM340 "Error in the source system"

• The extraction within the extractor checker terminates with error message RJ028 "Error 6 in function module RSS_PROGRAM_GENERATE".

• The activation of transfer rules ends in BW with error message RG102 "Syntax error in GP$ERR$, row... (-> long text)" from the source system. Usually, the diagnosis in the long text of the error message is: "...could not be interpreted. Possible error causes: Incorrect notation or... "

Other terms

OLTP, extractor, data extraction, DataSource, Service API, SAPI,
R3 027, R3 27, RSM 340, RJ 028, RJ 28

Reason and Prerequisites

The error only occurs in the source system, if this contains Basis Release 3.1I and Service API (SAPI) 3.0C Support Package 6. SAPI 3.0C Support Package 6 is contained, for example, in PI 2003.1 Support Package 7 (see attached composite SAP note 673002).

Solution

To correct the problem you need service API 3.0C Support Package 7 in the affected source system. The attached composite SAP note 704971 explains in which software components service API 3.0C is contained, and what the corresponding Support Packages of these components are.
Alternatively, you can also copy the advance correction from the appendix.
Only the source system is affected by the correction, and not the BW system.

Note:

Do not use transaction RSA3 for testing or checking the extraction of "HIERARCHY" datasources. This transaction is not meant for checking hierarchies, as it can lead to the exact error you have mentioned above.

You need to use the program "RSA1HCAT" to check hierarchies, and you will be able to display the following:

1.Meta data

2.Hierarchy tree

3.Hierarchy list

"RSA1HCAT" is a pure display report which cannot change the hierarchy, and will not influence the display in RSA3. It does not change whether the error is given or not in RSA3.