Abap Dump DBIF_RSQL_INVALID_SQL

[Former Member]

Hi Gurus,

I am getting this abap dump DBIF_RSQL_INVALID_SQL and I checked in developer trace it saying: -

B *** ERROR => dbtran ERROR (set_input_da_spec): statement too big

B marker count = 10007 > max. marker count = 9999."

I know this may have posted many times but I didn't found any exact solution.

So how to resolve this issue?

Thanks & Regards,

Harsh Wardhan

[Former Member]

Can you please point out the code extract where the dump is triggered?

Regards

Tanmoy

[Former Member]

Hi Tanmoy,

I have attached the Picture which have the pointer of error code.

Thanks,

Harsh

[nabheetscn]

What input value are you providing in range as input...? Looks like ypur input parameter has too many records...try by reducing the entries in range does it have any duplicate records

[Former Member]

it seems to be an issue with the ranges table that you using in the WHERE clause.

https://scn.sap.com/thread/81418

[sandroramos]

Hi,

Change your select to:

SELECT bukrs

              belnr

              gjahr

              awkey

     FROM bkpf

     INTO CORRESPONDING FIELDS OF TABLE l_i_bkpf <<<<<<<<<<<<< use this

     ...

Regards,

Sandro Ramos

[Former Member]

hi,

harsh wardhan

check the length of variable you declared for select option and parameter maximum length size should be 8 character.

[MariaJooRocha]

Hi,

If your code is OK, and the problem is with the selection, you can use: catch

data: exc_ref TYPE REF TO cx_sy_open_sql_db,
        exc_text(50).

try.               

"     your select code
     catch cx_sy_open_sql_db into exc_ref.
      exc_text = exc_ref->get_text( ).
      message exc_text type 'E'.

  endtry.

Regards,

Maria João Rocha

[Former Member]

Hi All,

For now it is not giving any dump and I have not done any modification.

But I will let you know the updates for next load.

Thanks for valuable comments.

Regards,

Harsh