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
@liang We are connecting from pegacloud (postgres db) with external oracle database, the schema, table and column names are in upper case in external database and we cant modify that what will be the workaround
