topic Dump DBIF_RSQL_SQL_ERROR in Application Development and Automation Discussions

Dump DBIF_RSQL_SQL_ERROR

Former Member — Fri, 29 May 2009 05:07:44 GMT

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

Re: Dump DBIF_RSQL_SQL_ERROR

Former Member — Fri, 29 May 2009 05:11:34 GMT

can u paste the select query here?

Re: Dump DBIF_RSQL_SQL_ERROR

Former Member — Fri, 29 May 2009 05:14:01 GMT

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.

Re: Dump DBIF_RSQL_SQL_ERROR

Former Member — Fri, 29 May 2009 05:15:46 GMT

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

Re: Dump DBIF_RSQL_SQL_ERROR

Former Member — Fri, 29 May 2009 05:21:49 GMT

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

Re: Dump DBIF_RSQL_SQL_ERROR

Former Member — Fri, 29 May 2009 05:55:45 GMT

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

Re: Dump DBIF_RSQL_SQL_ERROR

Former Member — Sat, 30 May 2009 02:10:19 GMT

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

Re: Dump DBIF_RSQL_SQL_ERROR

Former Member — Mon, 01 Jun 2009 18:40:49 GMT

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