KX Community

Find answers, ask questions, and connect with our KX Community around the world.

Home Forums KX Academy Advanced Capstone: 3.6 exercise help

  • Advanced Capstone: 3.6 exercise help

    Posted by fbibolotti on August 4, 2023 at 12:00 am

    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.

    fbibolotti replied 2 months, 2 weeks ago 2 Members · 1 Reply
  • 1 Reply
  • Laura

    Administrator
    August 8, 2023 at 12:00 am

    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.”

Log in to reply.