Dump DBIF_RSQL_SQL_ERROR

[Former Member]

Hi All,

I am getting a Dump DBIF_RSQL_SQL_ERROR in a select query which fetches data from BKPF table. The database error text is ........: "ORA-01555: snapshot too old: rollback segment number 14 with name "_SYSSMU14$" too small" . Kindly suggest a solution.

Thanks and Regards,

John

[Former Member]

can u paste the select query here?

[Former Member]

Hi,

This is the select query,

select (bkpf_fields) from bkpf into

corresponding fields of bkpf

where bukrs in br_bukrs

and blart in br_blart

and budat in br_budat

and xblnr in br_xblnr

and belnr in br_belnr

and gjahr in br_gjahr

and bstat in br_bstat

and awtyp in br_awtyp

and awkey in br_awkey

and awsys in br_awsys

and cpudt in br_cpudt

and bldat in br_bldat

and usnam in br_usnam

and (bkpf_where)

order by primary key.

if bkpf-bstat eq 'D'.

select single * from bkdf

where bukrs eq bkpf-bukrs

and belnr eq bkpf-belnr

and gjahr eq bkpf-gjahr.

endif.

save_bukrs = bkpf-bukrs.

save_belnr = bkpf-belnr.

save_gjahr = bkpf-gjahr.

cnt_bkpf = cnt_bkpf + 1.

b0sg-xarbl = space.

perform t001_read.

• expiring currencies:

gd_waers_save = bkpf-waers.

if not gd_expcur_flag is initial.

perform item_curr_convert_bkpf using 'SAPDBBRF'

sy-datlo

changing bkpf.

endif.

put bkpf.

endselect.

Thanks.

[Former Member]

Hi,

Please change your query as follows:-

select (bkpf_fields) 
from bkpf into
corresponding fields of bkpf
where bukrs in br_bukrs
and belnr in br_belnr
and gjahr in br_gjahr
and blart in br_blart
and bldat in br_bldat
and budat in br_budat
and cpudt in br_cpudt
and usnam in br_usnam
and xblnr in br_xblnr
and bstat in br_bstat
and awtyp in br_awtyp
and awkey in br_awkey
and awsys in br_awsys
and (bkpf_where)
order by primary key.

Also please check the fields which are coming in bkpf_fields and the where clause bkpf_where to see if there isnt any mismatch in fields.

Regards,

Ankur Parab

[Former Member]

Hi,

Please check ur select query. Check if the sequence, data type and number of fields that u are selecting matches ur target internal table or work area.

Regards,

Nikhil

[Former Member]

Hi All,

Thanks for your reply.

The above query is in standard report SAPDBBRF and also this dump has occured for a particular variant. Just wanted to confirm whether this dump is because of huge amount of data or varaint problem.

Thanks,

John

[Former Member]

Yes. I think so. It is because you get a huge result, and the system has no enough (temporary) space to write the data. You can increase you DB space to avoid this problem.

Hope this is helpful to you.

Jonas

[Former Member]

John,

You may want to take a look at OSS Note 731946 - DBIF_RSQL_SQL_ERROR when inserting a type P variable in DB.

I ran into it while investigating my DBIF error.

Hope it helps your case.

Fred