I believe that the problem is that the hash algorithm used to determine which
group the item goes into uses the whole key as provided to it, but everything
after the first attribute mark becomes part of the item, and from the point of
view of the system, stops being part of the key. So a key of "A^B" (where "^"
is the attribute mark) gets assigned a group based on the modulo of the hash of
"A^B", but only "A" gets stored as the actual item-id. ("B" becomes attribute
one and pushes all the others down.)
So trying to "ED"it them or use delete with them may not actually work, as this
process tries to find "A^B", but can only see "A". If you try to edit "A", the
hash algorithm is likely to arrive at a different modulo, and it will look in
the group where "A" should have been (you might actually have an item-id "A" in
that group) and won't find the bad one, which is in the wrong group.
Depending on your Universe file type, I may be a bit off, and Universe might do
something a subtly different, but that's the gist of your problem.
The safest way to deal with this is to create a new file, then do something
like this:
COPY OLDFILE *
TO:(NEWFILE
This *might* actually work. Again, if you had both "A^B" and "A" in the file,
the second one will complain. You could maybe use "(D" as an option to delete
the ones that successfully copied, but that might fail, too, depending how it
was implemented. You could then copy the remaining records to another file and
figure out how to merge the duplicates.
This advice comes with no warranty! Your mileage may vary. Good luck! ;)
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Wally Terhune
Sent: Monday, April 07, 2008 1:50 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Keys with @AM in them...
uh, write the same program to construct the keys and delete them?
There are notes about finding these actual keys (to use in your fix
program) in one of my various UniData troubleshooting presentations - from
U2U, at least.
In the context of 'duplicate keys'.
Wally Terhune
SWG Client Support - Information
Management Software
U2 Support Architect b IBM U2
Client Support Team
4700 S. Syracuse St., Denver, CO
80237
Tel: (303) 773-7969 T/L
656-7969
Mobile: (303) 807-6222
[EMAIL PROTECTED]
"David Wolverton"
<[EMAIL PROTECTED]
et> To
Sent by: <u2-users@listserver.u2ug.org>
[EMAIL PROTECTED] cc
stserver.u2ug.org
Subject
[U2] Keys with @AM in them...
04/07/2008 01:15
PM
Please respond to
[EMAIL PROTECTED]
er.u2ug.org
How do I fix this?
My program wrote items with @AM in the key. (oops)
Now, I can 'select' the items, but I cannot get rid of them - they show as
non-existent.
Is there a way to remove/clean up these records, or will I have to clear
the
file and copy the good records back in?
-------
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
[demime 1.01d removed an attachment of type image/jpeg which had a name of
09407543.jpg]
[demime 1.01d removed an attachment of type image/gif which had a name of
graycol.gif]
[demime 1.01d removed an attachment of type image/gif which had a name of
pic29301.gif]
[demime 1.01d removed an attachment of type image/gif which had a name of
ecblank.gif]
-------
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
-------
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
