Question
Incessant Technologies
IN
Last activity: 11 Nov 2018 15:44 EST
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.
Pegasystems Inc.
US
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?
Pegasystems Inc.
IN
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
Virtusa
AU
Hi Chandra, did u find any solution?? i am also facing the same problem
HCL Technologies Ltd.
IN
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
Amazon
IN
I had same issue, fixed by creating table name with lower case letters
Pegasystems Inc.
IN
I had same issue. It was fixed by mentioning both table name as well as schema name in lower case letters.
Pegasystems Inc.
IN
Yes , we have seen same issue, and it worked very well with lower case letters
Cognizant Technologies Solution
GB
I also faced similar issue. But, worked when I changed the table name in lower case.