[mwoods]

so sounds like they are not – you will need to load them – this is part of exercise 3.1

[mwoods]

So are the tables defined on that process? as per 3.1? 

hdbH”tables[]”

[mwoods]

try line 127 in your screenshot 

[mwoods]

Expunge .z.pg and then see if you have the tables on the process (using \\x). If you don’t you need to load the f1 database then redefine .z.pg and retry

• This reply was modified 2 weeks, 1 day ago by  mwoods.

[mwoods]

This looks correct – you problem is more likely environmental as when I checked your instance the f1 database was missing, I rebooted and reloaded it and ran this code and 3.6 passes. Please DM me if you continue to have issues

[mwoods]

This looks correct – you problem is more likely environmental as when I checked your instance the f1 database was missing, I rebooted and reloaded it and ran this code and 3.5 passes. Please DM me if you continue to have issues

[mwoods]

• Yes you can reboot yourself, if this happens again – steps are – shut down all running kernals and tabls, from JupyterLab landing page go to File – Hub Control Panel – Stop My Server – then wait and Start Server. The relaunch course

[mwoods]

Replied in DM

[mwoods]

Hi, i rebooted your server. Can you refresh browser and try now?

[mwoods]

u-fail means there is something not quite right with your database structure, that is no longer unique or parted https://code.kx.com/q/ref/set-attribute/#errors

In the case of .Q.MAP in this notebook, the database structure should have 3 table names, par.txt and a sym file.

[mwoods]

.z.pg looks good.

Have you loaded the f1 database to the remote process (5099) as per Q.3.1? Before setting .z.pg you should see some tables when running hdbH”tables[]”

[mwoods]

Can you paste your code for this question here please? Looks good at a glance so could be something small that needs tweaking

[mwoods]

Hi the sandbox underwent an upgrade which means now you can use a python kernal, but you will need the latest version of the notebook. Follow these steps: 
https://learninghub.kx.com/forums/topic/kx-academy-upgrade/

[mwoods]

You should explicitly pass the full database directory path as the first parameter. 

(Hint its given to you in the earlier step with the system command)

[mwoods]

You should not need to filter out 

 time.minute > 09:30

as when creating the buckets the first one will start 09:30 automatically given the dataset begins. You are filtering out some records between 09:30 and 09:31.
Could also do 

 time.minute >= 09:30

to include these.