Roger, Two possibilities occur to me:- * How big is that Index file - it's not getting close to 2GB by any chance?
* Maybe it's getting confused between numbers and strings somehow: would something that works like SELECT FILE WITH " ":INVOICE EQ " 0499906608.1" [You could make a new I-Type called SPACE.INVOICE to do this and build a new Index]? Pretty much grasping at straws Regards Mike -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Thursday, 5 March 2009 8:11 a.m. To: [email protected] Subject: Re: RE: [U2] Universe Index still not working Yes, I was retyping, rather then cut and paste. Actual ids are co*custno*type.invoicemain.invoicesub Key INVOICE 01*165001*IN.0499906608.1 0499906608.1 dictionary = 0002: FIELD(FIELD(@ID,'*',3),'.',2,2) old dictionary = 0002: FIELD(@ID,'*',3)[4,999] both outputted what we needed. the old one was used for longer then I've been at this company. I tried changing it just in case. I really don't think it is dictionary related, since we did not change it until after the index stopped working. btw: for those that don't know SELECT FILE WITH INVOICE EQ "0499906608.1" NO.INDEX tells the command to skip the indexes and just go through the file. SELECT FILE WITH INVOICE EQ "0499906608.1" will go first to the index created for INVOICE. Hence the speed and why people use indexes but also the reason why we 'know' that something is broken in the index. If skipping the index works, doesn't that suggest something is wrong with the index? Thanks Roger ----- Original Message ----- From: kishor Date: Wednesday, March 4, 2009 1:56 pm Subject: RE: [U2] Universe Index not working To: [email protected] > Shouldn't dictionary #2 > Be FIELD(FIELD(@ID,'*',2),'.',3,2) > Instead of > FIELD(FIELD(@ID,'*',3),'.',2.2) > > This will return > 10000123.2 > > Don't know why some selects worked. > > Regards, > Kishor Parmar > > > -----Original Message----- > From: [email protected] > [mailto:[email protected]] On Behalf Of > [email protected]: 04 March 2009 17:37 > To: [email protected] > Subject: [U2] Universe Index not working > > AIX 5.3 Universe 10.2.4 300+ user license > > Moved from older aix/universe 9.5 to current one in September 2008. > No index problems. > > File contains 1.5 million records. key = company number * customer > number.xx.invoicenumber.invoicesubnumber. > so the key looks like > 01*123456.IN.10000123.2 > 01*123456.IN.10000123.3 > > The invoice number should be unique, except for the subnumbers. > dictionary #2 - FIELD(FIELD(@ID,'*',3),'.',2.2) > > On Monday, SELECT FILE WITH INVOICE EQ "1000123.2" found 0 > records. Other > SELECTS seemed to work. The keys are clean, no special characters. > SELECT FILE WITH INVOICE EQ "1000123.2" NO.INDEX finds 2 records? > > I did a build.index file on Tuesday morning. didnt work. > Late Tuesday evening, I deleted the index and recreated it and > then rebuilt > it. didnt work. > I also copied the contents of the file and the dictionaries from > one file to > a new one. recreated and rebuilt the index. so no luck. > > There are no error messages. nothing reported when files were > copied. same > number records before and after. > > Any thoughts? > Tonight I'll try a universe shutdown and restart. > > Thanks. > Roger Glenfield > ------- > u2-users mailing list > [email protected] > To unsubscribe please visit http://listserver.u2ug.org/ > ------- > u2-users mailing list > [email protected] > To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this Internet Email message is intended for the addressee only and may contain privileged information, but not necessarily the official views or opinions of the New Zealand Defence Force. If you are not the intended recipient you must not use, disclose, copy or distribute this message or the information in it. If you have received this message in error, please Email or telephone the sender immediately. ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
