[U2] UV index with duplicate nodes
We've just uncovered a rather unusual and unsettling situation. We have a file with a single index that has somehow gotten nodes with duplicate keys. A simple example would be having an index on ZIPCODE in a address database, and finding that there are _two_ nodes (records) in the index for ZIPCODE 12345, for example. The source records referred to in the nodes are not duplicated, but since most operations find the 'first' node, any source records referred to in the duplicate node appear to not exist in the index. LIST.INDEX fname ALL Alternate Key Index Summary for file fname File... fname Indices 1 (1 A-type, 0 C-type, 0 D-type, 0 I-type, 0 SQL, 0 S-type) Index Updates.. Enabled, No updates pending Index name Type BuildNulls In DICT S/M Just Unique Field num/I-type fieldnameANot Reqd YesYes ML N2 The file contains 6,539,233 records, with 574,547 unique values in fieldname (which is actually a single-valued field, and has been verified that each record's fieldname contains one and only one value). We found that 9 source records appear to have not been included in the index, but upon further research found the nodes with duplicate keys. We created an F-pointer to the index file itself (not normally recommended, but useful), then got the results like the following: LIST indexfile WITH @ID = 12345] F1 F2 fname. F1 F2 12345 987654 876543 12345-6789 765432 543219 12345 654321 We are having our UniVerse administrator ask our dealer for assistance, but were interested if any other users have had any recent similar experiences, or advice. Sincerely Best Regards, Richard Lewis IBM Certified Solutions Expert Nu Skin Enterprises ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] where did everyone go ?
Same here :-) Anant On Tue, Sep 28, 2010 at 12:58 PM, bpar...@nemianlife.lu wrote: I'm lurking as usual, nothing to add, lots to learn. 8-) Brian From: u2ug simpson-u...@gerzio.ca To: u2-users@listserver.u2ug.org Date: 27/09/2010 18:07 Subject:[U2] where did everyone go ? Sent by:u2-users-boun...@listserver.u2ug.org The number of postings has drastically dropped over the past few weeks down to virtually zero Has the list been relegated the dust bin and I missed the notice ? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] where did everyone go ?
I'm still here :) I noticed the same thing though. Wonder if some people dropped off the mailing list.. -Chris Date: Fri, 1 Oct 2010 06:52:26 +0530 From: anantkum...@gmail.com To: u2-users@listserver.u2ug.org Subject: Re: [U2] where did everyone go ? Same here :-) Anant On Tue, Sep 28, 2010 at 12:58 PM, bpar...@nemianlife.lu wrote: I'm lurking as usual, nothing to add, lots to learn. 8-) Brian From: u2ug simpson-u...@gerzio.ca To: u2-users@listserver.u2ug.org Date: 27/09/2010 18:07 Subject: [U2] where did everyone go ? Sent by: u2-users-boun...@listserver.u2ug.org The number of postings has drastically dropped over the past few weeks down to virtually zero Has the list been relegated the dust bin and I missed the notice ? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] where did everyone go ?
I just replied to this thread, and noticed something very odd. I got this message: mvargh...@silverlinewindow.com - no such user here. There is no user by that name at this server. : Message contains [1] file attachments --- Maybe this has something to do with it?? -Chris Date: Fri, 1 Oct 2010 06:52:26 +0530 From: anantkum...@gmail.com To: u2-users@listserver.u2ug.org Subject: Re: [U2] where did everyone go ? Same here :-) Anant On Tue, Sep 28, 2010 at 12:58 PM, bpar...@nemianlife.lu wrote: I'm lurking as usual, nothing to add, lots to learn. 8-) Brian From: u2ug simpson-u...@gerzio.ca To: u2-users@listserver.u2ug.org Date: 27/09/2010 18:07 Subject: [U2] where did everyone go ? Sent by: u2-users-boun...@listserver.u2ug.org The number of postings has drastically dropped over the past few weeks down to virtually zero Has the list been relegated the dust bin and I missed the notice ? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] where did everyone go ?
I just replied to this thread, and noticed something very odd. I got this message: mvargh...@silverlinewindow.com - no such user here. There is no user by that name at this server. : Message contains [1] file attachments --- Maybe this has something to do with it?? -Chris Date: Fri, 1 Oct 2010 06:52:26 +0530 From: anantkum...@gmail.com To: u2-users@listserver.u2ug.org Subject: Re: [U2] where did everyone go ? Same here :-) Anant On Tue, Sep 28, 2010 at 12:58 PM, bpar...@nemianlife.lu wrote: I'm lurking as usual, nothing to add, lots to learn. 8-) Brian From: u2ug simpson-u...@gerzio.ca To: u2-users@listserver.u2ug.org Date: 27/09/2010 18:07 Subject: [U2] where did everyone go ? Sent by: u2-users-boun...@listserver.u2ug.org The number of postings has drastically dropped over the past few weeks down to virtually zero Has the list been relegated the dust bin and I missed the notice ? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] where did everyone go ?
I have received several of those mystery E-mails as well, plus that attachment. The attachment has always had the same name but been variable in size, and I have not opened it. John Israel Sr. Programmer/Analyst Dayton Superior Corporation 721 Richard St. Dayton, OH 45342 937-866-0711 x44380 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris Austin Sent: Thursday, September 30, 2010 10:01 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] where did everyone go ? I just replied to this thread, and noticed something very odd. I got this message: mvargh...@silverlinewindow.com - no such user here. There is no user by that name at this server. : Message contains [1] file attachments --- Maybe this has something to do with it?? -Chris Date: Fri, 1 Oct 2010 06:52:26 +0530 From: anantkum...@gmail.com To: u2-users@listserver.u2ug.org Subject: Re: [U2] where did everyone go ? Same here :-) Anant On Tue, Sep 28, 2010 at 12:58 PM, bpar...@nemianlife.lu wrote: I'm lurking as usual, nothing to add, lots to learn. 8-) Brian From: u2ug simpson-u...@gerzio.ca To: u2-users@listserver.u2ug.org Date: 27/09/2010 18:07 Subject: [U2] where did everyone go ? Sent by: u2-users-boun...@listserver.u2ug.org The number of postings has drastically dropped over the past few weeks down to virtually zero Has the list been relegated the dust bin and I missed the notice ? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UV index with duplicate nodes
Does the correlative have any special coding in it? I would suggest deleting the index for this field recreate the field as a D type then add the field to the index again. Some correlatives don't give you what you would expect. Jerry Banker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Richard Lewis Sent: Thursday, September 30, 2010 7:47 PM To: U2-Users@listserver.u2ug.org Subject: [U2] UV index with duplicate nodes We've just uncovered a rather unusual and unsettling situation. We have a file with a single index that has somehow gotten nodes with duplicate keys. A simple example would be having an index on ZIPCODE in a address database, and finding that there are _two_ nodes (records) in the index for ZIPCODE 12345, for example. The source records referred to in the nodes are not duplicated, but since most operations find the 'first' node, any source records referred to in the duplicate node appear to not exist in the index. LIST.INDEX fname ALL Alternate Key Index Summary for file fname File... fname Indices 1 (1 A-type, 0 C-type, 0 D-type, 0 I-type, 0 SQL, 0 S-type) Index Updates.. Enabled, No updates pending Index name Type BuildNulls In DICT S/M Just Unique Field num/I-type fieldnameANot Reqd YesYes ML N2 The file contains 6,539,233 records, with 574,547 unique values in fieldname (which is actually a single-valued field, and has been verified that each record's fieldname contains one and only one value). We found that 9 source records appear to have not been included in the index, but upon further research found the nodes with duplicate keys. We created an F-pointer to the index file itself (not normally recommended, but useful), then got the results like the following: LIST indexfile WITH @ID = 12345] F1 F2 fname. F1 F2 12345 987654 876543 12345-6789 765432 543219 12345 654321 We are having our UniVerse administrator ask our dealer for assistance, but were interested if any other users have had any recent similar experiences, or advice. Sincerely Best Regards, Richard Lewis IBM Certified Solutions Expert Nu Skin Enterprises ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UV index with duplicate nodes
I assume you have tried rebuilding the indices? That usually fixes almost all of our issues with index problems. Otherwise I would delete the index and build it back again. If you need any code that we use just ask me and I can email it to you. -Chris From: jpb-u...@hotmail.com To: u2-users@listserver.u2ug.org Date: Thu, 30 Sep 2010 21:19:22 -0500 Subject: Re: [U2] UV index with duplicate nodes Does the correlative have any special coding in it? I would suggest deleting the index for this field recreate the field as a D type then add the field to the index again. Some correlatives don't give you what you would expect. Jerry Banker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Richard Lewis Sent: Thursday, September 30, 2010 7:47 PM To: U2-Users@listserver.u2ug.org Subject: [U2] UV index with duplicate nodes We've just uncovered a rather unusual and unsettling situation. We have a file with a single index that has somehow gotten nodes with duplicate keys. A simple example would be having an index on ZIPCODE in a address database, and finding that there are _two_ nodes (records) in the index for ZIPCODE 12345, for example. The source records referred to in the nodes are not duplicated, but since most operations find the 'first' node, any source records referred to in the duplicate node appear to not exist in the index. LIST.INDEX fname ALL Alternate Key Index Summary for file fname File... fname Indices 1 (1 A-type, 0 C-type, 0 D-type, 0 I-type, 0 SQL, 0 S-type) Index Updates.. Enabled, No updates pending Index name Type Build Nulls In DICT S/M Just Unique Field num/I-type fieldname A Not Reqd Yes Yes M L N 2 The file contains 6,539,233 records, with 574,547 unique values in fieldname (which is actually a single-valued field, and has been verified that each record's fieldname contains one and only one value). We found that 9 source records appear to have not been included in the index, but upon further research found the nodes with duplicate keys. We created an F-pointer to the index file itself (not normally recommended, but useful), then got the results like the following: LIST indexfile WITH @ID = 12345] F1 F2 fname. F1 F2 12345 987654 876543 12345-6789 765432 543219 12345 654321 We are having our UniVerse administrator ask our dealer for assistance, but were interested if any other users have had any recent similar experiences, or advice. Sincerely Best Regards, Richard Lewis IBM Certified Solutions Expert Nu Skin Enterprises ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
