Unable to use synonyms in class mapping
Unable to use synonyms in class mapping.
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.
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|
Perform the following local-change:
Use a View which provides access to local and remote database tables and views.
0% found this useful