SQL error in the database when accessing table

[Former Member]

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

[Former Member]

Hi Karunakar,

As it is a SQL error, and saying that you not able to do the transactions, it is not only you but please confirm the same from your Functional team as well, they also perhaps facing the same SQL 600 error.

The only soultion what I guess is please confirm that you have applied the OPatches to the database if it is 10g.

That will solve the error. For refrence please find the note : 306408 .... .

Regards,

Madhu

[Former Member]

Hi Karunakar,

Check your Tablespace sizes and paste here alert log file.

Regards

Chandra

[Former Member]

Hi Chandra,

Please find the alert log file.

Mon Apr 05 13:20:51 2010

Errors in file e:\oracle\e6r\saptrace\usertrace\e6r_ora_7612.trc:

ORA-00600: internal error code, arguments: [ktspgfb-1], [], [], [], [], [], [], []

Mon Apr 05 13:21:47 2010

Errors in file e:\oracle\e6r\saptrace\usertrace\e6r_ora_3000.trc:

Mon Apr 05 13:21:51 2010

Errors in file e:\oracle\e6r\saptrace\usertrace\e6r_ora_3000.trc:

ORA-00600: internal error code, arguments: [ktspgfb-1], [], [], [], [], [], [], []

Mon Apr 05 13:22:47 2010

Errors in file e:\oracle\e6r\saptrace\usertrace\e6r_ora_7612.trc:

Mon Apr 05 13:22:51 2010

Errors in file e:\oracle\e6r\saptrace\usertrace\e6r_ora_7612.trc:

ORA-00600: internal error code, arguments: [ktspgfb-1], [], [], [], [], [], [], []

Mon Apr 05 13:23:47 2010

Errors in file e:\oracle\e6r\saptrace\usertrace\e6r_ora_3000.trc:

Mon Apr 05 13:23:51 2010

Errors in file e:\oracle\e6r\saptrace\usertrace\e6r_ora_3000.trc:

ORA-00600: internal error code, arguments: [ktspgfb-1], [], [], [], [], [], [], []

Mon Apr 05 13:24:47 2010

Errors in file e:\oracle\e6r\saptrace\usertrace\e6r_ora_7612.trc:

Mon Apr 05 13:24:51 2010

Errors in file e:\oracle\e6r\saptrace\usertrace\e6r_ora_7612.trc:

ORA-00600: internal error code, arguments: [ktspgfb-1], [], [], [], [], [], [], []

Mon Apr 05 13:25:47 2010

Errors in file e:\oracle\e6r\saptrace\usertrace\e6r_ora_3000.trc:

Mon Apr 05 13:25:51 2010

Errors in file e:\oracle\e6r\saptrace\usertrace\e6r_ora_3000.trc:

ORA-00600: internal error code, arguments: [ktspgfb-1], [], [], [], [], [], [], []

Mon Apr 05 13:26:47 2010

Errors in file e:\oracle\e6r\saptrace\usertrace\e6r_ora_7612.trc:

Mon Apr 05 13:26:51 2010

Errors in file e:\oracle\e6r\saptrace\usertrace\e6r_ora_7612.trc:

ORA-00600: internal error code, arguments: [ktspgfb-1], [], [], [], [], [], [], []

Mon Apr 05 13:27:47 2010

Errors in file e:\oracle\e6r\saptrace\usertrace\e6r_ora_3000.trc:

Mon Apr 05 13:27:51 2010

Errors in file e:\oracle\e6r\saptrace\usertrace\e6r_ora_3000.trc:

ORA-00600: internal error code, arguments: [ktspgfb-1], [], [], [], [], [], [], []

Mon Apr 05 13:28:47 2010

Errors in file e:\oracle\e6r\saptrace\usertrace\e6r_ora_7612.trc:

Mon Apr 05 13:28:51 2010

Errors in file e:\oracle\e6r\saptrace\usertrace\e6r_ora_7612.trc:

ORA-00600: internal error code, arguments: [ktspgfb-1], [], [], [], [], [], [], []

