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

Unable to use synonyms in class mapping



Unable to use synonyms in class mapping.

Error Messages

Class your-class is mapped to table your_schema.your_synonym in database PegaDATA, which does not exist

Steps to Reproduce

  1. Create a synonym in the Pega Rules database.
  2. Navigate to Class table mapping.
  3. Select the database.
  4. Enter the schema and table name.
  5. Save the instance.

Root Cause

A third-party product issue.

Synonym objects in MS SQL do not return Catalog information in the same manner as the Base tables and views. They are also not visible to IntelliSense, the SQL code completion facility in SQL Server Management Studio. This is because the Synonym are for either of the following object types,
Assembly (CLR) Stored Procedure  Assembly (CLR) Table-valued Function
Assembly (CLR) Scalar Function Assembly Aggregate (CLR) Aggregate Functions
Replication-filter-procedure Extended Stored Procedure
SQL Scalar Function SQL Table-valued Function
SQL Inline-table-valued Function SQL Stored Procedure
View Table1 (User-defined)


Perform the following local-change:

Use a View which provides access to local and remote database tables and views.

Published August 19, 2019 - Updated October 8, 2020

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