Hi, I was working on the advanced capstone exercise, where I need to define .z.pg to block users from using certain functions.
I managed to make the code work, but when I run the .fia.getSummaryReport function for the the `fiauser user, it returns an error instead of showing me the correct result.
Also when trying to run queries from remote I get the same error, I don’t know what that missing pv is.
Hi what error are you seeing?
Hi , the error I’m encountering just says “pv”. Like some function called pv or something is missing. Even when running a normal query with one of the tables that I have to send to the remote server the same error shows up
It might be related to how you loaded your table - see this thread for a suggested solution
Hi I can’t seem to be able to access to that thread, I’m getting this error
This is how I’m loading the tables to the remote server
hdbH:hopen ::5099 hdbH (set;sensor;sensor) hdbH (set;event;event) hdbH (set;lap;lap)
__That is likely your issue - load the entire database rather than individual tables.
Comment from linked thread:
“I ended up resolving this problem, it was a very easy fix. Rather than loading each table individually into the remote process (what I did), the database simply needs to be reloaded through the connection handle using “\l .” Ensure that you are loading into the correct file path (I had to change directory down to the “f1” folder). Hope this helps anyone else who ran into the same issue.”