Missing sym file

[Roni Hoffman]

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

[Rory O'Rorke]

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

--
You received this message because you are subscribed to the Google Groups "Kdb+ Personal Developers" group.
To unsubscribe from this group and stop receiving emails from it, send an email to personal-kdbplus+unsubscribe@googlegroups.com.
To post to this group, send email to personal-kdbplus@googlegroups.com.
Visit this group at https://groups.google.com/group/personal-kdbplus.
For more options, visit https://groups.google.com/d/optout.

[Roni Hoffman]

Thanks 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 process
sym:get `:/pathToSymDirectrory/sym

Thanks Rory

On Mon, Oct 31, 2016 at 8:15 AM, Roni Hoffman <hoffm...@gmail.com> wrote:

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

--
You received this message because you are subscribed to the Google Groups "Kdb+ Personal Developers" group.

To unsubscribe from this group and stop receiving emails from it, send an email to personal-kdbpl...@googlegroups.com.
To post to this group, send email to personal...@googlegroups.com.

[Rory O'Rorke]

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

To unsubscribe from this group and stop receiving emails from it, send an email to personal-kdbplus+unsubscribe@googlegroups.com.
To post to this group, send email to personal-kdbplus@googlegroups.com.

[Michael Keenan]

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...@googlegroups.com [personal...@googlegroups.com] on behalf of Roni Hoffman [hoffm...@gmail.com]
Sent: 30 October 2016 22:08
To: Kdb+ Personal Developers
Subject: Re: [personal kdb+] Missing sym file

To unsubscribe from this group and stop receiving emails from it, send an email to personal-kdbpl...@googlegroups.com<mailto:personal-kdbpl...@googlegroups.com>.
To post to this group, send email to personal...@googlegroups.com<mailto:personal...@googlegroups.com>.