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

kk_jde

Active Member
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
 
KK,

I'm sure that you've done this, but by making a new index, you needed to alter the table object, and therefore, for the enterprise server and any workstations to use it within OW it needs to be packaged and deployed to the workstations and ES. While the index was actually created on the DB side, so non-OW apps could use it, any machine that needs to access it within OW has to have the new table specs with the new index.

Just the first thing that popped into my noggin...

Regards,

Jim
 
Jim,

That is true. But I was trying to make this thing work in my FAT client first. I did change the Table object to add the new index in my FAT client, then changed the application to use the new index in Table I/O.

I am testing this in my local FAT client. So
- My FAT Client has the table spec with new index
- F98712 & F98713 has the new index definition
- Oracle has the new index

Not sure what else I am missing.

Does anyone know what JDE does when we generate indices for a table thru TDA (besides dropping all indices and creating them again)? For example like writing to any definition table (F98*) or something like that? Even JDE_Debug log doesn't give me whole lot of information.

Thanks
kk
 
It may be a stupid question, but do your two index names match? I mean, is
the Oracle index name identical to the name you used in OW?

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: Tuesday, September 09, 2003 9:08 AM
Subject: Re: Using Oracle Generated (Outside) Index in JDE Apps (Table I/O)


first. I did change the Table object to add the new index in my FAT client,
then changed the application to use the new index in Table I/O.
TDA (besides dropping all indices and creating them again)? For example like
writing to any definition table (F98*) or something like that? Even
JDE_Debug log doesn't give me whole lot of information.
http://www.jdelist.com/ubb/showthreaded.php?Cat=&Board=OW&Number=61101
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®
 
KK...

First I'd check if the index was in RDB (F98712/F98713) and in Tam (DDPKEYH/DDPKEYD I believe). Though I know you say you are on the machine you created the index on, I'd still make sure the index appears in the TAMs.

Other than that, I'd say the best thing to do is re-gen the indexes for the table in DEV or PY and see if it goes. I didn't think that OW would care if the index was generated within OW or not, but perhaps it does in this case. My only guess is that when adding new indexes perhaps they need to be re-gened from within OneWorld and thereafter they can be done via the RDBMS if needed.

Sorry, all I can think of without seeing the full debug log.

Jim
 
That is a good question. I checked and both of them are same (F5642CPH_6).
 
Back
Top