Need a solution for this dump - DBIF_RSQL_INVALID_RSQL

[Former Member]

Runtime Errors DBIF_RSQL_INVALID_RSQL

Exceptn CX_SY_OPEN_SQL_DB

The termination occurred in the ABAP program "ZHR_RPUAUD00" in

"GET_QUALIFICATION_DELTA".

The main program was "ZHR_RPUAUD00 ".

The termination occurred in line 166 of the source code of the (Include)

program "ZHR_RPUAUDFR_02"

of the source code of program "ZHR_RPUAUDFR_02" (when calling the editor 1660).

The program "ZHR_RPUAUD00" was started as a background job.

Job name........ "ZHR_BMA_DELTA_INTERFACE"

Job initiator... "XIRFC_GX0GH1"

Job number...... 23001000

Processing was terminated because the exception "CX_SY_OPEN_SQL_DB" occurred in

the

procedure "GET_QUALIFICATION_DELTA" "(FORM)" but was not handled locally, not

declared in the

RAISING clause of the procedure.

The procedure is in the program "ZHR_RPUAUD00 ". Its source code starts in line

44

of the (Include) program "ZHR_RPUAUDFR_02 ".

The error occured at this query..

SELECT objectid udate utime username FROM c

INTO TABLE tb_cdhdr

WHERE objectclas EQ co_hr_it1001

AND objectid IN ra_pernrange

AND udate >= g_last_run_date

AND utime >= g_last_run_time

AND username IN so_uname

%_HINTS ORACLE 'INDEX("CDHDR" "CDHDR~Z02")'

I verified the field sizes and they are proper. Is this due to memory?? Plz help...

[GauthamV]

Try to use for all entries in your select statement.

[Former Member]

Could this be a problem with memory?.. Do u need any inputs from my end to judge this?... Coz i am using cursors in this program..

Also in the user ran three instances of the variant,

1. personnel sub area AU83. Program runs successfully without program exception

2. personnel sub area AU73. Program runs successfully without program exception

3. personnel sub area AU73 and AU83. Program Fails with Program exception (current job variant)

[Sm1tje]

Looks like a memory problem to me, but It could also be caused by the range you are using. Number of entries in a range is limited. So exceeding a certain complexity within the range can cause runtime errors as well. But my first guess is memory issue.

[Former Member]

hi,

Yes,its a memory issue.please contact your basis consultant.

Even when i used one condition in select statement,its was given same error.

[Former Member]

Is there any way I can confirm this as I need to provide the user with a solution?...

Thanks for your help.

[Former Member]

Hi,

For memory analysis refer SAP Note 649327 - Analysis of memory consumption

Regards

[ThomasZloch]

This could be helpful:

Please quote the section "error analysis" of a short dump next time, this is more informative than what you quoted here.

Thomas

[Former Member]

Hi

I modified the query for the problem,

SELECT objectid udate utime username FROM cdhdr

INTO TABLE tb_cdhdr

FOR ALL ENTRIES IN it_pernrange " M14 - INS -

WHERE objectclas EQ co_hr_it1001

• AND objectid IN ra_pernrange " M14 - DEL -

AND objectid EQ it_pernrange-range

AND udate >= g_last_run_date

• AND utime >= g_last_run_time

AND username IN so_uname

%_HINTS ORACLE 'INDEX("CDHDR" "CDHDR~Z02")'

However, on debugging the code I found that it_pernrrange has a value but it_pernrange-range does not contain any value.. Plz suggest if I;ve done something wrong here.. I am not able 2 figure out the problem.