# Pega is unable to identify external DB tablee

**URL:** <https://forums.pega.com/t/pega-is-unable-to-identify-external-db-tablee/2715>\
**Category:** General\
**Tags:** financial-services, 8-6-3, data-management, data-model, lead-system-architect\
**Created:** [June 8, 2022, 6:15pm UTC](https://forums.pega.com/t/pega-is-unable-to-identify-external-db-tablee/2715 "2022-06-08T18:15:57Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![KiranKumar\_Boggarapu](https://yyz2.discourse-cdn.com/pega/user_avatar/forums.pega.com/kirankumar_boggarapu/32/5264_2.png) [@KiranKumar\_Boggarapu](https://forums.pega.com/u/KiranKumar_Boggarapu)\
**Post date:** [June 8, 2022, 6:15pm UTC](https://forums.pega.com/t/pega-is-unable-to-identify-external-db-tablee/2715/1 "2022-06-08T18:15:57Z")

</div>

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

 ![Class test connectivity error.jpg](https://pega1.discourse-cdn.com/pega/original/2X/2/2794113f143d0da4b0d6893f1c597fb3da3d06f5.jpeg)

 ![External table class wizard access error.jpg](https://pega1.discourse-cdn.com/pega/original/2X/5/5e26f61b37b21beb85ffdffb390dd72df0ec38bc.jpeg)

---

<div class="post-metadata">

**Author:** ![liang](https://yyz2.discourse-cdn.com/pega/user_avatar/forums.pega.com/liang/32/4546_2.png) [@liang](https://forums.pega.com/u/liang)\
**Post date:** [June 10, 2022, 1:57am UTC](https://forums.pega.com/t/pega-is-unable-to-identify-external-db-tablee/2715/2 "2022-06-10T01:57:19Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Sriharsha\_A](https://avatars.discourse-cdn.com/v4/letter/s/b4bc9f/32.png) [@Sriharsha\_A](https://forums.pega.com/u/Sriharsha_A)\
**Post date:** [June 10, 2022, 4:54am UTC](https://forums.pega.com/t/pega-is-unable-to-identify-external-db-tablee/2715/3 "2022-06-10T04:54:32Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![KiranKumar\_Boggarapu](https://yyz2.discourse-cdn.com/pega/user_avatar/forums.pega.com/kirankumar_boggarapu/32/5264_2.png) [@KiranKumar\_Boggarapu](https://forums.pega.com/u/KiranKumar_Boggarapu)\
**Post date:** [June 17, 2022, 5:40am UTC](https://forums.pega.com/t/pega-is-unable-to-identify-external-db-tablee/2715/4 "2022-06-17T05:40:43Z")

</div>

@SriharshaAnika

Thanks for the response

---

<div class="post-metadata">

**Author:** ![Dharanitharan\_ABS](https://avatars.discourse-cdn.com/v4/letter/d/e5b9ba/32.png) [@Dharanitharan\_ABS](https://forums.pega.com/u/Dharanitharan_ABS)\
**Post date:** [October 12, 2026, 3:11am UTC](https://forums.pega.com/t/pega-is-unable-to-identify-external-db-tablee/2715/5 "2026-10-12T03:11:31Z")

</div>

@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
