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: u2-users@listserver.u2ug.org
> 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: owner-u2-us...@listserver.u2ug.org
> [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of
> ro...@optonline.netsent: 04 March 2009 17:37
> To: u2-users@listserver.u2ug.org
> 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
> 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/
-------
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
