OW Xe and Oracle 8.1.6.3 max extents

jdcmwilson

Well Known Member
JDE List,

Please help!

We are having problems with our oracle database and OneWorld. We are
attempting to do a data load and we get extents errors. I would like to
know both the original cause (thought JDE installed with max extents as
default) and how to fix the problem. It seems as though all JDE OneWorld
table default to 505 and we cannot get auto-extents to work. Right now
there is finger pointing going on between the Oracle people (saying it is
OneWorld) and technical JDE people feeling it is Oracle. I need to put this
"to bed".

Here is my specific error: ORA-01654: unable to extend index
PRODDTA.F5647003_PK by 40964 in tablespace PRODDTAI.

Here is an excerpt from by jde.log also:
------------------------------------------------------------------------
1616/1564 Thu Aug 23 19:42:08 2001 jdb_drvm.c887
JDB9900401 - Failed to execute db request

1616/1564 Thu Aug 23 19:42:08 2001 jdb_exet.c4432
JDB3400009 - Failed to perform Insert for F5647003

1616/1564 Thu Aug 23 19:42:08 2001 DBPERFRQ.C377
OCI0000178 - Unable to execute - 0 - INSERT INTO PRODDTA.F5647003 (QCKCOO,
QCDOCO, QCDCTO, QCLNID, QCECSQ, QCLNIX, QCUOM, QCUPAX, QCDS01, QCCITM,
QCVDSTA, QCAPPF, QCACQT, QCUOM1, QCUORG, QCHT, QCRTEQ, QCURCD, QCUSRCD1,
QCAN8, QCAN81, QCAN82, QCUPRC, QCFUPC, QCRUP, QCALPH, QCALPH5, QCALPH6,
QCEDTY, QCEDSQ, QCEKCO, QCEDOC, QCEDCT, QCEDLN, QCEDSP, QCEDBT, QCFILE,
QCLINS, QCTORG, QCUSER, QCPID, QCJOBN, QCUPMJ, QCTDAY) VALUES
:)BND1,:BND2,:BND3,:BND4,:BND5,:BND6,:BND7,:BND8,:BND9,:BND10,:BND11,:BND12,:BND13,:BND14,:BND15,:BND16,:BND17,:BND18,:BND19,:BND20,:BND21,:BND22,:BND23,:BND24,:BND25,:BND26,:BND27,:BND28,:BND29,:BND30,:BND31,:BND32,:BND33,:BND34,:BND35,:BND36,:BND37,:BND38,:BND39,:BND40,:BND41,:BND42,:BND43,:BND44)

1616/1564 Thu Aug 23 19:42:08 2001 DBPERFRQ.C384
OCI0000179 - Error - ORA-01654: unable to extend index PRODDTA.F5647003_PK
by 40964 in tablespace PRODDTAI

1616/1564 Thu Aug 23 19:42:08 2001 jdb_drvm.c887
JDB9900401 - Failed to execute db request

1616/1564 Thu Aug 23 19:42:08 2001 jdb_exet.c4432
JDB3400009 - Failed to perform Insert for F5647003

1616/1564 Thu Aug 23 19:42:09 2001 DBPERFRQ.C377
OCI0000178 - Unable to execute - 0 - INSERT INTO PRODDTA.F5647003 (QCKCOO,
QCDOCO, QCDCTO, QCLNID, QCECSQ, QCLNIX, QCUOM, QCUPAX, QCDS01, QCCITM,
QCVDSTA, QCAPPF, QCACQT, QCUOM1, QCUORG, QCHT, QCRTEQ, QCURCD, QCUSRCD1,
QCAN8, QCAN81, QCAN82, QCUPRC, QCFUPC, QCRUP, QCALPH, QCALPH5, QCALPH6,
QCEDTY, QCEDSQ, QCEKCO, QCEDOC, QCEDCT, QCEDLN, QCEDSP, QCEDBT, QCFILE,
QCLINS, QCTORG, QCUSER, QCPID, QCJOBN, QCUPMJ, QCTDAY) VALUES
:)BND1,:BND2,:BND3,:BND4,:BND5,:BND6,:BND7,:BND8,:BND9,:BND10,:BND11,:BND12,:BND13,:BND14,:BND15,:BND16,:BND17,:BND18,:BND19,:BND20,:BND21,:BND22,:BND23,:BND24,:BND25,:BND26,:BND27,:BND28,:BND29,:BND30,:BND31,:BND32,:BND33,:BND34,:BND35,:BND36,:BND37,:BND38,:BND39,:BND40,:BND41,:BND42,:BND43,:BND44)

