Support Article
Unable to use synonyms in class mapping
SA-84135
Summary
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
- Create a synonym in the Pega Rules database.
- Navigate to Class table mapping.
- Select the database.
- Enter the schema and table name.
- 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) |
Resolution
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
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.