Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Kiran Kumar Boggarapu (KiranKumar Boggarapu)
Wipro
Solution Architect
Wipro
GB
KiranKumar Boggarapu Member since 2010 8 posts
Wipro
Posted: Jun 8, 2022
Last activity: Jun 17, 2022
Posted: 8 Jun 2022 14:15 EDT
Last activity: 17 Jun 2022 1:40 EDT
Closed
Solved

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

To see attachments, please log in.
Pega Platform 8.6.3
Data Management
Data Model
Financial Services
Lead System Architect

Accepted Solution

Posted: 2 years ago
Updated: 2 years ago
Posted: 9 Jun 2022 21:57 EDT
Updated: 17 Jun 2022 1:40 EDT
Guangri Liang (liang)
PEGA
Senior System Architect
Pegasystems Inc.
JP

@KiranKumar Boggarapu

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.

To see attachments, please log in.
Posted: 2 years ago
Posted: 10 Jun 2022 0:54 EDT
Sriharsha Anika (Sriharsha A)
JPMorgan Chase
Sriharsha Anika
JPMorgan Chase
IN

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

To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice