ORA-00600[qesmaGetIdxSeg2] Errors when application is trying to insert into partitions from a table
(Doc ID 2349199.1)
Last updated on FEBRUARY 26, 2019
Applies to:
Oracle Database - Enterprise Edition - Version 11.2.0.4 and laterOracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A 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
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |