Issue resetting KX sandbox to undo file deletion

Academy Support
1

https://learninghub.kx.com/forums/topic/issue-resetting-kx-sandbox-to-undo-file-deletion

Hi, I think the table in the Level 2 Capstone Project may be corrupted as it is missing a sym file and I'm not sure how to proceed. Any advice or capability to reset the workspace to regenerate the table would be greatly appreciated. James

2

Hi @jamesthompson 

Can you tell me what table it is please?

3

Hi Megan,

The workspace has three tables nbbo, spread and trade.

I can only access the meta of spread so I think it has affected both nbbo and trade tables.

James

4

I would recommend running:

delete nbbo from `.

This will remove the table from memory and to reload the table run your code from exercise 1.1 again.

Let me know if you have any questions about this!

5

Thank you for the fast reply,

I've attempted the command you gave for both nbbo and trade, but the issue appears to be persisting. I think the issue might involve

key hsym `$getenv[`HOME],"/fundamentals_capstone_dbs"

returning 

`s#`2020.08.03`2020.08.04`2020.08.05`2020.08.06

and not including sym, as meta nbbo returns ..sym, but I'm not sure.

James

6

Hi @jamesthompson 

Are you still experiencing this issue? If so, can I access your server to take a closer look?

Thanks!

7

Hi Megan,

I'm afraid I am still experiencing the issue, please do access the server and take a look.

James

8

Hi @jamesthompson 

I've sent you a private message about this :)