A SQL error occured when accessing the table ?

[Former Member]

Hi all

I check SAPMMC work process list everying is look green, JAVA + Java + dispatcher + Messages everying ok but, when I try to connect SAP GUI, I got an error:

ABAB Runtime Error Error Code (nothing is there), and buttom line of window this messages:

SQL error in the database when accessing a table.

What should I do ?

I am not sure is that basis job or Oracle, but error look like Oracle

Thanks in Advance

Satheesh E

[stefan_koehler]

Hi Satheesh,

> What should I do ?

Posting the OCI / SQL error would be a great start ... it can be found in the corresponding SAP work process trace file.

Regards

Stefan

[Former Member]

I am not sure what is OCI / SQL errorso  Can you explain in detail.

[Former Member]

Just share dev_w0 log file (Only errors).

Regards,

Nick Loy

[Former Member]

*** ERROR => ORA-1552 occured when executing SQL statement (parse error offset = 0)

[dbsloci.c    11082]

C  sc_p=04346A08,no=40,idc_p=043548D4,con=0,act=1,slen=285,smax=512,#vars=13,stmt=1CC04158,table=BTCCTL                       

C  prep=0,lit=0,nsql=0,lobret=0,#exec=1,dbcnt=0,upsh_p=00000000,ocistmth_p=1CC05074

C  IN : cols=13,rmax=1,xcnt=1,rpc=0,rowi=0,rtot=1,upto=-1,rsize=155,vmax=32,bound=1,iobuf_p=0436CB18,vda_p=1CC064D8

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

C  OUT: cols=0,rmax=0,xcnt=0,rpc=0,rowi=0,rtot=0,upto=0,rsize=0,vmax=0,bound=0,iobuf_p=00000000,vda_p=00000000

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

C  UPDATE "BTCCTL" SET "BTCSYSTEM" = :A0 , "TIMSTMPDT" = :A1 , "TIMSTMPTM" = :A2 , "TRACELEVEL" = :A3 ,\

C   "TRCTIMSTDT" = :A4 , "TRCTIMSTTM" = :A5 , "TRCCHUSR" = :A6 , "OPMODE" = :A7 , "OPMODTSTDT" = :A8 , \

C  "OPMODTSTTM" = :A9 , "OPMODCHUSR" = :A10 WHERE "BTCSERVER" = :A11 AND "CTLOBJ" = :A12;

B  ***LOG BY4=> sql error 1552   performing UPD on table BTCCTL     [dbtrtab#1 @ 3948] [dbtrtab 3948 ]

B  ***LOG BY0=> ORA-01552: cannot use system rollback segment for non-system tablespace 'PSAPIDS' [dbtrtab#1 @ 3948] [dbtrtab 3948 ]

A  TH VERBOSE LEVEL FULL

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

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

[dbsloci.c    11082]

C  sc_p=043468D8,no=36,idc_p=00000000,con=0,act=1,slen=254,smax=256,#vars=16,stmt=1CBFB848,table=SNAP                         

C  prep=0,lit=0,nsql=1,lobret=0,#exec=1,dbcnt=0,upsh_p=00000000,ocistmth_p=1CBFC664

C  IN : cols=16,rmax=1,xcnt=1,rpc=0,rowi=0,rtot=1,upto=-1,rsize=1666,vmax=32,bound=1,iobuf_p=0436CB18,vda_p=1CBFDAC8

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

C  OUT: cols=0,rmax=0,xcnt=0,rpc=0,rowi=0,rtot=0,upto=0,rsize=0,vmax=0,bound=0,iobuf_p=00000000,vda_p=00000000

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

C  INSERT INTO SNAP (DATUM, UZEIT, AHOST, UNAME, MANDT, MODNO, SEQNO, XHOLD, FLIST, FLIST02, FLIST03, F\

C  LIST04, FLIST05, FLIST06, FLIST07, FLIST08) VALUES ( :A0 , :A1 , :A2 , :A3 , :A4 , :A5 , :A6 , :A7 ,\

C   :A8 , :A9 , :A10 , :A11 , :A12 , :A13 , :A14 , :A15 );

B  ***LOG BY2=> sql error 1552       performing EXE        [dbds#3 @ 798] [dbds    0798 ]

B  ***LOG BY0=> ORA-01552: cannot use system rollback segment for non-system tablespace 'PSAPIDS' [dbds#3 @ 798] [dbds    0798 ]

A 

A  ** RABAX:  level LEV_SN_C_STACK failed.

A  Sun Sep 03 09:55:26 2006

A 

A  ABAP/4 Program SAPMSSY2                                .

A  Source RSBTCTRC                                 Line 131.

A  Error Code DBIF_RSQL_SQL_ERROR.

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

A  Function HandleRsqlErrors Line 777.

A  An SQL error occurred when accessing a table..

A 

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

[Former Member]

Hi,

Go through the below link.

ORA-01552: cannot use system rollback segment for non-system tablespace "string" t...

Regards,

Nick Loy

[Former Member]

What oracle version do you have running?

[Former Member]

Hi Satheesh,

Could you provide the output of the statement, below;

SQL> select tablespace_name, segment_name from dba_rollback_segs;

As far as I understand that you are running on old release and the system does not able to use rollback segments.

On the new releases, rollback segments stored on PSAPUNDO and SYSTEM tablespaces.

Best regards,

Orkun Gedik

[Former Member]

Oracle 9i

[Former Member]

[Reagan]

Hello

Check the Oracle alert log for more details.

Regards

RB

[Former Member]

can you please tell me where i can find oracle logs.