e13639
29th November 2005, 15:11
First of all we have 8.1.7.
Executing session tdinv7410m000 with specific parameters, i've got this error
in log.oracle8:
2005-11-29[13:53:05]:E:bsp: ******* S T A R T of Error message *******
2005-11-29[13:53:05]:E:bsp: Log message called from /view/port.6.1c.06.07/vobs/tt/servers/ORACLE_2/ora_native.c: #1992 keyword: Oracle Error
2005-11-29[13:53:05]:E:bsp: Pid 9953 Uid 125 Euid 125 Gid 125 Egid 125
2005-11-29[13:53:05]:E:bsp: user_type S language 2 user_name bsp tty ote locale ISO88591/NULL
2005-11-29[13:53:05]:E:bsp: Errno 0 bdb_errno 110 (End of file reached)
2005-11-29[13:53:05]:E:bsp:
2005-11-29[13:53:05]:E:bsp: dbs_errno = 0Error 1600 occurred:
2005-11-29[13:53:05]:E:bsp: Error ORA-600 occurred during multi_fetch.
2005-11-29[13:53:05]:E:bsp: ORA-00600: internal error code, arguments: [25012], [11], [2], [], [], [], [], []
2005-11-29[13:53:05]:E:bsp:
2005-11-29[13:53:05]:E:bsp: Error BDB-1600 returned.
2005-11-29[13:53:05]:E:bsp: Multi fetch failed: error 1600.
2005-11-29[13:53:05]:E:bsp: See fatal SQL statement in '/baan/bse/log/log.ora.sql'.
2005-11-29[13:53:05]:E:bsp: Flushed at /view/port.6.1c.06.07/vobs/tt/servers/ORACLE_2/ora_cursor.c : #656.
2005-11-29[13:53:05]:E:bsp: ******* E N D of Error message *******
and this is the error in log.ora.sql:
SELECT /*+ FIRST_ROWS INDEX(a ttdinv700910$idx1) */ a.t$cntr,a.t$cprj,a.t$cwar,a.t$item,a.t$koor,a.t$kost,a.t$logn,a.t$orno,a.t$pono,a.t$prst,a.t$quan,a.t$rlcd,a.t$sern,a.t$stoc,a.t$trdt,a.t$trtm,c.t$ascp,c.t$bcac,c.t$bcbi,c.t$bcim,c.t$bkcs,c.t$bkdt,c.t$cbdg,c.t$cprj,c.t$cuno,c.t$ddat,c.t$dsca,c.t$dscb,c.t$dscc,c.t$dscd,c.t$ecpa,c.t$ecpr,c.t$erev,c.t$ffci,c.t$intp,c.t$kopr,c.t$ncmp,c.t$plcd,c.t$pman,c.t$prtp,c.t$psta,c.t$psts,c.t$refe,c.t$sdat,c.t$seak,c.t$tinv,c.t$txta,d.t$aplo,d.t$arlo,d.t$cadr,d.t$ccty,d.t$comp,d.t$cwar,d.t$dsca,d.t$free,d.t$geoc$l,d.t$itlo,d.t$lolo,d.t$nama,d.t$namb,d.t$namc,d.t$namd,d.t$name,d.t$namf,d.t$nwrh,d.t$pstc,d.t$rwka,d.t$sloc,d.t$typw,e.t$abcc,e.t$actf,e.t$addi,e.t$allo,e.t$apka,e.t$apkb,e.t$assi,e.t$auso,e.t$avpr,e.t$bfcp,e.t$bfep,e.t$bfhr,e.t$blck,e.t$blcm,e.t$buyr,e.t$ccco,e.t$ccde,e.t$ccfu,e.t$ccit,e.t$ccur,e.t$cfmd,e.t$citg,e.t$cmgp,e.t$cntr,e.t$code,e.t$cont,e.t$copr,e.t$copt,e.t$cpcp,e.t$cpgp,e.t$cpgs,e.t$cpha,e.t$cplb,e.t$cpno,e.t$cppp,e.t$cprp,e.t$crmp,e.t$csel,e.t$csgp,e.t$csgs,e.t$csig,e.t$cspd,e.t$csps,e.t$ctyo,e.t$ctyp,e.t$cuid,e.t$cuni,e.t$cupp,e.t$cups,e.t$cuqp,e.t$cuqs,e.t$cvat,e.t$cwar,e.t$czed,e.t$dcnt,e.t$ddfq,e.t$dltm,e.t$dsca,e.t$dscb,e.t$dscc,e.t$dscd,e.t$ecoq,e.t$eitm,e.t$faml,e.t$ffsi,e.t$fioq,e.t$fodt,e.t$hall,e.t$hatc,e.t$imds,e.t$item,e.t$itmt,e.t$kitm,e.t$kltc,e.t$kpsl,e.t$lcod,e.t$ldsu,e.t$llcd,e.t$llci,e.t$lmsp,e.t$ltcp,e.t$ltdt,e.t$ltpp,e.t$ltpr,e.t$ltsp,e.t$maoq,e.t$matc,e.t$maxs,e.t$mioq,e.t$mrpc,e.t$mrpi,e.t$mrpo,e.t$ncst,e.t$ndrp,e.t$nnts,e.t$nobd,e.t$npsl,e.t$obpr,e.t$ocst,e.t$oint,e.t$oltm,e.t$omth,e.t$onew,e.t$opol,e.t$oprc,e.t$oqdr,e.t$oqmf,e.t$ordr,e.t$orip,e.t$osyc,e.t$osys,e.t$ownd,e.t$ownr,e.t$pcgp,e.t$pcrp,e.t$pics,e.t$pitm,e.t$plmm,e.t$potc,e.t$prip,e.t$prir,e.t$pris,e.t$proi,e.t$prre,e.t$purc,e.t$qbsi,e.t$qpnt,e.t$qual,e.t$quot,e.t$rbgp,e.t$reli,e.t$reop,e.t$repi,e.t$roun,e.t$runi,e.t$scdl,e.t$scoo,e.t$scpf,e.t$scst,e.t$seab,e.t$seak,e.t$serv,e.t$sfst,e.t$sftm,e.t$slmp,e.t$stgu,e.t$stmr,e.t$stoc,e.t$stpm,e.t$stva,e.t$suno,e.t$tmfc,e.t$trcd,e.t$tval,e.t$txta,e.t$txtp,e.t$txts,e.t$uabc,e.t$udlt,e.t$ufra,e.t$umer,e.t$umsp,e.t$unom,e.t$usab,e.t$uscu,e.t$uset,e.t$wght FROM baan.ttdinv700910 a,baan.ttiitm100910 b,baan.ttipcs020910 c,baan.ttcmcs003910 d,baan.ttiitm001910 e WHERE (:1 = :2 OR a.t$prst = :3) AND ((a.t$trdt < :4) OR ((a.t$trtm <= :5) AND a.t$trdt = :6)) AND ((a.t$trdt > :7) OR ((a.t$trtm >= :8) AND a.t$trdt = :9)) AND (a.t$cntr >= :10) AND (a.t$cntr <= :11) AND (a.t$cwar >= :12) AND (a.t$cwar <= :13) AND (a.t$trdt >= :14) AND (a.t$trdt <= :15) AND (a.t$orno >= :16) AND (a.t$orno <= :17) AND (a.t$rlcd >= :18) AND (a.t$rlcd <= :19) AND (a.t$cprj >= :20) AND (a.t$cprj <= :21) AND (a.t$logn >= :22) AND (a.t$logn <= :23) AND b.t$reli (+) = a.t$item AND b.t$cntr (+) = a.t$cntr AND e.t$item (+) = b.t$item AND d.t$cwar (+) = a.t$cwar AND c.t$cprj (+) = a.t$cprj AND (a.t$item >= :24) AND (a.t$item <= :25) AND a.t$koor = :26 AND (e.t$citg >= :27) AND (e.t$citg <= :28) AND (e.t$csgs >= :29) AND (e.t$csgs <= :30) ORDER BY 4,1,3,15,16,13
Executing session tdinv7410m000 with specific parameters, i've got this error
in log.oracle8:
2005-11-29[13:53:05]:E:bsp: ******* S T A R T of Error message *******
2005-11-29[13:53:05]:E:bsp: Log message called from /view/port.6.1c.06.07/vobs/tt/servers/ORACLE_2/ora_native.c: #1992 keyword: Oracle Error
2005-11-29[13:53:05]:E:bsp: Pid 9953 Uid 125 Euid 125 Gid 125 Egid 125
2005-11-29[13:53:05]:E:bsp: user_type S language 2 user_name bsp tty ote locale ISO88591/NULL
2005-11-29[13:53:05]:E:bsp: Errno 0 bdb_errno 110 (End of file reached)
2005-11-29[13:53:05]:E:bsp:
2005-11-29[13:53:05]:E:bsp: dbs_errno = 0Error 1600 occurred:
2005-11-29[13:53:05]:E:bsp: Error ORA-600 occurred during multi_fetch.
2005-11-29[13:53:05]:E:bsp: ORA-00600: internal error code, arguments: [25012], [11], [2], [], [], [], [], []
2005-11-29[13:53:05]:E:bsp:
2005-11-29[13:53:05]:E:bsp: Error BDB-1600 returned.
2005-11-29[13:53:05]:E:bsp: Multi fetch failed: error 1600.
2005-11-29[13:53:05]:E:bsp: See fatal SQL statement in '/baan/bse/log/log.ora.sql'.
2005-11-29[13:53:05]:E:bsp: Flushed at /view/port.6.1c.06.07/vobs/tt/servers/ORACLE_2/ora_cursor.c : #656.
2005-11-29[13:53:05]:E:bsp: ******* E N D of Error message *******
and this is the error in log.ora.sql:
SELECT /*+ FIRST_ROWS INDEX(a ttdinv700910$idx1) */ a.t$cntr,a.t$cprj,a.t$cwar,a.t$item,a.t$koor,a.t$kost,a.t$logn,a.t$orno,a.t$pono,a.t$prst,a.t$quan,a.t$rlcd,a.t$sern,a.t$stoc,a.t$trdt,a.t$trtm,c.t$ascp,c.t$bcac,c.t$bcbi,c.t$bcim,c.t$bkcs,c.t$bkdt,c.t$cbdg,c.t$cprj,c.t$cuno,c.t$ddat,c.t$dsca,c.t$dscb,c.t$dscc,c.t$dscd,c.t$ecpa,c.t$ecpr,c.t$erev,c.t$ffci,c.t$intp,c.t$kopr,c.t$ncmp,c.t$plcd,c.t$pman,c.t$prtp,c.t$psta,c.t$psts,c.t$refe,c.t$sdat,c.t$seak,c.t$tinv,c.t$txta,d.t$aplo,d.t$arlo,d.t$cadr,d.t$ccty,d.t$comp,d.t$cwar,d.t$dsca,d.t$free,d.t$geoc$l,d.t$itlo,d.t$lolo,d.t$nama,d.t$namb,d.t$namc,d.t$namd,d.t$name,d.t$namf,d.t$nwrh,d.t$pstc,d.t$rwka,d.t$sloc,d.t$typw,e.t$abcc,e.t$actf,e.t$addi,e.t$allo,e.t$apka,e.t$apkb,e.t$assi,e.t$auso,e.t$avpr,e.t$bfcp,e.t$bfep,e.t$bfhr,e.t$blck,e.t$blcm,e.t$buyr,e.t$ccco,e.t$ccde,e.t$ccfu,e.t$ccit,e.t$ccur,e.t$cfmd,e.t$citg,e.t$cmgp,e.t$cntr,e.t$code,e.t$cont,e.t$copr,e.t$copt,e.t$cpcp,e.t$cpgp,e.t$cpgs,e.t$cpha,e.t$cplb,e.t$cpno,e.t$cppp,e.t$cprp,e.t$crmp,e.t$csel,e.t$csgp,e.t$csgs,e.t$csig,e.t$cspd,e.t$csps,e.t$ctyo,e.t$ctyp,e.t$cuid,e.t$cuni,e.t$cupp,e.t$cups,e.t$cuqp,e.t$cuqs,e.t$cvat,e.t$cwar,e.t$czed,e.t$dcnt,e.t$ddfq,e.t$dltm,e.t$dsca,e.t$dscb,e.t$dscc,e.t$dscd,e.t$ecoq,e.t$eitm,e.t$faml,e.t$ffsi,e.t$fioq,e.t$fodt,e.t$hall,e.t$hatc,e.t$imds,e.t$item,e.t$itmt,e.t$kitm,e.t$kltc,e.t$kpsl,e.t$lcod,e.t$ldsu,e.t$llcd,e.t$llci,e.t$lmsp,e.t$ltcp,e.t$ltdt,e.t$ltpp,e.t$ltpr,e.t$ltsp,e.t$maoq,e.t$matc,e.t$maxs,e.t$mioq,e.t$mrpc,e.t$mrpi,e.t$mrpo,e.t$ncst,e.t$ndrp,e.t$nnts,e.t$nobd,e.t$npsl,e.t$obpr,e.t$ocst,e.t$oint,e.t$oltm,e.t$omth,e.t$onew,e.t$opol,e.t$oprc,e.t$oqdr,e.t$oqmf,e.t$ordr,e.t$orip,e.t$osyc,e.t$osys,e.t$ownd,e.t$ownr,e.t$pcgp,e.t$pcrp,e.t$pics,e.t$pitm,e.t$plmm,e.t$potc,e.t$prip,e.t$prir,e.t$pris,e.t$proi,e.t$prre,e.t$purc,e.t$qbsi,e.t$qpnt,e.t$qual,e.t$quot,e.t$rbgp,e.t$reli,e.t$reop,e.t$repi,e.t$roun,e.t$runi,e.t$scdl,e.t$scoo,e.t$scpf,e.t$scst,e.t$seab,e.t$seak,e.t$serv,e.t$sfst,e.t$sftm,e.t$slmp,e.t$stgu,e.t$stmr,e.t$stoc,e.t$stpm,e.t$stva,e.t$suno,e.t$tmfc,e.t$trcd,e.t$tval,e.t$txta,e.t$txtp,e.t$txts,e.t$uabc,e.t$udlt,e.t$ufra,e.t$umer,e.t$umsp,e.t$unom,e.t$usab,e.t$uscu,e.t$uset,e.t$wght FROM baan.ttdinv700910 a,baan.ttiitm100910 b,baan.ttipcs020910 c,baan.ttcmcs003910 d,baan.ttiitm001910 e WHERE (:1 = :2 OR a.t$prst = :3) AND ((a.t$trdt < :4) OR ((a.t$trtm <= :5) AND a.t$trdt = :6)) AND ((a.t$trdt > :7) OR ((a.t$trtm >= :8) AND a.t$trdt = :9)) AND (a.t$cntr >= :10) AND (a.t$cntr <= :11) AND (a.t$cwar >= :12) AND (a.t$cwar <= :13) AND (a.t$trdt >= :14) AND (a.t$trdt <= :15) AND (a.t$orno >= :16) AND (a.t$orno <= :17) AND (a.t$rlcd >= :18) AND (a.t$rlcd <= :19) AND (a.t$cprj >= :20) AND (a.t$cprj <= :21) AND (a.t$logn >= :22) AND (a.t$logn <= :23) AND b.t$reli (+) = a.t$item AND b.t$cntr (+) = a.t$cntr AND e.t$item (+) = b.t$item AND d.t$cwar (+) = a.t$cwar AND c.t$cprj (+) = a.t$cprj AND (a.t$item >= :24) AND (a.t$item <= :25) AND a.t$koor = :26 AND (e.t$citg >= :27) AND (e.t$citg <= :28) AND (e.t$csgs >= :29) AND (e.t$csgs <= :30) ORDER BY 4,1,3,15,16,13