Missing sym file

Community Support
1

Hello, I have a table but I think its missing a sym enum file because when I query it, it looks similar to

time    | sym | ex | price

14:00                    15.5

14:01                    15.43

14:02                    15.55

There is data in the column because when I count distinct syms in the sym column I get a value.

I think its because the sym enum file is missing, is there a way to regenerate it, or fix this table by removing the enum? 

Thanks

2

Is it just you have not loaded the sym file into the process?

In the directory where you enumerated your table against is there a file called sym in there?

If so run this in the process
sym:get `:/pathToSymDirectrory/sym

Thanks Rory

3

Thanks Rory, actually I cant seem to find the sym file, I’m not sure there is one.

4

Is this table loaded off disk?

What commands did you run to save the table down originally?

If you enumerated the table and lost the sym file i’m afraid you are beat. (It’s the worst nightmare of any system losing the sym file)

Thanks Rory

5

You’ll need the sym file loaded in mem to be able to resolve the enumerated columns. If it doesn’t exist in mem or on disk then there isn’t much you can do.If you have the db loaded in another process, it will have the sym list in mem which you can save back to disk(and make a backup). Note whether the db has changed between when that particular version of the sym file was loaded from disk - if so, your indices may not reference the save value in the sym list as before.Do you have the source files available so you can rebuild the db?Are there any tables that contain the unenumerated values that you can link back to the table in question?________________________________________From: personal-kdbplus@googlegroups.com [personal-kdbplus@googlegroups.com] on behalf of Roni Hoffman [hoffmanroni@gmail.com]Sent: 30 October 2016 22:08To: Kdb+ Personal DevelopersSubject: Re: [personal kdb+] Missing sym fileThanks Rory, actually I cant seem to find the sym file, I’m not sure there is one.On Sunday, October 30, 2016 at 5:56:19 PM UTC-4, Rory O’Rorke wrote:Is it just you have not loaded the sym file into the process?In the directory where you enumerated your table against is there a file called sym in there?If so run this in the processsym:get `:/pathToSymDirectrory/symThanks RoryOn Mon, Oct 31, 2016 at 8:15 AM, Roni Hoffman <hoffm…> wrote:Hello, I have a table but I think its missing a sym enum file because when I query it, it looks similar totime | sym | ex | price------------------------------------14:00 15.514:01 15.4314:02 15.55There is data in the column because when I count distinct syms in the sym column I get a value.I think its because the sym enum file is missing, is there a way to regenerate it, or fix this table by removing the enum?Thanks–

Submitted via Google Groups</hoffm…>