Question
Error encountered investigating table: Database-NonexistentTable
While connecting to the external database , during the mapping of the external database table class mapping , the database and schema are successfully shown including the table but the table is shown not in existence even though table is displayed in the drop down. For reference see the attachments. Trying to connect with Postgres as external DB.
Hi Team,
- Can you kindly let us know whether the table exists in the DB?
- Can you let me know if this working before? if yes Have you upgrade to the PRPC system or performed any activities on the DB recently?
Regards
Prasanth
Hi Chandra, did u find any solution?? i am also facing the same problem
Hi Chandra,
I faced the same issue, but I tried creating the table with table name in all lower case and it worked for me
I had same issue, fixed by creating table name with lower case letters
I had same issue. It was fixed by mentioning both table name as well as schema name in lower case letters.
Yes , we have seen same issue, and it worked very well with lower case letters
I also faced similar issue. But, worked when I changed the table name in lower case.
Is the issue you're reporting that the table listed on the Database Table Class Mapping screen doesn't exist so it shouldn't be listed?