1616/1564 Thu Aug 23 19:42:09 2001 DBPERFRQ.C384
OCI0000179 - Error - ORA-01654: unable to extend index PRODDTA.F5647003_PK
by 40964 in tablespace PRODDTAI

1616/1564 Thu Aug 23 19:42:09 2001 jdb_drvm.c887
JDB9900401 - Failed to execute db request

1616/1564 Thu Aug 23 19:42:09 2001 jdb_exet.c4432
JDB3400009 - Failed to perform Insert for F5647003

1616/1564 Thu Aug 23 19:42:09 2001 DBPERFRQ.C377
OCI0000178 - Unable to execute - 0 - INSERT INTO PRODDTA.F5647003 (QCKCOO,
QCDOCO, QCDCTO, QCLNID, QCECSQ, QCLNIX, QCUOM, QCUPAX, QCDS01, QCCITM,
QCVDSTA, QCAPPF, QCACQT, QCUOM1, QCUORG, QCHT, QCRTEQ, QCURCD, QCUSRCD1,
QCAN8, QCAN81, QCAN82, QCUPRC, QCFUPC, QCRUP, QCALPH, QCALPH5, QCALPH6,
QCEDTY, QCEDSQ, QCEKCO, QCEDOC, QCEDCT, QCEDLN, QCEDSP, QCEDBT, QCFILE,
QCLINS, QCTORG, QCUSER, QCPID, QCJOBN, QCUPMJ, QCTDAY) VALUES
:)BND1,:BND2,:BND3,:BND4,:BND5,:BND6,:BND7,:BND8,:BND9,:BND10,:BND11,:BND12,:BND13,:BND14,:BND15,:BND16,:BND17,:BND18,:BND19,:BND20,:BND21,:BND22,:BND23,:BND24,:BND25,:BND26,:BND27,:BND28,:BND29,:BND30,:BND31,:BND32,:BND33,:BND34,:BND35,:BND36,:BND37,:BND38,:BND39,:BND40,:BND41,:BND42,:BND43,:BND44)

1616/1564 Thu Aug 23 19:42:09 2001 DBPERFRQ.C384
OCI0000179 - Error - ORA-01654: unable to extend index PRODDTA.F5647003_PK
by 40964 in tablespace PRODDTAI

1616/1564 Thu Aug 23 19:42:09 2001 jdb_drvm.c887
JDB9900401 - Failed to execute db request

1616/1564 Thu Aug 23 19:42:09 2001 jdb_exet.c4432
JDB3400009 - Failed to perform Insert for F5647003

1616/1564 Thu Aug 23 19:42:10 2001 DBPERFRQ.C377
OCI0000178 - Unable to execute - 0 - INSERT INTO PRODDTA.F5647003 (QCKCOO,
QCDOCO, QCDCTO, QCLNID, QCECSQ, QCLNIX, QCUOM, QCUPAX, QCDS01, QCCITM,
QCVDSTA, QCAPPF, QCACQT, QCUOM1, QCUORG, QCHT, QCRTEQ, QCURCD, QCUSRCD1,
QCAN8, QCAN81, QCAN82, QCUPRC, QCFUPC, QCRUP, QCALPH, QCALPH5, QCALPH6,
QCEDTY, QCEDSQ, QCEKCO, QCEDOC, QCEDCT, QCEDLN, QCEDSP, QCEDBT, QCFILE,
QCLINS, QCTORG, QCUSER, QCPID, QCJOBN, QCUPMJ, QCTDAY) VALUES
:)BND1,:BND2,:BND3,:BND4,:BND5,:BND6,:BND7,:BND8,:BND9,:BND10,:BND11,:BND12,:BND13,:BND14,:BND15,:BND16,:BND17,:BND18,:BND19,:BND20,:BND21,:BND22,:BND23,:BND24,:BND25,:BND26,:BND27,:BND28,:BND29,:BND30,:BND31,:BND32,:BND33,:BND34,:BND35,:BND36,:BND37,:BND38,:BND39,:BND40,:BND41,:BND42,:BND43,:BND44)

1616/1564 Thu Aug 23 19:42:10 2001 DBPERFRQ.C384
OCI0000179 - Error - ORA-01654: unable to extend index PRODDTA.F5647003_PK
by 40964 in tablespace PRODDTAI

1616/1564 Thu Aug 23 19:42:10 2001 jdb_drvm.c887
JDB9900401 - Failed to execute db request

