Pega is unable to identify external DB tablee

Though the External DB and Schema exists. Pega says DB table does not exists. However, I was able to see the tables in “New External Database table class mapping” / “Modify Schema”

Database connectivity test successful. But getting the following errors

“Table DocumentMgmt.DMCasesMapping does not exist in database pega86r2-dev” in Modify Schema

Attached Error Files

@KIRANGEM

Is the database type that you are using is PostgreSQL?

I got the same error when there are some uppercase letters in table name , after changed the table to all lowercase letters, the error disappeared.

@KiranKumar Boggarapu Also please verify if the user that is used to establish the connectivity has enough privileges to access table ,read the table. even if the respective grants are missing then you would end up in error.

@SriharshaAnika

Thanks for the response