RFC exception: system failure

[sap_beginner98]

HI,

I am using RFC_READ_TABLE to fetch fields from LIPS table.(extracting data from ECC to CRM)

the system failure exception is raised and data[] has not been fetched because of this error.

please tell me abt what could be reason for this exception to be raised???

-->error raised when executing this select query statement in RFC_READ_TABLE - FM

SELECT * FROM (QUERY_TABLE) INTO <WA> WHERE (OPTIONS).
IF SY-DBCNT GT ROWSKIPS.
* copy all relevant fields into DATA (output) table
LOOP AT FIELDS_INT.
IF FIELDS_INT-TYPE = 'P'.
ASSIGN COMPONENT FIELDS_INT-FIELDNAME
OF STRUCTURE <WA> TO <COMP>
TYPE FIELDS_INT-TYPE
DECIMALS FIELDS_INT-DECIMALS.
ELSE.
ASSIGN COMPONENT FIELDS_INT-FIELDNAME
OF STRUCTURE <WA> TO <COMP>
TYPE FIELDS_INT-TYPE.
ENDIF.
MOVE <COMP> TO
<D>+FIELDS_INT-OFFSET_DST(FIELDS_INT-LENGTH_DST).
ENDLOOP.
* end of loop at FIELDS_INT
APPEND DATA.
IF ROWCOUNT > 0 AND SY-DBCNT GE ROWCOUNT. EXIT. ENDIF.
ENDIF.
ENDSELECT.

[michael_piesche]

Please use the CODE function when showing coding. It makes it better to read.

SELECT * FROM (QUERY_TABLE) INTO <WA> WHERE (OPTIONS).
  IF SY-DBCNT GT ROWSKIPS.
    " copy all relevant fields into DATA (output) table
    LOOP AT FIELDS_INT.
      IF FIELDS_INT-TYPE = 'P'.
        ASSIGN COMPONENT FIELDS_INT-FIELDNAME
               OF STRUCTURE <WA> TO <COMP>
               TYPE FIELDS_INT-TYPE
               DECIMALS FIELDS_INT-DECIMALS.
      ELSE.
        ASSIGN COMPONENT FIELDS_INT-FIELDNAME
               OF STRUCTURE <WA> TO <COMP>
               TYPE FIELDS_INT-TYPE.
      ENDIF.
      MOVE <COMP> TO <D>+FIELDS_INT-OFFSET_DST(FIELDS_INT-LENGTH_DST).
    ENDLOOP.
    " end of loop at FIELDS_INT
    APPEND DATA.
    IF ROWCOUNT > 0 AND SY-DBCNT GE ROWCOUNT. 
      EXIT. 
    ENDIF.
  ENDIF.
ENDSELECT.

[gasparerdelyi]

Do you have a short dump on the server side?
I would expect the information on the root cause there...

[michael_piesche]

Please be aware, that there are 'known' limitations to using RFC_READ_TABLE where in some instances you cant use RFC_READ_TABLE (e.g. data types, max columns to be selected).

• Instead of posting the SAP coding in the FM RFC_READ_TABLE where the error was thrown, you could have shown the actuall ST22 dump in the ERP system.
• And also, is the error because of the where option, or is it because of a data type that cannot be handled.
• Can you post your OPTIONS and FIELDS values for the FM that lead to the dump? That would have be helpful to reproduce the error.

=> In case your input for RFC_TABLE_READ and especially the query parameters OPTIONS or FIELDS are syntactically wrong, you should be able to correct those based on the ST22 dump in ERP, otherwise, please post all the FM inputs that were used

=> In case you have to select certain data types that cannot be handled by the RFC_READ_TABLE, you most likely will have to write your own custom RFC FM in the ERP system that collects the data for you and exposes it to the calling system.

About limitations of RFC_READ_TABLE see the following SAP notes and also try to google or ask follow up questions:

• 2503119 - Information about function module RFC_READ_TABLE
• 382318 - FAQ|Function module RFC_READ_TABLE

" There are missing informations about the use cases of function module RFC_READ_TABLE.
"  - The scope of function module RFC_READ_TABLE is very restricted. 
"    E.g., due to the fixed maximum row size only smaller tables can be accessed. 
"    There are several data types that cannot be handled, and also
"    there are doubts regarding the Unicode compatibility of the function module.
"  - It's not clear how to manage the authorizations for the external table access.
"  - The function is clearly flagged as "not released for customer"