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
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