My Oracle Support Banner

Impdp Fails With ORA-600 [kkqfca:invalid input] While Processing Materialized Views (Doc ID 750702.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Oracle Server - Enterprise Edition - Version: to
This problem can occur on any platform.


While performing an import with Data Pump, the import stops while processing materialized views with the following errors in the import log file:

ORA-39014: One or more workers have prematurely exited.
ORA-39029: worker 1 with process name "DW01" prematurely terminated
ORA-31672: Worker process DW01 died unexpectedly.

ORA-39014: One or more workers have prematurely exited.

At the same time the alert log is showing following error :

ORA-600: internal error code, arguments: [kkqfca:invalid input], [], [], [], [], [], [], []

The call stack functions from the trace file will look similar to:

ksedst <- ksedmp <- kgerinv <- kgeasnmierr <- kkzqfca <- kkzpgcinfo <- kkzpcbk <- opikkzprs1 <- opiSem <- opiprs <- kksParseChildCursor <- rpiswu2 <- kksLoadChild <- kxsGetRuntimeLock <- kksfbc <- kkspsc0 <- kksParseCursor <- opiosq0 ...


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

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