on 03-13-2014 9:49 AM
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
Guys,
any help??
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Amar,
Could you execute CheckDB from db13 and share the logs.
Regards,
Deepak Kori
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
Hi
Could you check this SAP Note
1919944 - "ORA-600 [ktspfsall]" error during insert to ASSM segment
BR
SS
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
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
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
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
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
Hi Amar
1. Could you paste /attach the dump
2. OS / DB details
Regards
Ram
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.