Database error 600 at UPD access to table TBTCO

[Former Member]

Hi All,

i am getting the below error in SM21, in ECC 6.0 IDES System.

Database error 600 at UPD access to table TBTCO 

system log shows the below error , kinkdy help:-

DBIF_RSQL_SQL_ERROR   

Run-time error "DBIF_RSQL_SQL_ERROR     

ORA-00600: internal error code, arguments: [ktbdchk1: bad  

[Former Member]

Guys,

any help??

[Former Member]

Hi Sri/Deepak,

Just to let you know guys the table space were above 95 % and i extended the datafiles but still they are not reflecting while refreshing and throwing the short dump error.

PSAPSR3	145.660,00	4.448,31	97	YES	760.000,00	618.788,31	19	76	94.928	262.848	ONLINE	PERMANENT	DISABLED
PSAPSR3700	95.130,00	4.493,88	95	YES	430.000,00	339.363,88	21	43	818	26.892	ONLINE	PERMANENT	DISABLED
PSAPSR3FACT	110,00	109,00	1	YES	10.000,00	9.999,00	0	1	0	0	ONLINE	PERMANENT	DISABLED
PSAPSR3ODS	100,00	98,88	1	YES	10.000,00	9.998,88	0	1	2	2	ONLINE	PERMANENT	DISABLED
PSAPSR3USR	50,00	15,94	68	YES	10.000,00	9.965,94	0	1	400	511	ONLINE	PERMANENT	DISABLED
PSAPTEMP	10.000,00	10.000,00	0	NO	10.000,00	10.000,00	0	1	0	0	ONLINE	TEMPORARY	DISABLED
PSAPUNDO	2.120,00	2.055,88	3	YES	10.000,00	9.935,88	1	1	17	95	ONLINE	UNDO	DISABLED
SYSAUX	680,00	95,06	86	YES	10.000,00	9.415,06	6	1	1.158	3.103	ONLINE	PERMANENT	DISABLED
SYSTEM	1.170,00	13,81	99	YES	10.000,00	8.843,81	12	1	1.581	3.469	ONLINE	PERMANENT	DISABLED

[former_member188883]

Hi Amar,

Could you execute CheckDB from db13 and share the logs.

Regards,

Deepak Kori

[Former Member]

Hi Deepak,

I checked the database using DB13 and got the below error:-

Category               Installation Errors

Runtime Errors         DBIF_RSQL_SQL_ERROR

Except.                CX_SY_OPEN_SQL_DB

Date and Time          18.03.2014 09:25:24

Short text

     SQL error 600 when accessing table "TBTCO".

What happened?

     Error Text of the Database: "ORA-00600: internal error code, arguments:

      [ktbdchk1: bad dscn], [], [], [], [], [], [], [], [], [], [], []"

What can you do?

     Note which actions and input led to the error.

     For further help in handling the problem, contact your SAP administrato

     .

     You can use the ABAP dump analysis transaction ST22 to view and manage

     termination messages, in particular for long term reference.

     Note which actions and input led to the error.

     For further help in handling the problem, contact your SAP administrato

     .

     You can use the ABAP dump analysis transaction ST22 to view and manage

     termination messages, in particular for long term reference.

Regards

Amar Bhalla

[former_member188883]

Hi Amar,

Please share details from alert_<SID>.log and db13 detailed logs.

Regards,

Deepak Kori

[former_member188883]

Hi Amar,

Additionally share the output of command

analyze table "<OWNER>"."TBTCO" validate structure cascade online;

Hope this helps.

Regards,

Deepak Kori

[Sriram2009]

Hi Amar

Kindly refer the SAP notes

658744 - Composite SAP Note: ORA-00600 [2103]

  745639 - FAQ: Oracle enqueues

192375 - Ora-600 [2103]

BR

SS

[Former Member]

Hi Deepak,

aplogies for the delay was out of town.

Please fine below the complate details from Transaction DB13:-

Short text

    SQL error 600 when accessing table "TBTCO".

What happened?

    Error Text of the Database: "ORA-00600: internal error code, arguments:

     [ktbdchk1: bad dscn], [], [], [], [], [], [], [], [], [], [], []"

Error analysis

    An exception occurred that is explained in detail below.

    The exception, which is assigned to class 'CX_SY_OPEN_SQL_DB', was not caught

     in

    procedure "UPDATE_MODIFIED_JOBDATA" "(FORM)", nor was it propagated by a

     RAISING clause.

    Since the caller of the procedure could not have anticipated that the

    exception would occur, the current program is terminated.

    The reason for the exception is:

    Error Text of the Database: "ORA-00600: internal error code, arguments:

     [ktbdchk1: bad dscn], [], [], [], [], [], [], [], [], [], [], []"

Missing RAISING Clause in Interface

    Program                                 SAPLBTCH

    Include                                 LBTCHF13

    Row                                     335

   Module Name                             UPDATE_MODIFIED_JOBDATA

rigger Location of Exception

   Program                                 SAPLBTCH

   Include                                 LBTCHF13

   Row                                     557

   Module type                             (FORM)

   Module Name                             UPDATE_MODIFIED_JOBDATA

ource Code Extract

ine  SourceCde

527

528 * only store complete recipient reference

529   IF mod_jobhead-recobjkey IS INITIAL.

530     CLEAR mod_jobhead-reclogsys.

531     CLEAR mod_jobhead-recobjtype.

532     CLEAR mod_jobhead-recdescrib.

533   ENDIF.

534 *

535 * Veränderungsdaten im Jobkopf fortschreiben

536 *

537   GET TIME.

538

539   mod_jobhead-lastchdate = sy-datum.

540   mod_jobhead-lastchtime = sy-uzeit.

541   mod_jobhead-lastchname = sy-uname.

  549     mod_jobhead-reldate  = no_date.

  550     mod_jobhead-reltime  = no_time.

  551     mod_jobhead-reluname = space.

  552   ENDIF.

  553

  554   CLEAR tbtco.

  555   MOVE-CORRESPONDING mod_jobhead TO tbtco.

  556   CLEAR tbtco-jobgroup. " evtl. vorhandene 'IMMEDIATE'-Info in Job-

>>>>>   UPDATE tbtco.         " kopfdaten darf nicht in DB

  558

  559   IF sy-subrc NE 0.

  560     IF dialog EQ btc_yes.

  561       MESSAGE s117 WITH mod_jobhead-jobname.

  562     ENDIF.

  563     PERFORM write_job_modify_syslog USING tbtco_update_db_error

  564 *                                           MOD_JOBHEAD-JOBNAME.

  565                                           space

  566                                           mod_jobinfo.

  567     rc = 1.

  568     EXIT.

  569   ENDIF.

  570

  571   rc = 0.

  572

  573 ENDFORM. " UPDATE_MODIFIED_JOBDATA

  574

  575 *---------------------------------------------------------------------*

  576 *      FORM WRITE_JOB_MODIFY_SYSLOG                                   *

Active Calls/Events

No.   Ty.          Program                             Include                             Line

      Name

   18 FORM         SAPLBTCH                            LBTCHF13                              557

      UPDATE_MODIFIED_JOBDATA

   17 FUNCTION     SAPLBTCH                            LBTCHU13                              981

      BP_JOB_MODIFY

   16 FUNCTION     SAPLBTCH                            LBTCHU25                              311

      JOB_CLOSE

   15 FUNCTION     SAPLSDB6PLAN                        LSDB6PLANU06                           94

      DB6_PLAN_EXEC_BATCH

   14 METHOD       CL_DB6_CALENDAR_ACTION========CP    CL_DB6_CALENDAR_ACTION========CM00K    50

      CL_DB6_CALENDAR_ACTION=>EXEC_ACTION

   13 FORM         SAPLSDB6CAL                         LSDB6CALPLC                          3384

      EXECUTE_PLAN

   12 MODULE (PAI) SAPLSDB6CAL                         LSDB6CALPLC                          1138

      USER_COMMAND_201

   11 FORM         SAPLSDB6CAL                         LSDB6CALPLC                          1891

      ADD_PLAN_VIA_ACTION_PAD

   10 MODULE (PAI) SAPLSDB6CAL                         LSDB6CALPLC                           973

      USER_COMMAND_100

    9 FUNCTION     SAPLSDB6CAL                         LSDB6CALU01                             7

      DB6_PLANNING_CALENDAR

    8 METHOD       CL_DB6_TREE_NAVIGATOR=========CP    CL_DB6_TREE_NAVIGATOR=========CM003   543

      CL_DB6_TREE_NAVIGATOR=>CALL_ACTION

    7 MODULE (PBO) SAPLSDB6CAL                         RSDB6NAV                              415

      PREPARE_OUTPUT_0900

    6 FUNCTION     SAPLSDB6CAL                         LSDB6CALU01                             7

      DB6_PLANNING_CALENDAR

    5 METHOD       CL_DB6_TREE_NAVIGATOR=========CP    CL_DB6_TREE_NAVIGATOR=========CM003   543

      CL_DB6_TREE_NAVIGATOR=>CALL_ACTION

    4 MODULE (PBO) SAPLSDBACCMS                        LSDBACCMSGLB                           69

    3 FUNCTION     SAPLSDBACCMS                        LSDBACCMSU05                           42

      DB6_CALL_COCKPIT

    2 FORM         RSDBAADM                            RSDBAF01                              148

      CALL_LOCAL_CALENDAR

    1 EVENT        RSDBAADM                            RSDBAE01                               12

      START-OF-SELECTION

Regards

Amar

[Sriram2009]

Hi

Could you check this SAP Note

1919944 - "ORA-600 [ktspfsall]" error during insert to ASSM segment

BR

SS

[Former Member]

Hi Deepak,

I am running the below command but does not yield any results:-

SQL> analyze table "TBTCO" validate structure cascade online;

analyze table "TBTCO" validate structure cascade online

              *

ERROR at line 1:

ORA-00942: table or view does not exist.

Regards

Amar

[Former Member]

Thanks Sri,

basically i checked and found that the 3 table spaces were above 95 % and i extended the space for all the three however when i go to refresh the datafiles it throws the below error message:-

Error analysis

    An exception occurred that is explained in detail below.

    The exception, which is assigned to class 'CX_SY_OPEN_SQL_DB', was not caught

     in

    procedure "UPDATE_MODIFIED_JOBDATA" "(FORM)", nor was it propagated by a

     RAISING clause.

    Since the caller of the procedure could not have anticipated that the

    exception would occur, the current program is terminated.

    The reason for the exception is:

    Error Text of the Database: "ORA-00600: internal error code, arguments:

     [ktbdchk1: bad dscn], [], [], [], [], [], [], [], [], [], [], []"

Regards

Amar

[Former Member]

Hi Sri,

Database error text........: "ORA-00600: internal error code,arguments: [ktspfsall], [], [], [], [], [], [], []"

Internal call code.........: "[RSQL/UPDT/TBTCO ]"

[former_member188883]

Hi Amar,

Run the command as below. Replace <SCHEMA> with you SAP system schema  For eg: SAPSR3

SQL> analyze table <SCHEMA>.TBTCO validate structure cascade online;

Regards,

Deepak Kori

[Sriram2009]

Hi

Database error text........: "ORA-00600: internal error code,arguments: [ktspfsall], [], [], [], [], [], [], []"
Internal call code.........: "[RSQL/UPDT/TBTCO ]"

For this Error you have to follow the SAP Note

1919944 - "ORA-600 [ktspfsall]" error during insert to ASSM segment

BR

SS

[Former Member]

Hi Deepak,

Just to let you know i new in this. results below;

SQL> analyze table SAPSR3.TBTCO validate structure cascade online;

analyze table SAPSR3.TBTCO validate structure cascade online

*

ERROR at line 1:

ORA-01555: snapshot too old: rollback segment number 3 with name

"_SYSSMU3_1411126849$" too small

Thanks for your help.

Regards

Amar

[Former Member]

HI Sri,

Just to let you know i am using Oracle DB 11.2.03.0.

Regards

Amar

[Sriram2009]

Hi

Few week or month back have you upgrade Oracle 11.2 ?

Could you check this SAP Note  1431793 - Oracle 11.2.0: Upgrade Scripts

BR

SS

[Former Member]

Thanks Sri,

I have just taken the work handover let me chk if the upgrade was done.

Regards

Amar

[Former Member]

Hi Deepak,

Any luck further?

[former_member188883]

Hi Amar,

The error message is due to insufficient space in UNOD tablespace.

Please add some datafiles into PSAPUNDO and try the command again.

Regards,

Deepak Kori

[Former Member]

thanks deepak,

But as shown in the above table the psapundo table is only 3 5 used.

However i also tried adding extra space in psapundo table through below queries bt no help:-

SQL > create undo tablespace NEW_PSAPUNDO datafile 'E:\ORACLE\sid\SAPDATA1\UNDO_1\NEW_UNDO.DATA1' size 1G;

SQL> alter system set undo_tablespace='NEW_PSAPUNDO' scope=spfile;

System altered.

amar

[former_member188883]

Hi Amar,

If you have lots of updates, long running SQL and too small UNDO, the ORA-01555 error will appear.

Oracles does this by reading the "before image" of changed rows from the online undo segments

Please add around 10 GB and check.

Regards,

Deepak Kori

[Sriram2009]

Hi Amar

1.  Could you paste /attach the dump

2. OS / DB details

Regards

Ram

[Former Member]

Hi Ram,

Apologies for the Delay in response.

Its windows server 2003 R2

64bit

Orcale  11.0.2.3.0

can you help me with the instruction from where you want me to fetch the dump.

Regards

Amar