Using Oracle Generated (Outside) Index in JDE Apps (Table I/O)

[kk_jde]

All,

I am looking for some help here. I am sure this is the right group of people to ask for the help.

We created a index (for different requirement) to a JDE Table (F5642CPH) directly in Oracle. (We never liked the JDE idea of dropping all the indices and then generating them one after the other- for timing and performance reasons). This index is defined in JDE (using TDA) but not generated thru JDE but generated directly in Oracle (for timing and other reasons).

Now I would like to use this index in a JDE application for suqencing and grouping reasons. When I use this Index in JDE , it gives me the follwoing errors.

jdb_rq1.c707
JDB9900920 - Failed to find index 6 for table F5642CPH

jdb_rq1.c1998
JDB3100014 - Failed to load requested index

Defintion of this Index exists in F98712 & F98713 tables. I did restart JDE/Computer and tried all I could. ( Please Note : When I generated the same index in another JDE test environment using test schema which doesn't have much data it works.)

I guess what I need to know is how can we make JDE (Table I/O) recognise an Index that is generated outside of JDE.

I am sure someone in this group ran into this before. Any help that you guys can give me is grealty appreciated.

Thanks
KK
(XE, SP22 F1, NT, ORACLE, HP-UNIX)


---------------------------------
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software

 

[maguirem]

I have done this numerous times. Here is what I have done - but I think you are on the right track anyway.....

Create index's using oracle db admin tools (in one project the DBA was the only person who could create index's). Ensure that the index schema is noted accurately in the correct order. Call the index what you like, but best to avoid names that JDE might use eg F0911_12 etc. We used F0911_ClientPrefix_123 or F0911_Mike - not really but you get the idea.

Go to OneWorld and design the table. Create new indexes in OW in the same order as those created in the DB admin tool. Don't generate the index's.

Check in the index and promote the table to environments that need it and deploy it into packages.

Now this has created in OW schema a representation of an index. If this is used by a developer in table IO then the middle wear just sends of correctly formed SQL to the database. OW DOES NOT CARE whether the index exists in Oracle or not. However your users will care as performance may be terrible if indexes are not in place. Anyway, when OW sends ANY queries off to the database it does not need the index to exist in the database in order to create the SQL.

I suspect that you have create the index in OW, and the developer is using it, but the table has not been checked in and promoted to your envirnments and client computers.

Regards
Mike

 

[kk_jde]

MaguireM,

I did the exact same thing like you said except the package build part. Table is changed and new index is added using TDA, checked-in and promoted to the path codes. Since this is being tested in a Local FAT client I don't think I require a package build, right?.

I tried using different name (F5642CPH_xxx01) , also tried using the same name as in JDE (F5642CPH_6). As soon as it gets to the table I/O it is NOT able to find/recognize the index (in JDE) and gives error.

Thanks,

 

[Alex_Pastuhov]

Can you attach a JDEDEBUG.LOG for the event in question?

Regards,
Alexander Pastuhov
Pastuhov Consulting Pty. Ltd.
E-Mail: [email protected]
Mobile: 0414 453 433
WWW: http://www.pastuhov.com.au/index.htm
CNC Consulting and Software Tools for OneWorld®
Check out our Special Offers at:
http://www.pastuhov.com.au/special_offers.htm

RESTRICTIONS ON USE REPRODUCTION OR DISCLOSURE
The information contained in this email and attachments (if any) is intended
to be communicated only to the person or persons named as addressees.
Copyright subsists in this email. If you are not named as an addressee you
are prohibited from using, reproducing, or disclosing the information in
this email and the existence of this email itself. The information in this
email may also be confidential and subject to professional privilege.
If so, all rights are reserved by the owner of those rights. If you are not
a named addressee please advise us immediately and destroy all copies of
this email in your possession or control. Pastuhov Consulting Pty. Ltd.

----- Original Message -----
From: "kk_jde" <[email protected]>
To: <[email protected]>
Sent: Wednesday, September 10, 2003 9:28 AM
Subject: Re: Using Oracle Generated (Outside) Index in JDE Apps (Table I/O)


Table is changed and new index is added using TDA, checked-in and promoted
to the path codes. Since this is being tested in a Local FAT client I don't
think I require a package build, right?.
name as in JDE (F5642CPH_6). As soon as it gets to the table I/O it is NOT
able to find/recognize the index (in JDE) and gives error.
http://www.jdelist.com/ubb/showthreaded.php?Cat=&Board=OWDEV&Number=61149
these messages, login to http://www.jdelist.com/forums, click Control Panel,
then click Edit by "Subscribe / Unsubscribe from receiving board posts by
email, change message notifications, etc." and adjust your subscription
preferences. JDEList is not affiliated with JDEdwards®