Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

Support Article

Error occurs on executing RDB-Delete using ConnectSQL

SA-88128

Summary



Error occurs on executing the RDB-Delete using a ConnectSQL containing the 'TRUNCATE TABLE table_name' query. This works if the user manually specifies 'PegaData' before the table name.


Error Messages



There was a problem getting a list: code: 0 SQLState: 42P01 Message: ERROR: relation "table_name" does not exist


Steps to Reproduce



Run the Connect SQL through the RDB-Delete method from an activity.


Root Cause



Postgres database can have multiple schemas within a database.

The database table must be appended with a schema name to determine the schema to which the table belongs to. The issue is not with the Connect SQL within the Pega application. The query is executed if the schema name is not appended to the database table outside Pega as well.


Resolution



Perform the following local-change:

Use the class name instead of the table name when using Connect-SQL.

Pega internally manages the class to the database table mapping and executes the query accordingly.

For example,

truncate table {CLASS:TGB-TestKaru-Work-Assignment}

Published December 2, 2021

Was this useful?

0% found this useful

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.

Did you find this content helpful?

Want to help us improve this content?

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

Pega Community 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
Contact us