Mon Apr 05 13:29:47 2010

Errors in file e:\oracle\e6r\saptrace\usertrace\e6r_ora_3000.trc:

Mon Apr 05 13:29:51 2010

Errors in file e:\oracle\e6r\saptrace\usertrace\e6r_ora_3000.trc:

ORA-00600: internal error code, arguments: [ktspgfb-1], [], [], [], [], [], [], []

Mon Apr 05 13:30:47 2010

Errors in file e:\oracle\e6r\saptrace\usertrace\e6r_ora_7612.trc:

Mon Apr 05 13:30:51 2010

Errors in file e:\oracle\e6r\saptrace\usertrace\e6r_ora_7612.trc:

ORA-00600: internal error code, arguments: [ktspgfb-1], [], [], [], [], [], [], []

Mon Apr 05 13:31:47 2010

Errors in file e:\oracle\e6r\saptrace\usertrace\e6r_ora_3000.trc:

Mon Apr 05 13:31:51 2010

Errors in file e:\oracle\e6r\saptrace\usertrace\e6r_ora_3000.trc:

ORA-00600: internal error code, arguments: [ktspgfb-1], [], [], [], [], [], [], []

Mon Apr 05 13:32:47 2010

Errors in file e:\oracle\e6r\saptrace\usertrace\e6r_ora_7612.trc:

Mon Apr 05 13:32:51 2010

Errors in file e:\oracle\e6r\saptrace\usertrace\e6r_ora_7612.trc:

ORA-00600: internal error code, arguments: [ktspgfb-1], [], [], [], [], [], [], []

Mon Apr 05 13:33:47 2010

Errors in file e:\oracle\e6r\saptrace\usertrace\e6r_ora_3000.trc:

Mon Apr 05 13:33:51 2010

Errors in file e:\oracle\e6r\saptrace\usertrace\e6r_ora_3000.trc:

ORA-00600: internal error code, arguments: [ktspgfb-1], [], [], [], [], [], [], []

Mon Apr 05 13:34:47 2010

Errors in file e:\oracle\e6r\saptrace\usertrace\e6r_ora_5868.trc:

Mon Apr 05 13:34:51 2010

Errors in file e:\oracle\e6r\saptrace\usertrace\e6r_ora_5868.trc:

ORA-00600: internal error code, arguments: [ktspgfb-1], [], [], [], [], [], [], []

Mon Apr 05 13:35:47 2010

Errors in file e:\oracle\e6r\saptrace\usertrace\e6r_ora_1420.trc:

Mon Apr 05 13:35:51 2010

Errors in file e:\oracle\e6r\saptrace\usertrace\e6r_ora_1420.trc:

ORA-00600: internal error code, arguments: [ktspgfb-1], [], [], [], [], [], [], []

Mon Apr 05 13:36:47 2010

Errors in file e:\oracle\e6r\saptrace\usertrace\e6r_ora_5868.trc:

Mon Apr 05 13:36:51 2010

Errors in file e:\oracle\e6r\saptrace\usertrace\e6r_ora_5868.trc:

ORA-00600: internal error code, arguments: [ktspgfb-1], [], [], [], [], [], [], []

Mon Apr 05 13:37:36 2010

Incremental checkpoint up to RBA [0xf1a.18dd.0], current log tail at RBA [0xf1a.1a25.0]

Mon Apr 05 13:37:47 2010

Errors in file e:\oracle\e6r\saptrace\usertrace\e6r_ora_1420.trc:

Mon Apr 05 13:37:51 2010

Errors in file e:\oracle\e6r\saptrace\usertrace\e6r_ora_1420.trc:

ORA-00600: internal error code, arguments: [ktspgfb-1], [], [], [], [], [], [], []

Mon Apr 05 13:38:47 2010

Errors in file e:\oracle\e6r\saptrace\usertrace\e6r_ora_5868.trc:

Mon Apr 05 13:38:51 2010

Errors in file e:\oracle\e6r\saptrace\usertrace\e6r_ora_5868.trc:

ORA-00600: internal error code, arguments: [ktspgfb-1], [], [], [], [], [], [], []

Mon Apr 05 13:39:47 2010

Errors in file e:\oracle\e6r\saptrace\usertrace\e6r_ora_1420.trc:

Mon Apr 05 13:39:51 2010

Errors in file e:\oracle\e6r\saptrace\usertrace\e6r_ora_1420.trc:

ORA-00600: internal error code, arguments: [ktspgfb-1], [], [], [], [], [], [], []

Mon Apr 05 13:40:47 2010

Errors in file e:\oracle\e6r\saptrace\usertrace\e6r_ora_5868.trc:

Mon Apr 05 13:40:51 2010

Errors in file e:\oracle\e6r\saptrace\usertrace\e6r_ora_5868.trc:

ORA-00600: internal error code, arguments: [ktspgfb-1], [], [], [], [], [], [], []

Mon Apr 05 13:41:47 2010

Errors in file e:\oracle\e6r\saptrace\usertrace\e6r_ora_1420.trc:

Mon Apr 05 13:41:51 2010

Errors in file e:\oracle\e6r\saptrace\usertrace\e6r_ora_1420.trc:

ORA-00600: internal error code, arguments: [ktspgfb-1], [], [], [], [], [], [], []

Mon Apr 05 13:42:47 2010

Errors in file e:\oracle\e6r\saptrace\usertrace\e6r_ora_5868.trc:

Mon Apr 05 13:42:51 2010

Errors in file e:\oracle\e6r\saptrace\usertrace\e6r_ora_5868.trc:

ORA-00600: internal error code, arguments: [ktspgfb-1], [], [], [], [], [], [], []

Mon Apr 05 13:43:47 2010

Errors in file e:\oracle\e6r\saptrace\usertrace\e6r_ora_1420.trc:

Mon Apr 05 13:43:51 2010

Errors in file e:\oracle\e6r\saptrace\usertrace\e6r_ora_1420.trc:

ORA-00600: internal error code, arguments: [ktspgfb-1], [], [], [], [], [], [], []

Mon Apr 05 13:44:47 2010

Errors in file e:\oracle\e6r\saptrace\usertrace\e6r_ora_5868.trc:

Mon Apr 05 13:44:51 2010

Errors in file e:\oracle\e6r\saptrace\usertrace\e6r_ora_5868.trc:

ORA-00600: internal error code, arguments: [ktspgfb-1], [], [], [], [], [], [], []

Mon Apr 05 13:45:47 2010

Errors in file e:\oracle\e6r\saptrace\usertrace\e6r_ora_1420.trc:

Mon Apr 05 13:45:51 2010

Errors in file e:\oracle\e6r\saptrace\usertrace\e6r_ora_1420.trc:

ORA-00600: internal error code, arguments: [ktspgfb-1], [], [], [], [], [], [], []

Mon Apr 05 13:46:47 2010

Errors in file e:\oracle\e6r\saptrace\usertrace\e6r_ora_5868.trc:

Mon Apr 05 13:46:51 2010

Errors in file e:\oracle\e6r\saptrace\usertrace\e6r_ora_5868.trc:

ORA-00600: internal error code, arguments: [ktspgfb-1], [], [], [], [], [], [], []

Mon Apr 05 13:47:47 2010

Errors in file e:\oracle\e6r\saptrace\usertrace\e6r_ora_1420.trc:

Mon Apr 05 13:47:51 2010

Errors in file e:\oracle\e6r\saptrace\usertrace\e6r_ora_1420.trc:

ORA-00600: internal error code, arguments: [ktspgfb-1], [], [], [], [], [], [], []

Mon Apr 05 13:48:47 2010

Errors in file e:\oracle\e6r\saptrace\usertrace\e6r_ora_5868.trc:

Mon Apr 05 13:48:51 2010

Errors in file e:\oracle\e6r\saptrace\usertrace\e6r_ora_5868.trc:

ORA-00600: internal error code, arguments: [ktspgfb-1], [], [], [], [], [], [], []

