PCC error “[LNA][PSQL][SQL Engine][Data Record Manager]No such table or object.”

SOLVED

Hi Guys,

I am I have a client using pastel19 and I am trying to view their data in PCC but for some reason, there are no tables. If I open Pastel directly, there are customers, products invoices, etc. How can I resolve this to be able to view and query these tables in PCC? The error below occurs when I run "Select * from CustomerMaster"

  • +1
    verified answer

    Good day Tatenda,

    We do not provide assistance for queries related to PCC. However, we suggest that you delete the database, copy the data locally and create the database locally as well.

    You can also visit the Actian community for advice relating to this error: https://communities.actian.com/s/

    Please verify or reply and let us know if the suggestion provided helped in resolving your query.

    Regards,