cancel
Showing results for 
Search instead for 
Did you mean: 

Advanced Capstone: 3.6 exercise help

fbibolotti
New Contributor II

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.

fbibolotti_0-1691119419678.png

Also when trying to run queries from remote I get the same error, I don't know what that missing pv is.

1 ACCEPTED SOLUTION

Michaela
Community Manager Community Manager
Community Manager

@fbibolottiThat 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."

View solution in original post

5 REPLIES 5

Michaela
Community Manager Community Manager
Community Manager

Hi @fbibolotti what error are you seeing?

These steps may help 

fbibolotti
New Contributor II

Hi @Michaela, 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

Michaela
Community Manager Community Manager
Community Manager

It might be related to how you loaded your table - see this thread for a suggested solution 

fbibolotti
New Contributor II

Hi @Michaela I can't seem to be able to access to that thread, I'm getting this error

fbibolotti_0-1691484383259.png

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)

 

Michaela
Community Manager Community Manager
Community Manager

@fbibolottiThat 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."