My Oracle Support Banner

An INSERT (DML) Statement Fails with ORA-600[qerandvInsHllToSynopsis:key not found] (Doc ID 2636432.1)

Last updated on MARCH 25, 2020

Applies to:

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

Symptoms

The following error occurred in the alert log:

ORA-00600: internal error code, arguments: [qerandvInsHllToSynopsis:key not found], [], [], [], [], [], [], [], [], [], [], []

 

The Current SQL Statement in the associated incident trace file is:

Insert /*+ append */ Into ...

 

The Call Stack Trace in the same incident trace file shows:

qerandvInsHllToSynopsis <- qerandvWriteXML <- qerandvPostProcessNonAggs
 <- qerandvPostProcessStatsInt <- qerandvFetch <- rwsfcd <- qerltFetch <- insdlexe
  <- insExecStmtExecIniEngine <- insexe <- opiexe <- kpoal8 <- opiodr <- ttcpip <- opitsk
   <- opiino <- opiodr <- opidrv <- sou2o <- opimai_real <- ssthrdmain <- main

 

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
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.