topic Re: Abap Dump DBIF_RSQL_INVALID_SQL in Application Development and Automation Discussions

Abap Dump DBIF_RSQL_INVALID_SQL

Former Member — Thu, 26 Dec 2013 16:01:44 GMT

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

Re: Abap Dump DBIF_RSQL_INVALID_SQL

Former Member — Thu, 26 Dec 2013 16:35:10 GMT

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

Regards

Tanmoy

Re: Abap Dump DBIF_RSQL_INVALID_SQL

Former Member — Thu, 26 Dec 2013 16:52:18 GMT

Hi Tanmoy,

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

Thanks,

Harsh

Re: Abap Dump DBIF_RSQL_INVALID_SQL

nabheetscn — Thu, 26 Dec 2013 17:05:50 GMT

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

Re: Abap Dump DBIF_RSQL_INVALID_SQL

Former Member — Thu, 26 Dec 2013 17:17:56 GMT

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

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

Re: Abap Dump DBIF_RSQL_INVALID_SQL

Former Member — Thu, 26 Dec 2013 17:38:29 GMT

hi,

harsh wardhan

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

Re: Abap Dump DBIF_RSQL_INVALID_SQL

MariaJooRocha — Thu, 26 Dec 2013 17:42:50 GMT

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

Re: Abap Dump DBIF_RSQL_INVALID_SQL

sandroramos — Thu, 26 Dec 2013 18:16:22 GMT

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

Re: Abap Dump DBIF_RSQL_INVALID_SQL

Former Member — Fri, 27 Dec 2013 11:56:07 GMT

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