ORA-00600[qesmaGetIdxSeg2] Errors when application is trying to insert into partitions from a table

(Doc ID 2349199.1)

Last updated on FEBRUARY 01, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.4 and later
Information in this document applies to any platform.

Symptoms

Application trying to insert into a table fails with an error like below in the Application log:

Jan 8 15:15:12 brtlvlts0360fu PROCARE_BDFIN: [ERROR] [|TEM_CLI.SET_UNBURDEN_RELATION] clisdf@bdfin(4).brtlvlts0360fu#FTMS1E4|15154316429250418351#ORA-00600: internal error code, arguments: [qesmaGetIdxSeg2], [56775], [56000], [1], [], [], [], [], [], [], [], []# in_consumption_id:(SCRDDEBIT-FTMS1E4-15148890606680452451-510971250-02012018083110)| in_consumption_date:(02/01/2018 08:31:10)| in_invoice_nr:(2167394)| in_invoice_id:(526772832)| in_invoice_date:(08/01/2018 15:15:11)| in_unburdened_value:(3.99)#548027775#00070#"ADMINPROV2_10.TEM_CLI", line 442

The incident trace file shows a failing sql like:

INSERT INTO TEM_CLI_TAX_UNB_RLTN_HIST(CLIENT_ACCOUNT, INVOICE_TRANS_ID_CODE, INVOICE_TRANS_ID_NR, INVOICE_ID, INVOICE_SEQ, INVOICE_SERIE, INVOICE_NUMBER, INVOICE_DATE, INVOICE_REFERENCES, PLAFOND_TYPE, PLAFOND_VALUE, SETTLE_TID, SETTLE_DUMP_INSTANCE_NR, SETTLE_DB_NAME, SETTLE_PARTITION_DATE, CONSUMP...

The call stack in the trace file includes functions like:

qesmaGetIdxSeg_INT  kaugetpart  kauxsin  qesltcLoadIndexList  qesltcLoadIndexes  qerltcNoKdtBufferedInsRowCBK  qerltcSingleRowLoad  qerltcFetch  insexe  opiexe  opipls  opiodr  rpidrus skgmstack rpiswu2  rpidrv  psddr0  psdnal  pevm_EXECC  pfrinstr_EXECC  pfrrun_no_tool  pfrrun  plsql_run peicnt  kkxexe  opiexe opiodr  ttcpip  opitsk  opiino opiodr opidrv  sou2o  opimai_real  ssthrdmain  main

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms