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 :)

9

Hi @mmcparland , I think I am having the same issue, was this resolved?

10

Hi @silviamat ,

This can happen on individual servers if your data gets corrupted. If you try removing the tables from memory and then re-running the code from the start e.g.

delete nbbo from `.

Let me know if you’re still having issues and I can access your server and reset it for you

Thanks,

Laura

11

Hi @lkerr2 , thanks for the quick reply!
I have tried that as I saw it suggested in the conversation above, but I’m still having the same issue, so please do access the service if you can.

Thank you!

12

Hi @silviamat can you make sure you’ve saved all your code locally and then let me know when you’ve done that and I’ll reset your workspace. Otherwise you might lose your progress.

Thanks,

Laura

13

Hi @lkerr2 , I have it saved already, so you can do it. Thank you!

14

Done! Let me know if you’ve any other issues.

Laura