topic Runtime Error: DBIF_RSQL_INVALID_RSQL in Application Development and Automation Discussions

Runtime Error: DBIF_RSQL_INVALID_RSQL

Former Member — Wed, 18 Dec 2013 06:43:03 GMT

An exception occurred that is explained in detail below.

The exception, which is assigned to class 'CX_SY_OPEN_SQL_DB', was not caught in

procedure "FETCH_DATA" "(FORM)", nor was it propagated by a RAISING clause.

Since the caller of the procedure could not have anticipated that the

exception would occur, the current program is terminated.

The reason for the exception is:

In a SELECT access, the read file could not be placed in the target

field provided.

Either the conversion is not supported for the type of the target field,

the target field is too small to include the value, or the data does not

have the format required for the target field.

SELECT bdzei into CORRESPONDING FIELDS OF TABLE it_bdzei

from pbed

where PDATU in so_date.

SORT it_bdzei ASCENDING.

delete ADJACENT DUPLICATES FROM it_bdzei COMPARING bdzei.

>>>> SELECT matnr werks INTO CORRESPONDING FIELDS OF TABLE it_header "gives dump

FROM pbim

* PACKAGE SIZE 1000

FOR ALL ENTRIES IN it_bdzei

WHERE bdzei = it_bdzei-bdzei and

werks in so_werks and

versb eq p_vers.

Can anyone pls give any suggestions so i can fix this problem?

Re: Runtime Error: DBIF_RSQL_INVALID_RSQL

Former Member — Wed, 18 Dec 2013 06:49:23 GMT

Hi Anushka,

Can you plese share the declaration of IT_HEADER ?

Thanks,

bhaskar

Re: Runtime Error: DBIF_RSQL_INVALID_RSQL

Former Member — Wed, 18 Dec 2013 06:50:58 GMT

Hiii Bhaskar,

TYPES: BEGIN OF ty_header,

matnr TYPE matnr,

plnmg TYPE plnmg,

werks TYPE werks,

END OF ty_header.

data: it_header TYPE STANDARD TABLE OF ty_header,

wa_header LIKE LINE OF it_header.

Re: Runtime Error: DBIF_RSQL_INVALID_RSQL

Former Member — Wed, 18 Dec 2013 07:06:10 GMT

Hi,

It is very simple check your declarations, you have refereed the plant in a wrong way

TYPES: BEGIN OF ty_header,

matnr TYPE matnr,

plnmg TYPE plnmg,

werks TYPE werks_d,

END OF ty_header.

It should work.!

Kiran

Re: Runtime Error: DBIF_RSQL_INVALID_RSQL

Former Member — Wed, 18 Dec 2013 07:09:59 GMT

OMG Kiran, you are so correct! Cant believe i didnt notice

Thank you so very much!

Re: Runtime Error: DBIF_RSQL_INVALID_RSQL

Former Member — Wed, 18 Dec 2013 07:15:17 GMT

Cool, it's human error, some times Happen!!!!