Problem with creating index on hash file

devnhi · Post by **devnhi** » Tue Feb 07, 2012 10:11 pm

Hi

Recently we have migrated to 8.5 version and I am trying to create indexes on the hash file . I was able to create VOC entry successfully after that with the syntax :
>CREATE.INDEX ProcKeyLookup PROC_CODE

Unable to open "DICT ProcKeyLookup".
>BUILD.INDEX ProcKeyLookup PROC_CODE

Unable to open "DICT ProcKeyLookup".

Can somebody help me to resolve this issue .

Thanks in advance.

ray.wurlod · Post by **ray.wurlod** » Tue Feb 07, 2012 10:26 pm

How was the hashed file created?

What does its VOC entry look like? To find out:

Code: Select all

LIST.ITEM VOC 'hashedfilename'

devnhi · Post by **devnhi** » Wed Feb 08, 2012 4:42 pm

When I did it is saying :

LIST.ITEM VOC ProcKeyLookup

Retrieve: syntax error. Unexpected filename. Token was "ProcKeyLookup".
Scanned command was LIST.ITEM VOC ProcKeyLookup

Did i do any thing wrong?

ray.wurlod · Post by **ray.wurlod** » Wed Feb 08, 2012 6:32 pm

You left off the quote characters. LIST commands (including LIST.ITEM) are not permitted two file names on the command line.

devnhi · Post by **devnhi** » Wed Feb 08, 2012 6:57 pm

Thanks a lot Ray.I am getting like this :

LIST.ITEM VOC "ProcKeyLookup" 18:53:26 02-08-12 PAGE 1

ProcKeyLookup
001 F
002 ProcKeyLookup
003 ProcKeyLookup/D_ProcKeyLookup

ray.wurlod · Post by **ray.wurlod** » Wed Feb 08, 2012 10:47 pm

It should look like this:
ProcKeyLookup
001 F
002 ProcKeyLookup
003 D_ProcKeyLookup

How was the hashed file created? It seems to me that the VOC entry is corrupted and, if field 3 is correct, so too is the hashed file itself - ProcKeyLookup directory should contain only DATA.30, OVER.30 and .Type30 files.

You'll need to resolve that before you will be able to create any index.

devnhi · Post by **devnhi** » Thu Feb 09, 2012 8:58 am

when I am trying to add voc it is saying :

Error is not a new record. Aborting ...

Seems like the entry is already there .Can we delete the existing entry from voc and start from scratch one more time ?

chulett · Post by **chulett** » Thu Feb 09, 2012 9:04 am

Add the keyword OVERWRITTING to the command.

devnhi · Post by **devnhi** » Thu Feb 09, 2012 2:06 pm

So Do i need to try as :

ED VOC OVERWRITING 'ProcKeyLookup' ;

???

It is not taking OVERWRITING as the filename though

..Anything wrong with my syntax?

ray.wurlod · Post by **ray.wurlod** » Thu Feb 09, 2012 6:26 pm

Suddenly you're using ED ?

The correct syntax to edit the ProcKeyLookup entry in VOC would be

Code: Select all

ED VOC ProcKeyLookup

No OVERWRITING (that's for COPY), no trailing semi-colon (ED is not SQL).

But what are you trying to accomplish?

How about you answer all my questions first, before getting dangerous using an editor you appear to know little about?

devnhi · Post by **devnhi** » Thu Feb 09, 2012 8:13 pm

Hi Ray

The hash file got created using a server job .

I have deleted the hash file completely on the server and ran the server job .After that I have created VOC entry : using the ED VOC command and then tried to create the index , which is failing .

ray.wurlod · Post by **ray.wurlod** » Thu Feb 09, 2012 8:38 pm

Is the hashed file created in the project or in another directory? Please advise the pathname of the hashed file if the second situation obtains.

chulett · Post by **chulett** » Thu Feb 09, 2012 8:53 pm

devnhi wrote:It is not taking OVERWRITING as the filename though ..Anything wrong with my syntax?

I assumed you were creating the VOC record with SETFILE, hence the OVERWRITING comment. No clue why you'd be using ED.