Adempiere - Table not found AD_System

Question

This question is for those who have experience with Adempiere ERP.

when logging in, I get the error table ad_system is not found. connecting to Postgresql I can see the database along with the table name. not sure why it says so. anyone else experienced the same issue?

my Postgres user does have superuser permissions

[error message on login]

Answer 1

Try to query the database to see if it has data or if it's empty, for example:

SELECT * FROM AD_System

or

SELECT * FROM C_BPartner

That error usually appears when you do a bad DB restoration and the DB Tables are empty.