Find in this Blog

Thursday, January 17, 2019

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 

No comments:

Post a Comment

Ask Your Questions ?#