1616/1564 Thu Aug 23 19:42:10 2001 jdb_exet.c4432
JDB3400009 - Failed to perform Insert for F5647003

1616/1564 Thu Aug 23 19:42:10 2001 DBPERFRQ.C377
OCI0000178 - Unable to execute - 0 - INSERT INTO PRODDTA.F5647003 (QCKCOO,
QCDOCO, QCDCTO, QCLNID, QCECSQ, QCLNIX, QCUOM, QCUPAX, QCDS01, QCCITM,
QCVDSTA, QCAPPF, QCACQT, QCUOM1, QCUORG, QCHT, QCRTEQ, QCURCD, QCUSRCD1,
QCAN8, QCAN81, QCAN82, QCUPRC, QCFUPC, QCRUP, QCALPH, QCALPH5, QCALPH6,
QCEDTY, QCEDSQ, QCEKCO, QCEDOC, QCEDCT, QCEDLN, QCEDSP, QCEDBT, QCFILE,
QCLINS, QCTORG, QCUSER, QCPID, QCJOBN, QCUPMJ, QCTDAY) VALUES
:)BND1,:BND2,:BND3,:BND4,:BND5,:BND6,:BND7,:BND8,:BND9,:BND10,:BND11,:BND12,:BND13,:BND14,:BND15,:BND16,:BND17,:BND18,:BND19,:BND20,:BND21,:BND22,:BND23,:BND24,:BND25,:BND26,:BND27,:BND28,:BND29,:BND30,:BND31,:BND32,:BND33,:BND34,:BND35,:BND36,:BND37,:BND38,:BND39,:BND40,:BND41,:BND42,:BND43,:BND44)

1616/1564 Thu Aug 23 19:42:10 2001 DBPERFRQ.C384
OCI0000179 - Error - ORA-01654: unable to extend index PRODDTA.F5647003_PK
by 40964 in tablespace PRODDTAI

1616/1564 Thu Aug 23 19:42:10 2001 jdb_drvm.c887
JDB9900401 - Failed to execute db request

1616/1564 Thu Aug 23 19:42:10 2001 jdb_exet.c4432
JDB3400009 - Failed to perform Insert for F5647003

1616/1564 Thu Aug 23 19:42:10 2001 DBPERFRQ.C377
OCI0000178 - Unable to execute - 0 - INSERT INTO PRODDTA.F5647003 (QCKCOO,
QCDOCO, QCDCTO, QCLNID, QCECSQ, QCLNIX, QCUOM, QCUPAX, QCDS01, QCCITM,
QCVDSTA, QCAPPF, QCACQT, QCUOM1, QCUORG, QCHT, QCRTEQ, QCURCD, QCUSRCD1,
QCAN8, QCAN81, QCAN82, QCUPRC, QCFUPC, QCRUP, QCALPH, QCALPH5, QCALPH6,
QCEDTY, QCEDSQ, QCEKCO, QCEDOC, QCEDCT, QCEDLN, QCEDSP, QCEDBT, QCFILE,
QCLINS, QCTORG, QCUSER, QCPID, QCJOBN, QCUPMJ, QCTDAY) VALUES
:)BND1,:BND2,:BND3,:BND4,:BND5,:BND6,:BND7,:BND8,:BND9,:BND10,:BND11,:BND12,:BND13,:BND14,:BND15,:BND16,:BND17,:BND18,:BND19,:BND20,:BND21,:BND22,:BND23,:BND24,:BND25,:BND26,:BND27,:BND28,:BND29,:BND30,:BND31,:BND32,:BND33,:BND34,:BND35,:BND36,:BND37,:BND38,:BND39,:BND40,:BND41,:BND42,:BND43,:BND44)

1616/1564 Thu Aug 23 19:42:10 2001 DBPERFRQ.C384
OCI0000179 - Error - ORA-01654: unable to extend index PRODDTA.F5647003_PK
by 40964 in tablespace PRODDTAI

------------------------------------------------------------------------

Any help will be greatly appreciated.

James Wilson
CNC Consultant

OW Xe B73.3.3 SP16 AIX
IBM RS/6000 AIX 4.3.3 Enterprise Server (Central Objects)
Oracle DB 8.1.6.3
NT 4.0 Deployment Server
"fat" Win95/Win98 and TSE/Citrix "thin" clients
ZenWorks - using to deploy initial OneWorld clients





All views are expressly my own and in no way reflect those of my employer.
 
Top