[Laura]

Hi @jme76 ,

Your first line is fine, but to load the database on the remote process, you need to use your handle hdbH e.g.

hdbH "code to load data"

Edit to say: You can check it yourself by running

hdbH "tables[]"

Hope this helps!

Laura

• This reply was modified 6 days, 19 hours ago by  Laura.

[Laura]

Hi @harshit-raghuvanshi ,

I can see that passcodes have now been sent out to you and several of your colleagues for the KDB courses.

If there are any outstanding certificates let me know, you can email me directly at communitymanager@kx.com.

Thanks,

Laura

[Laura]

Hi @thetourist ,

Glad to hear you figured it out!

Any other issues please don’t hesitate to reach out.

Thanks,

Laura

[Laura]

Hi,

Thanks for flagging! There was an outage on our end, but it has been resolved now.

Thanks again,

Laura

[Laura]

Hi @masma,

Thanks for flagging! There was an outage on our end, but it has been resolved now.#

Thanks again,

Laura

[Laura]

Hi, I can see you’ve received your passcode now so you can enter it in the quiz and receive your certificate.

Congratulations on completing the KDB Developer Level 3 Course!

Laura

[Laura]

Hi @kal8na,

I’m not sure without looking at your code, but for 5.2 you will need to ensure you are using fby or similar. You can watch this video to get a better idea of how to approach this: Fby Vs. Nested Queries – KX Learning Hub

Hope this helps,

Laura

[Laura]

Hi,

Your code looks mostly correct.

You have a typo in your .z.pw function, you’re using “user” instead of “usr” to check the password.

Let me know if that resolves things.

Thanks,

Laura

[Laura]

Hi @kal8na ,

There is a typo in your line

save `:getenv[`AX_WORKSPACE],"/badTrades.csv"

You’re missing the $ operator.

I can help clarify what’s being asked in 4.6.

You will need to use the xbar function to create the edge15 table, and then use exec to extract the fields you need for the timeseries dictionary. It should be a simple

timeseries: exec ... from edge15

Hope this helps!

Laura

[Laura]

Your code for 3.2 is mostly likely fine as the test for 3.2 is passing.

The tests that are failing are 3.3, 3.4 and 3.6 so I would need to see the code for those exercises. It is likely that your code for 3.3 is incorrect it has impacted the rest of this section.

Thanks,

Laura

[Laura]

Hi @masmail ,

Have you loaded the dbmaint.q script?

If you haven’t you might get an error message popping up that renamecol is not defined?

Thanks,

Laur

[Laura]

Hi @harshit-raghuvanshi ,

the “access” error will be thrown in those tests if you have not set up the IPC correctly.
I would recommend going through the Advanced IPC module on KX Academy if you haven’t already.

If you are stuck on a particular aspect of section 3 feel free to send through some of your code and I can help further.

Thanks,

Laura

[Laura]

Hi @harshit-raghuvanshi ,

I can see from your screenshots that you still have a directory called “f1” within your HDB that shouldn’t be there. I would recommend deleting this as I’ve mentioned above and seeing if that resolves your issue.

Calling

get hsym `$getenv[`AX_WORKSPACE],"/f1"

should only show the two dates and the sym file, as in the attached image.

Hope this helps,

Laura

• This reply was modified 1 month, 1 week ago by  Laura.
• This reply was modified 1 month, 1 week ago by  Laura.
• This reply was modified 1 month, 1 week ago by  Laura.
• This reply was modified 1 month, 1 week ago by  Laura.

[Laura]

You can use the system keyword to remove the erroneous f1.

You should only have the sym file and your two date partitions in your database.

Then you can use .Q.chk to fill the table in the other date partition

Hope this helps,

Laura

[Laura]

Hi,

Within your window join, you are selecting from sensor instead of the sensorInput parameter you’ve passed into the function. This could be what is creating incorrect values in your table.

Hope this helps!

Laura