Skip to Content
author's profile photo Former Member
Former Member

RUN_RSDRI_QUERY- STRING_SIZE_TOO_LARGE dump

Hello! I am using the RUN_RSDRI_QUERY to retrieve data from a cube instead of using the ct_data because I am reading data inside a different cube. Inside this method, there is a call to CL_SQL_STATEMENT-> EXECUTE_PROCEDURE where a CALL 'C_DB_FUNCTION' is throwing a dump saying

"STRING_SIZE_TOO_LARGE in CL_SQL_STATEMENT==============CP. A string with a length 2426823974 (bytes) was about to be created.

However, this length exceeds the maximum size possible for a string of 2145386496."

I read a note '2030938' but it is for a different program "CL_UJK_LOGGER=================CP". I tried to implement the same correction but it still doesn't work. This is how I am calling the method. The dump doesn't occur in Dev.

CALL METHOD lo_query->run_rsdri_query

EXPORTING

it_dim_name = lt_dim_list " BPC: Dimension List

if_check_security = abap_false " BPC: Generic indicator

IMPORTING

et_data = <lt_result>

et_message = lt_message. " BPC: Messages

CATCH cx_ujo_read. " Exception of common read

ENDTRY.


Any suggestions please?


Regards,

Kiran

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on Nov 23, 2015 at 06:31 PM

    Hello,

    Have you seen Note 2188345

    Best Regards,

    Leila

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi,

      use it_range to filter your selection.

      this is how to create for the range

      ls_sel-dimension = 'material'.

      ls_sel-sign = 'I'.

      ls_sel-option = 'EQ'.

      ls_sel-low = 'member_name'.

      APPEND ls_sel TO lt_selection.

      lo_query->run_rsdri_query(

      EXPORTING

      it_dim_name = lt_dim_name " BPC: Dimension List

      it_range = lt_selection " BPC: Selection condition

      if_check_security = abap_false " BPC: Generic indicator

      IMPORTING

      et_data = <lt_query_result>

      ).

      Andy

  • author's profile photo Former Member
    Former Member
    Posted on Feb 16, 2016 at 08:35 PM

    I am closing this discussion and awarding points. Thanks for all the responses.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.