Runtime Errors DBIF_RSQL_INVALID_RSQL, Exception CX_SY_OPEN_SQL_DB

Former Member — Tue, 25 Sep 2012 05:48:28 GMT

Hi,

Getting a dump, please help.

Runtime Errors         DBIF_RSQL_INVALID_RSQL
Except.                CX_SY_OPEN_SQL_DB
Date and Time          2012-09-25 07:12:11

Short text
Error in module RSQL of the database interface.

What happened?
Error in the ABAP Application Program

     The current ABAP program "ZMMPRO_SAP_TO_SWING" had to be terminated because it
      has
     come across a statement that unfortunately cannot be executed.

Error analysis
     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 "GET_DATA" "(METHOD)", 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.

Missing RAISING Clause in Interface
    Program                                 ZMMPRO_SAP_TO_SWING
    Include                                 ZMMPRN_SAP_TO_SWING_METHOD
    Row                                     116
    Module type                             (METHOD)
    Module Name                             GET_DATA

Trigger Location of Exception
    Program                                 ZMMPRO_SAP_TO_SWING
    Include                                 ZMMPRN_SAP_TO_SWING_METHOD
    Row                                     169
    Module type                             (METHOD)
    Module Name                             GET_DATA

139              ekpo~txz01 ekpo~netpr ekpo~meins
140              ekpo~infnr ekpo~pstyp ekpo~matkl
141 * Begin of change - HPQC defect 10092 - Subrabas
142              ekpo~ktmng
143 * End of change - HPQC defect 10092.
144 *** Start of Change C39050 on 14/11/2011 by Madhwendra ***
145              ekpo~lgort
146              ekpo~peinh
147 *** End of Change C39050 on 14/11/2011 by Madhwendra ***
148              INTO TABLE li_contract
149              FROM ekko INNER JOIN ekpo
150              ON ekko~ebeln EQ ekpo~ebeln
151 * Begin of change - HPQC defect 10092 - Subrabas
152              WHERE ekko~ekorg IN s_ekorg
153 * End of change - HPQC defect 10092.
154              AND ekko~bstyp EQ lc_doccat
155              AND ekko~bsart EQ lc_doctyp
156              AND ekko~loekz EQ space
157 * Begin of change for CR C48905 - ANANDKAR
158              AND ekko~kdate >= sy-datum
159 * End of change for CR C48905 - ANANDKAR
160              AND ekpo~loekz EQ space
161              AND ekpo~werks IN s_werks.
162 * End of change - HPQC defect 10092.
163       IF sy-subrc IS INITIAL.
164 *Start Of Change Under CR55638 By ChandPra On 24/09/2012.
165         li_contract1[] = li_contract[].
166
167         DELETE li_contract1 WHERE pstyp NE '2'.
168
>>>         SELECT eina~infnr eina~matnr eina~lifnr
170                eine~ekorg eine~esokz eine~werks eine~waers eine~netpr eine~peinh eine~bprme
171                INTO TABLE li_inforec
172
173                FROM eina INNER JOIN eine
174
175                ON eina~infnr EQ eine~infnr
176
177                FOR ALL ENTRIES IN li_contract1
178                WHERE eina~infnr EQ li_contract1-infnr
179
180                AND eina~matnr EQ ekpo-matnr
181                AND eina~lifnr EQ ekko-lifnr
182                OR ( eine~ekorg LIKE 'HU%' AND eine~ekorg EQ 'HU10' )
183                AND eine~esokz EQ '2'
184                AND eine~werks EQ ekpo-werks.
185 *End Of Change Under CR55638 By ChandPra On 24/09/2012.
186
187
188         LOOP AT li_contract INTO wl_contract.
189 IF ekpo-pstyp EQ 2.
190             READ TABLE li_inforec INTO wl_inforec WITH KEY infnr = wl_contract-infnr.
191             IF sy-subrc IS INITIAL.
192              MODIFY li_contract FROM wl_contract TRANSPORTING netpr.
193             ENDIF.
194         ENDIF.

