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