ORA-1555 occurred when executing SQL statement (parse error offset=0)

[Former Member]

Hi everyboby!

I got the next error:

M Tue Jan 13 22:01:49 2009

M *** WARNING => big time diff 1847371666 [522181345 2369553011]for stamp STAT_READSEQ, correct ???

C *** ERROR => ORA-1555 occurred when executing SQL statement (parse error offset=0)

[dbsloci.c 11440]

C sc_p=104f44910,no=232,idc_p=0,con=0,act=1,slen=176,smax=256,#vars=9,stmt=105ceccd0,table=COVP

C SELECT * FROM "COVP" WHERE "MANDT" = :A0 AND "KOKRS" = :A1 AND "BUZEI" BETWEEN :A2 AND :A3 AND "PERI\

C O" = :A4 AND "GJAHR" = :A5 AND "BUKRS" = :A6 AND "KSTAR" BETWEEN :A7 AND :A8;

C sc_p=104f44910,no=232,idc_p=0,con=0,act=1,slen=176,smax=256,#vars=9,stmt=105ceccd0,table=COVP

C prep=0,lit=0,nsql=0,lobret=0,#exec=1,dbcnt=7616,upsh_p=0,ocistmth_p=105ced938

C IN : cols=9,rmax=1,xcnt=0,rpc=0,rowi=0,rtot=0,upto=4294967295,rsize=44,vmax=32,bound=1,iobuf_p=105468cc0,vda_p=105cedf10

C lobs=0,lmax=0,lpcnt=0,larr=0,lcurr_p=0,rret=0

C OUT: cols=111,rmax=56,xcnt=56,rpc=1,rowi=56,rtot=7617,upto=4294959679,rsize=933,vmax=128,bound=1,iobuf_p=105101170,vda_p=1061b228

C lobs=0,lmax=0,lpcnt=0,larr=0,lcurr_p=0,rret=0

C SELECT * FROM "COVP" WHERE "MANDT" = :A0 AND "KOKRS" = :A1 AND "BUZEI" BETWEEN :A2 AND :A3 AND "PERI\

C O" = :A4 AND "GJAHR" = :A5 AND "BUKRS" = :A6 AND "KSTAR" BETWEEN :A7 AND :A8;

B ***LOG BY4=> sql error 1555 performing FET on table COVP [dbtran#3 @ 7275] [dbtran 7275 ]

B ***LOG BY0=> ORA-01555: snapshot too old: rollback segment number 105 with name "_SYSSMU105$" too small [dbtran#3 @ 7275] [dbtran

B dbtran ERROR LOG (hdl_dbsl_error): DbSl 'FET'

B RSLT: {dbsl=99, tran=1}

B FHDR: {tab='COVP', fcode=225, mode=2, bpb=0, dbcnt=7615, crsr=1,

B hold=0, keep=1, xfer=2, pkg=0, upto=0, init:b=0,

B init:p=0, init:#=897, wa:p=0, wa:#=897}

B dbtran ERROR LOG (hdl_dbsl_error): DbSl 'FET'

B STMT:

B CRSR: {tab='COVP', id=1, hold=0, prop=0x11000, max.in@0=1, fae:blk=1,

B con:id=0, con:vndr=5, val=2,

B key:#=4, xfer=2, xin:#=0, row:#=7615, upto=0, wa:p=10648b6f7}

A TH VERBOSE LEVEL FULL

M ***LOG R68=> ThIRollBack, roll back () [thxxhead.c 12304]

A

A Tue Jan 13 22:01:50 2009

A Tue Jan 13 22:01:50 2009

A

A ABAP/4 Program ZPFI_GASTOREAL_SPPI .

A Source ZPFI_GASTOREAL_SPPI Line 167.

A Error Code DBIF_RSQL_SQL_ERROR.

A Module $Id: //bas/640_REL/src/krn/runt/absapsql.c#13 $ SAP.

A Function HandleRsqlErrors Line 756.

A An SQL error occurred when accessing a table..

A

M ***LOG R68=> ThIRollBack, roll back () [thxxhead.c 12304]

I'll appreciate your help.

Thanks for all.

[Former Member]

Please check the note 60233; this may help