XE : Problems on Table Design Aid with an index more than 10 columns

[dalfanz]

If a table has an index (even vanilla tables)the following pop up warning
error occurs:

Index (AB,CD,EFG,XXX,etc.) has more than 10 columns and may not generate in
all databases.
Do you want to save anyway? With "Yes"/"No" response tabs.

But the table is built on the entrprise server (AS/400)


Any insight/workarounds into this issue? Possible pitfalls on ignoring the
message?

Platform: AS/400; OneWorld XE SP 14

 

[Zoltan_Gyimesi]

Perry,
There are different index limitations for different DB type as DB2, Oracle, SQL, Access.
You can find these informations in the Development Tools documentation under the chapter "Performance Tip" in the topic "Index Limitations for Various Databases".
Zoltán

B7332 SP11, ESU 4116422, Intel NT4, SQL 7 SP1
(working with B7321, B7331, XE too)

 

[Seano]

Hi Perry,

As OneWorld tries to accomodate many platforms (and dbases), it has to use
the lowest common denominator between these dbases to generate indeces.

Access has to be supported in this (Datasource OneWorldLocal =
menus/dd/UDC's, if used), and this is a restriction of Access. I'm a little
surprised that vanilla tables are highlighting this as an error.

Check the OCM mappings for Local files (perhaps you always point UDC's,
menus etc to the ES and DD is not replicated) - if they're not mapped
locally, you can ignore this message as the mappings will point at the ES
(DB2), where this is not a restriction.

Seano.

_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

 

[c_moskowitz]

Hello Perry,

JDE has confirmed that this message is a 'warning' and
not an error and reflects the respective database (in
your case - DBII)recommended columnn limits.
According to JDE, this should not cause problems.
However if you do experience a problem, we'll need to
raise w/JDE.

Craig
--- Perry Burch <[email protected]> wrote:
>
> If a table has an index (even vanilla tables)the
> following pop up warning
> error occurs:
>
> Index (AB,CD,EFG,XXX,etc.) has more than 10 columns
> and may not generate in
> all databases.
> Do you want to save anyway? With "Yes"/"No" response
> tabs.
>
> But the table is built on the entrprise server
> (AS/400)
>
>
> Any insight/workarounds into this issue? Possible
> pitfalls on ignoring the
> message?
>
> Platform: AS/400; OneWorld XE SP 14
>
>
>
>
> --------------------------
> To view this thread, visit the JDEList forum at:
>
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=0&Board=OW&Number=4338
>
>
*************************************************************
> This is the JDEList One World / XE Mailing List.
> Archives and information on how to SUBSCRIBE, and
> UNSUBSCRIBE can be found at http://www.JDELIST.com
>
*************************************************************
>

 

[YaroslavMudrenko]

This problem also brings some inconvenience, when you are copying
environment from one installation to another using MS Access files and, for
instance, R98403 application. Tables are copied to Access, but 'long'
indexes are not created in Access file. You'll get errors such us 'can not
create indexes with more than 10 in MS Access.... ' in your log files, and
R98403 report says, that copy process was not successful for the table.
But when you actually copy data from Access to Target database (MS-SQL,
Oracle, or DB2) , proper indexes are created in normal way.
I've found about 20 such tables in Xe 'Business Data - xxxxx' datasource .

Yaroslav Mudrenko

Source: Xe Base, Ms-SQL 7.0 SP2
Target: Xe Base, Oracle 8.0.5 / NT





c_moskowitz <[email protected]>@jdelist.com on 21.01.2001 18:30:01

Please respond to [email protected]

Sent by: [email protected]


To: [email protected]
cc:

Subject: Re: XE : Problems on Table Design Aid with an index more than 10
columns ~~4338:4374


Hello Perry,

JDE has confirmed that this message is a 'warning' and
not an error and reflects the respective database (in
your case - DBII)recommended columnn limits.
According to JDE, this should not cause problems.
However if you do experience a problem, we'll need to
raise w/JDE.

Craig
--- Perry Burch <[email protected]> wrote:
>
> If a table has an index (even vanilla tables)the
> following pop up warning
> error occurs:
>
> Index (AB,CD,EFG,XXX,etc.) has more than 10 columns
> and may not generate in
> all databases.
> Do you want to save anyway? With "Yes"/"No" response
> tabs.
>
> But the table is built on the entrprise server
> (AS/400)
>
>
> Any insight/workarounds into this issue? Possible
> pitfalls on ignoring the
> message?
>
> Platform: AS/400; OneWorld XE SP 14
>
>
>
>
> --------------------------
> To view this thread, visit the JDEList forum at:
>
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=0&Board=OW&Number=4338

>
>
*************************************************************
> This is the JDEList One World / XE Mailing List.
> Archives and information on how to SUBSCRIBE, and
> UNSUBSCRIBE can be found at http://www.JDELIST.com
>
*************************************************************
>




--------------------------
To view this thread, visit the JDEList forum at:
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=0&Board=OW&Number=4374

*************************************************************
This is the JDEList One World / XE Mailing List.
Archives and information on how to SUBSCRIBE, and
UNSUBSCRIBE can be found at http://www.JDELIST.com
*************************************************************

 

[Adrian_Chimirel]

Yaroslav,
I couldn't help to notice you are running Xe on Oracle 805; I remember one of the requirements for Xe was Oracle 806, and that 805 was not supported. Is that right?
Thanks,
Adrian Chimirel

LIVE: B732.1 SP12.2, Oracle 805
SANDBOX: XE SP3, 8i
RS/6000, Citrix, 200+ clients