Mon Apr 05 13:49:47 2010

Errors in file e:\oracle\e6r\saptrace\usertrace\e6r_ora_1420.trc:

Mon Apr 05 13:49:51 2010

Errors in file e:\oracle\e6r\saptrace\usertrace\e6r_ora_1420.trc:

ORA-00600: internal error code, arguments: [ktspgfb-1], [], [], [], [], [], [], []

Mon Apr 05 13:50:47 2010

Errors in file e:\oracle\e6r\saptrace\usertrace\e6r_ora_5868.trc:

Mon Apr 05 13:50:51 2010

Errors in file e:\oracle\e6r\saptrace\usertrace\e6r_ora_5868.trc:

ORA-00600: internal error code, arguments: [ktspgfb-1], [], [], [], [], [], [], []

Mon Apr 05 13:51:47 2010

Errors in file e:\oracle\e6r\saptrace\usertrace\e6r_ora_1420.trc:

Mon Apr 05 13:51:51 2010

Errors in file e:\oracle\e6r\saptrace\usertrace\e6r_ora_1420.trc:

ORA-00600: internal error code, arguments: [ktspgfb-1], [], [], [], [], [], [], []

Mon Apr 05 13:52:47 2010

Errors in file e:\oracle\e6r\saptrace\usertrace\e6r_ora_7276.trc:

Mon Apr 05 13:52:51 2010

Errors in file e:\oracle\e6r\saptrace\usertrace\e6r_ora_7276.trc:

ORA-00600: internal error code, arguments: [ktspgfb-1], [], [], [], [], [], [], []

Mon Apr 05 13:53:47 2010

Errors in file e:\oracle\e6r\saptrace\usertrace\e6r_ora_3080.trc:

Mon Apr 05 13:53:51 2010

Errors in file e:\oracle\e6r\saptrace\usertrace\e6r_ora_3080.trc:

ORA-00600: internal error code, arguments: [ktspgfb-1], [], [], [], [], [], [], []

Mon Apr 05 13:54:47 2010

Errors in file e:\oracle\e6r\saptrace\usertrace\e6r_ora_7276.trc:

Mon Apr 05 13:54:51 2010

Errors in file e:\oracle\e6r\saptrace\usertrace\e6r_ora_7276.trc:

ORA-00600: internal error code, arguments: [ktspgfb-1], [], [], [], [], [], [], []

Mon Apr 05 13:55:47 2010

Errors in file e:\oracle\e6r\saptrace\usertrace\e6r_ora_3080.trc:

Mon Apr 05 13:55:51 2010

Errors in file e:\oracle\e6r\saptrace\usertrace\e6r_ora_3080.trc:

ORA-00600: internal error code, arguments: [ktspgfb-1], [], [], [], [], [], [], []

Mon Apr 05 13:56:47 2010

Errors in file e:\oracle\e6r\saptrace\usertrace\e6r_ora_7276.trc:

Mon Apr 05 13:56:51 2010

Errors in file e:\oracle\e6r\saptrace\usertrace\e6r_ora_7276.trc:

ORA-00600: internal error code, arguments: [ktspgfb-1], [], [], [], [], [], [], []

Regards

Karunakar

[Former Member]

Hi,

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

regards,

balaram

[Former Member]

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

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..

A

C

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

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

B ***LOG BY4=> sql error 8102 performing UPD on table TBTCO [dbtrtab#7 @ 3914] [dbtrtab 3914 ]

B ***LOG BY0=> ORA-08102: index key not found, obj# 76808, file 47, block 226309 (2) [dbtrtab]

Please suggest the solution.

[Former Member]

Looks like a serious Oracle problem.

You might find more information in your Oracle alert log file.

It may be necessary to open a support call with SAP.

Start with SAP Note 376755 - ORA-00600 - what to do?

hope this helps

[sunny_pahuja2]

Hi,

Check whether archive directory is full or not.

Thanks

Sunny

[Former Member]

Hi,

My archive directory is not full, there is enough free space in the archive directory and also in the tablespace.

Regards

Karunakar