ORA-600 [17183] And ORA-1403 When Running Load In Sungard Banner Operational Data Store EDW Application And Database May Crash (Doc ID 1509379.1)

Last updated on FEBRUARY 07, 2014

Applies to:

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

Symptoms

You are running Sungard Banner Operational Data Store (ODS) EDW on Oracle 11.2 RDBMS and when executing the loader program and it fails with errors:

ORA-00600: internal error code, arguments: [17183], [0x01A727018], [], [], [], [], [], [], [], [], [], []
ORA-01403: no data found

The stack trace from the incident trace file will be similar to the following:

----- PL/SQL Call Stack -----
 object      line  object
 handle    number  name
00000002329E3948      2233  package body SYS.DBMS_SQL
000000022A81F3D0       140  package body ODSSRC.GOKODSF
0000000232E515F0       219  package body ODSMGR.LOAD_MAT_GIFT_AUXILIARY
0000000232E515F0      4947  package body ODSMGR.LOAD_MAT_GIFT_AUXILIARY
0000000232E515F0      5150  package body ODSMGR.LOAD_MAT_GIFT_AUXILIARY
000000022AD857A0         1  anonymous block
000000020A3F2548       490  package body IA_ADMIN.MGKMAP
000000020A3F2548      1306  package body IA_ADMIN.MGKMAP
000000020A3F2548      1534  package body IA_ADMIN.MGKMAP
000000020A3F3978         1  anonymous block

----- Call Stack Trace -----
ksedst1 <- ksedst <- dbkedDefDump <- ksedmp <- ksfdmp <- dbgexPhaseII <- dbgexExplicitEndInc <- dbgeEndDDEInvocatio <- nImpl <- dbgeEndDDEInvocatio <- kgherror <- kghfrf <- kgimfr <- kkxscvl <- pevm_icd_call_commo <- pfrinstr_ICAL <- pfrrun_no_tool <- pfrrun <- plsql_run <- peidxr_run <- peidxexe <- kkxdexe <- kkxmpexe <- kgmexwi <- kgmexec <- evapls <- evaopnc <- rpiswu2 <- evaopn2 <- evaopn2 <- qerlt_snv <- qerltRop <- kdstf00011010000kmP <- kdsttgr <- qertbFetch <- rwsfcd <- qerltFetch <- insdlexe <- insExecStmtExecIniE <- ngine <- insexe <- ngine <- opiexe <- opipls <- opiodr <- rpidrus <- rpidru <- rpiswu2 <- rpidrv <- psddr0 <- psdnal <- pevm_EXECC <- pfrinstr_EXECC <- pfrrun_no_tool <- pfrrun <- plsql_run <- peicnt <- kkxexe <- opiexe <- opipls <- opiodr <- rpidrus <- rpidru <- rpiswu2 <- rpidrv <- psddr0 <- psdnal <- pevm_EXIM <- pfrinstr_EXIM <- pfrrun_no_tool <- pfrrun <- plsql_run <- peicnt <- kkxexe <- opiexe <- opiodr <- rpidrus <- rpidru <- rpiswu2 <- rpidrv <- rpiexe <- kkjex1e <- kkjsexe <- kkjrdp <- opirip <- opidrv <- sou2o <- opimai_real <- opimai <- BackgroundThreadSta <- 0000000077D6B71A <- rt

 It can also cause the instance to terminate at times as well.

Changes

 Upgrades to the Sungard application

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