Moderator message : Not enough re-search before posting, discussion locked.

Message was edited by: Vinod Kumar

Re: Runtime Errors DBIF_RSQL_INVALID_RSQL, Exception CX_SY_OPEN_SQL_DB

Former Member — Tue, 25 Sep 2012 05:57:52 GMT

Hi Prakhar,

can u please check final internal table and select query the sequence of fields are not same as data dictionary sequence..

please check

regards

srini

Re: Runtime Errors DBIF_RSQL_INVALID_RSQL, Exception CX_SY_OPEN_SQL_DB

Former Member — Tue, 25 Sep 2012 06:02:36 GMT

Put your internal table source here.

Did you declare werks as TYPE werks or werks_d? Just a thought!

Thanks,

Shambu

Re: Runtime Errors DBIF_RSQL_INVALID_RSQL, Exception CX_SY_OPEN_SQL_DB

Former Member — Tue, 25 Sep 2012 06:06:49 GMT

Hi,

exactly check ur final internal table li_inforec sequence and field declaration.

Re: Runtime Errors DBIF_RSQL_INVALID_RSQL, Exception CX_SY_OPEN_SQL_DB

Former Member — Tue, 25 Sep 2012 06:27:16 GMT

Do i have to fields tp_contract and tp_inforec in the same sequence??

TYPES

: BEGIN OF tp_contract,
ebeln TYPE ebeln,
lifnr TYPE elifn,
waers TYPE waers,
ekorg TYPE ekorg,
ebelp TYPE ebelp,
matnr TYPE matnr,
werks TYPE werks_d,
txz01 TYPE txz01,
netpr TYPE bprei,
meins TYPE bstme,
infnr TYPE infnr,
pstyp TYPE pstyp,
matkl TYPE matkl,
ktmng TYPE ktmng,
END OF tp_contract.

TYPES : BEGIN OF tp_inforec,
infnr TYPE infnr,
matnr TYPE matnr,
lifnr TYPE lifnr,
ekorg TYPE ekorg,
esokz TYPE esokz,
werks TYPE werks_d,
waers TYPE waers,
netpr TYPE netpr,
peinh TYPE einh,
bprme TYPE bprme,
END OF tp_inforec.

Re: Runtime Errors DBIF_RSQL_INVALID_RSQL, Exception CX_SY_OPEN_SQL_DB

Former Member — Tue, 25 Sep 2012 06:35:30 GMT

peinh TYPE einh,

This should be PEINH.

peinh TYPE peinh OR EPEIN,

Thanks,

Shambu

Re: Runtime Errors DBIF_RSQL_INVALID_RSQL, Exception CX_SY_OPEN_SQL_DB

Former Member — Tue, 25 Sep 2012 06:47:48 GMT

declare peinh type epein as per DDIC

topic Re: Runtime Errors DBIF_RSQL_INVALID_RSQL, Exception CX_SY_OPEN_SQL_DB in Application Development and Automation Discussions

Runtime Errors DBIF_RSQL_INVALID_RSQL, Exception CX_SY_OPEN_SQL_DB

Re: Runtime Errors DBIF_RSQL_INVALID_RSQL, Exception CX_SY_OPEN_SQL_DB

Re: Runtime Errors DBIF_RSQL_INVALID_RSQL, Exception CX_SY_OPEN_SQL_DB

Re: Runtime Errors DBIF_RSQL_INVALID_RSQL, Exception CX_SY_OPEN_SQL_DB

Re: Runtime Errors DBIF_RSQL_INVALID_RSQL, Exception CX_SY_OPEN_SQL_DB

Re: Runtime Errors DBIF_RSQL_INVALID_RSQL, Exception CX_SY_OPEN_SQL_DB

Re: Runtime Errors DBIF_RSQL_INVALID_RSQL, Exception CX_SY_OPEN_SQL_DB