Closed
Solved
Connection Problem: Class is mapped to table which contains no columns.
Hello,
We are on Pega 8.5.6 and getting this error when i click on "Test Connectivity" in Non-prod and the same works fine in PROD. DBA has dropped the Synonym and re-created it still getting error.

***Edited by Moderator Marissa to add Capability tags***
To see attachments, please log in.
@NAYANIS1 This error typically occurs when Pega Platform cannot find any columns in the database table to which your class is mapped. This could be due to a number of reasons, such as incorrect table mapping, issues with database permissions, or problems with the database schema. Since the issue is not present in your production environment, it's likely a configuration issue in your non-production environment. Please double-check your database table mapping and ensure that the table in question does indeed have columns. Also, verify that the database user has the necessary permissions to access the table.
⚠ This is a GenAI-powered tool. All generated answers require validation against the provided references.
key mismatch
Error accessing database tables in external database
Pega is unable to identify external DB tablee
BadTableMappingException
Creation of new DB table from pega , provided we are not using datatype rule .