While running a mapping on ODI, we are getting ORA-00600:[kdisle:nrows] (Doc ID 2720198.1)

Last updated on APRIL 17, 2023

Applies to:

Symptoms

 Database version: 12.1.0.2

While running a mapping on ODI, we are getting the below DB error in STG schema <db name> DB Instance.

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

From alert log
+++++++++++++++
Errors in file /u02/app/oracle/diag/rdbms/<db Name>/<db Name>/trace/<db Name>_ora_229788.trc (incident=417291) (PDBNAME=<db name>):
ORA-00600: internal error code, arguments: [kdisle:nrows], [1], [], [], [], [], [], [], [], [], [], []
Incident details in: /u02/app/oracle/diag/rdbms/<db Name>/<db Name>/incident/incdir_417291/<db Name>_ora_229788_i417291.trc
Sun Sep 27 08:19:44 2020
Dumping diagnostic data in directory=[cdmp_20200927081944], requested by (instance=1, osid=229788), summary=[incident=417291].

----- Current SQL Statement for this session (sql_id=3r1810zxsa2kd) ----- >>>>>>>>>>>>>>>>>>>>>>>
insert into STG.STG_MCD_STAT_REP_12_MONTH
(
YEARS,
ENTITY,
OWNERSHIP_TYPE,
MARGIN_STATUS,
ACCOUNT,
JAN,
FEB,
MAR,
APR,
MAY,
JUN,
JUL,
AUG,
SEP,

----- Incident Context Dump -----
Address: 0x7fff2a9b2350
Incident ID: 417291
Problem Key: ORA 600 [kdisle:nrows]
Error: ORA-600 [kdisle:nrows] [1] [] [] [] [] [] [] [] [] [] []
[00]: dbgexProcessError [diag_dde]
[01]: dbgeExecuteForError [diag_dde]
[02]: dbgePostErrorKGE [diag_dde]
[03]: dbkePostKGE_kgsf [rdbms_dde]
[04]: kgeadse []
[05]: kgerinv_internal []
[06]: kgerinv []
[07]: kgeasnmierr []
[08]: kdisle [KDI]<-- Signaling
[09]: kdimodnu0 [KDI]
[10]: kdiblWriteEntry [KDI]
[11]: kdiblFlushStream [KDI]
[12]: kdiblcfls [KDI]
[13]: kdiblFinish1 [KDI]
[14]: kdibliFinish [KDI]
[15]: kxibFinish [SQL_Execution]
[16]: qerltcFetch [SQL_Execution]
[17]: insexe [DML]
[18]: opiexe [Time_Limit]
[19]: kpoal8 [PROGINT_MISC]
[20]: opiodr [OPI]
[21]: ttcpip []
[22]: opitsk [OPI]
[23]: opiino [OPI]
[24]: opiodr [OPI]
[25]: opidrv [OPI]
[26]: sou2o []
[27]: opimai_real [OPI]

<db Name>_ora_79703_i417292.trc
++++++++++++++++++++++++++++=
----- Current SQL Statement for this session (sql_id=3r1810zxsa2kd) ----- >>>>>>>>>>>>>>>>
insert into STG.STG_MCD_STAT_REP_12_MONTH
(
YEARS,
ENTITY,
OWNERSHIP_TYPE,

Changes

 No recent changes in environment

Cause