Skip to Content
Technical Articles

P3 “SQL message: ORA-00600: internal error code, arguments: [kdsgrp1], [], [],

P3 “SQL message: ORA-00600: internal error code, arguments: [kdsgrp1], [], [],

Runtime Errors         DBSQL_SQL_ERROR
Exception              CX_SY_OPEN_SQL_DB
Date and Time          16.01.2019 10:43:16

Short text
There is no help text for this runtime error
Either the text was inadvertently deleted or the release of
the kernel differs from that of the database.
Refer to the Note system for further information on
this runtime error.

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 “MA_DTEL_TABL_MCID_SEL” “(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:
Description not available
Parameters:
P1 “DD03L”
P2 “SQL code: 600”
P3 “SQL message: ORA-00600: internal error code, arguments: [kdsgrp1], [], [],
[], [], [], [], [], [], [], [], []”
P4 “SQL dbsl rc: 99″
P5 ” ”
P6 ” ”
P7 ” ”
P8 ” ”
P9 ” ”

This error normally occur  because of the INDEX or table structure is in consistent mode.
Analyze the index structure and tables.
If index structure is failed in analyze , drop the index and recreate the index.

please ensure it is shadow instance or Default instance.

Step:0

SQL> select INDEX_NAME from dba_indexes where table_name=’DD03L~’;
INDEX_NAME
——————————————————————————–
DD03L^0
DD03L^7
DD03L^6
DD03L^2
DD03L^3
DD03L^4
DD03L^5
DD03L^1

SQL> ANALYZE INDEX sapsr3.”DD03L^1″ VALIDATE STRUCTURE ONLINE;
Index analyzed.

ANALYZE INDEX sapsr3.”DD03L^1″ VALIDATE STRUCTURE ONLINE
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [kdsgrp1], [], [], [], [], [], [],
[], [], [], [], []

Step:1
SQL> set pagesize 0

SQL> set long 90000

SQL> SELECT DBMS_METADATA.GET_DDL(‘INDEX’,’DD03L^1′,’SAPSR3′) from dual;

 CREATE  INDEX “SAPSR3”.”DD03L^1″ ON “SAPSR3″.”DD03L~” (“TABNAME”, “AS4LOCAL”, “POSITION”, “AS4VERS”)
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 299630592 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE “PSAPSR3740”;

Step:2

SQL> DROP INDEX “SAPSR3”.”DD03L^1″;

     Index dropped
Step:3

SQL> CREATE  INDEX “SAPSR3”.”DD03L^1″ ON “SAPSR3″.”DD03L~” (“TABNAME”, “AS4LOCAL”, “POSITION”, “AS4VERS”)
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 299630592 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE “PSAPSR3740”;

  Index created.

Step:4

SQL> ANALYZE INDEX sapsr3.”DD03L^1″ VALIDATE STRUCTURE ONLINE;
Index analyzed.

Thanks
Yoonus
Be the first to leave a comment
You must be Logged on to comment or reply to a post.