SQL error in the database when accessing table

Read only

1,472

SAP Managed Tags
SAP ERP

Hi,

When i am trying to save a user in su01, i am getting the error as " SQL error in the database when accessing a table.

Please suggest me the solution.

Regards

Karunakar

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Hi,

may I know error details, on which table you are getting error

regards,

balaram

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Hi,

I am getting the error as in the developer trace of work process as below

ed Mar 31 17:51:16 2010

C OCI-call failed with -1=OCI_ERROR

C SQL error 600: 'ORA-00600: internal error code, arguments: [ktspgfb-1], [], [], [], [], [], [], []'

C *** ERROR => Error 600 in stmt_execute() from oci_execute_stmt(), orpc=0

[dbsloci.c 12650]

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

[dbsloci.c 12652]

C sc_p=05DF4DEC,no=39,idc_p=00000000,con=0,act=1,slen=254,smax=256,#vars=16,stmt=05ECDC08,table=SNAP

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 );

C sc_p=05DF4DEC,no=39,idc_p=00000000,con=0,act=1,slen=254,smax=256,#vars=16,stmt=05ECDC08,table=SNAP

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

C IN : cols=16,rmax=1,xcnt=1,rpc=0,rowi=0,rtot=1,upto=-1,rsize=3334,vmax=32,bound=1,iobuf_p=05ECE618,vda_p=20068088

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 600 performing EXE [dbds#1 @ 798] [dbds 0798 ]

B ***LOG BY0=> ORA-00600: internal error code, arguments: [ktspgfb-1], [], [], [], [], [], [], [] [dbds#1 @ 798] [dbds 0798 ]

A ** RABAX: level LEV_SN_C_STACK failed.

A ** RABAX: level LEV_RX_WRITE_SNAP entered.

A ** RABAX: level LEV_RX_WRITE_SNAP completed.

A ** RABAX: level LEV_RX_WRITE_SNAP_END entered.

A ** RABAX: level LEV_RX_WRITE_SNAP_END completed.

A ** RABAX: level LEV_RX_SET_ALERT entered.

A ** RABAX: level LEV_RX_SET_ALERT completed.

A ** RABAX: level LEV_RX_COMMIT entered.

A ** RABAX: level LEV_RX_COMMIT completed.

A ** RABAX: level LEV_RX_SNAP_SYSLOG entered.

A ** RABAX: level LEV_RX_SNAP_SYSLOG completed.

A ** RABAX: level LEV_RX_RESET_PROGS entered.

A ** RABAX: level LEV_RX_RESET_PROGS completed.

A ** RABAX: level LEV_RX_STDERR entered.

Wed Mar 31 17:51:16 2010

A ABAP Program SAPMSSY2 .

A Source SAPMSSY2 Line 3665.

A Error Code DBIF_RSQL_SQL_ERROR.

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

A Function HandleRsqlErrors Line 786.

A ** RABAX: level LEV_RX_STDERR completed.

A ** RABAX: level LEV_RX_RFC_ERROR entered.

A ** RABAX: level LEV_RX_RFC_ERROR completed.

A ** RABAX: level LEV_RX_RFC_CLOSE entered.

A ** RABAX: level LEV_RX_RFC_CLOSE completed.

A ** RABAX: level LEV_RX_IMC_ERROR entered.

A ** RABAX: level LEV_RX_IMC_ERROR completed.

A ** RABAX: level LEV_RX_DATASET_CLOSE entered.

A ** RABAX: level LEV_RX_DATASET_CLOSE completed.

A ** RABAX: level LEV_RX_RESET_SHMLOCKS entered.

A ** RABAX: level LEV_RX_RESET_SHMLOCKS completed.

A ** RABAX: level LEV_RX_ERROR_SAVE entered.

A ** RABAX: level LEV_RX_ERROR_SAVE completed.

A ** RABAX: level LEV_RX_ERROR_TPDA entered.

A ** RABAX: level LEV_RX_ERROR_TPDA completed.

A ** RABAX: level LEV_RX_PXA_RELEASE_RUDI entered.

A ** RABAX: level LEV_RX_PXA_RELEASE_RUDI completed.

A ** RABAX: level LEV_RX_LIVE_CACHE_CLEANUP entered.

A ** RABAX: level LEV_RX_LIVE_CACHE_CLEANUP completed.

A ** RABAX: level LEV_RX_END entered.

A ** RABAX: level LEV_RX_END completed.

A ** RABAX: end no http/smtp

A ** RABAX: end RX_BTCHLOG|RX_VBLOG

A SQL error in the database when accessing a table..

C Wed Mar 31 17:53:12 2010

C OCI-call failed with -1=OCI_ERROR

C SQL error 8102: 'ORA-08102: index key not found, obj# 76808, file 47, block 226309 (2)'

C *** ERROR => Error 8102 in stmt_execute() from oci_execute_stmt(), orpc=0

[dbsloci.c 12650]

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

[dbsloci.c 12652]

C sc_p=05DF4D80,no=38,idc_p=05E058CC,con=0,act=1,slen=1198,smax=1280,#vars=58,stmt=05ECD198,table=TBTCO

C UPDATE "TBTCO" SET "JOBGROUP" = :A0 , "INTREPORT" = :A1 , "STEPCOUNT" = :A2 , "SDLSTRTDT" = :A3 , "S\

C DLSTRTTM" = :A4 , "BTCSYSTEM" = :A5 , "SDLDATE" = :A6 , "SDLTIME" = :A7 , "SDLUNAME" = :A8 , "LASTCH\

C DATE" = :A9 , "LASTCHTIME" = :A10 , "LASTCHNAME" = :A11 , "RELDATE" = :A12 , "RELTIME" = :A13 , "REL\

C UNAME" = :A14 , "STRTDATE" = :A15 , "STRTTIME" = :A16 , "ENDDATE" = :A17 , "ENDTIME" = :A18 , "PRDMI\

C NS" = :A19 , "PRDHOURS" = :A20 , "PRDDAYS" = :A21 , "PRDWEEKS" = :A22 , "PRDMONTHS" = :A23 , "PERIOD\

C IC" = :A24 , "DELANFREP" = :A25 , "EMERGMODE" = :A26 , "STATUS" = :A27 , "NEWFLAG" = :A28 , "AUTHCKN\

C AM" = :A29 , "AUTHCKMAN" = :A30 , "SUCCNUM" = :A31 , "PREDNUM" = :A32 , "JOBLOG" = :A33 , "LASTSTRTD\

C T" = :A34 , "LASTSTRTTM" = :A35 , "WPNUMBER" = :A36 , "WPPROCID" = :A37 , "EVENTID" = :A38 , "EVENTP\

C ARM" = :A39 , "BTCSYSREAX" = :A40 , "JOBCLASS" = :A41 , "PRIORITY" = :A42 , "EVENTCOUNT" = :A43 , "C\

C HECKSTAT" = :A44 , "CALENDARID" = :A45 , "PRDBEHAV" = :A46 , "EXECSERVER" = :A47 , "EOMCORRECT" = :A\

C 48 , "CALCORRECT" = :A49 , "REAXSERVER" = :A50 , "RECLOGSYS" = :A51 , "RECOBJTYPE" = :A52 , "RECOBJK\

C EY" = :A53 , "RECDESCRIB" = :A54 , "TGTSRVGRP" = :A55 WHERE "JOBNAME" = :A56 AND "JOBCOUNT" = :A57;

C sc_p=05DF4D80,no=38,idc_p=05E058CC,con=0,act=1,slen=1198,smax=1280,#vars=58,stmt=05ECD198,table=TBTCO

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

C IN : cols=58,rmax=1,xcnt=1,rpc=0,rowi=0,rtot=1,upto=-1,rsize=1292,vmax=64,bound=1,iobuf_p=05ECE618,vda_p=1BCFE2E8