Support Article
Multiple properties mapped to the same column in the database
SA-48640
Summary
Database Class Mapping tool creates duplicate entries in the database.
Error Messages
Not Applicable
Steps to Reproduce
- Navigate to Designer Studio > Data Model > Classes & Properties > Database Class Mappings.
- Click the New external data base table class mapping button.
- Select the below options:
Database - PegaDATA
Table - pr_history
Class - PegaSample_Data-pr_history
Columns are mapped to the properties. In particular, pyLabel > pyLabel and pyMemo > pyMemo. - Change pyMemo to map to pyLabel, such that two columns map to the same property.
- Click Submit.
Root Cause
A defect in Pegasystems’ code or rules. Incorrectly mapping two different properties to the same column produces two rules having the same name with pzInsKey differing by only a few milliseconds.
Resolution
This behavior is currently not supported and is scheduled to be supported in a future Pega release.
Published March 21, 2018 - Updated December 2, 2021
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.