Skip to Content
0
Apr 20, 2010 at 07:10 AM

RFC_ERROR_SYSTEM_FAILURE: Error in module RSQL of the database interface

409 Views

HI All,

I am trying to execute an RFC through JCO connection and getting the error "RFC_ERROR_SYSTEM_FAILURE: Error in module RSQL of the database interface".

While debugging I have found that the actual cause of dump is a SQL command written in this RFC. The SQL command is

SELECT DISTINCT *

INTO CORRESPONDING FIELDS OF TABLE lt_calcrule_hol

FROM itc_calcrule_hol

FOR ALL ENTRIES IN calc_rule

WHERE rule_id = calc_rule-rule_id

AND start_date <= sy-datum

AND end_date >= sy-datum

AND (lv_ident)

AND ( (lv_orgs)

OR location_type = '' ).

Here the value of lv_ident is ======>> ident IN ('US','B2'.........................)

and value of lv_orgs is =========>> location_type IN ('S1','S2',..............................)

location_type and ident are columns in table itc_calcrule_hol .

I have analysed that if I pass around 700 enteries in the lv_ident and lv_ogs then it is working fine.

But if I have more than 900 enteries in these variables then it dumps.

Can anybody let me know what is the issue with the query here.And what could be the solution.

Thanks and Regards,

Reena