can anyone advise me please is there a way round solving this ice error

ie possible mis-aligned foreign keys feature.1=s32 tablexx.feature_=s38
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.

Answers

0
This is because one of the keys is not the same size/length as its meant to be.

ie: feature.1=s32 tablexx.feature_=s38

s32 = string of 32 chars length.
s38 = string of 38 chars length.


You will need to change the "column schema" (using Orca).
Answered 06/07/2005 by: brenthunter2005
Fifth Degree Brown Belt

Please log in to comment
0
hi hunter

can u kindly tell me want exactly I am changing


ie feature.1=s32 class.feature_=38
Answered 06/07/2005 by: cygan
Fifth Degree Brown Belt

Please log in to comment
0
thanks hunter i have done it
cheers
Answered 06/07/2005 by: cygan
Fifth Degree Brown Belt

Please log in to comment
0
Cool! [8D] And I didn't even need to say anything.
Answered 06/07/2005 by: brenthunter2005
Fifth Degree Brown Belt

Please log in to comment
0
Hi, I am getting a similar erro:

ICE32 ERROR Possible Mis-Aligned Foreign Keys
ModuleSignature.1 = s144
ModuleComponents.ModuleID = s72


Can you assist? What should I fix?

Thanks, Dafna
Answered 03/07/2006 by: DafnaF
Yellow Belt

Please log in to comment
0
Hi,
I'm getting a similar error in the validation table
ICE32 ERROR Possible Mis-Aligned Foreign Keys
ISIISCommon.1 = s50
ISIISMetaData.ISIISCommon_ = s72
Could you please tell me how to solve it?
Answered 05/06/2010 by: shetty_86
Senior Yellow Belt

Please log in to comment
0
Shetty,

way to revive old topics [:D]

Seriously though, what you could do is

Export the ISIISMetaData table
change it where it says s72 to s50 in your export
re-import the table

notice the bold font on could there though, wether you want to do this is debatable. I'm thinking this is an ICE validation error you might want to ignore. Basically what it's telling you is that a foreign key in one table (ISIISMetaData) doesn't match in formatting to the key that it references in the main table (ISIISCommon). my initial reaction to this is So What [:)]

Hope this helps,

PJ
Answered 05/06/2010 by: pjgeutjens
Red Belt

Please log in to comment
0
my initial reaction to this is So WhatHear, hear. I do know that some clients want all errors to be fixed but, frankly, that's where the packager's "client education baseball bat" needs to be introduced.
Answered 05/06/2010 by: VBScab
Red Belt

Please log in to comment
Answer this question or Comment on this question for clarity