Support Article
Unable to insert data in the database after schema changes
SA-48506
Summary
Unable to insert data in the database after schema changes. The user configuration has an external table with column,YOUR_COLUMN_NAME, and an exposed property, your_column_NAME.
Error Messages
com.pega.pegarules.pub.database.BadTableMappingException: Database-BadTableMapping-TooManyProperties your_data_class your_schema.your_table PegaDATA your_column_NAME
Steps to Reproduce
Unknown.
Root Cause
A defect in Pegasystems’ code or rules. Two properties in the class hierarchy have the same name. As a result, during data retrieval from the database to determine the mapping for the table, an incorrect property is chosen and the mapping fails.
Resolution
Perform the following local-change:On the External Mapping tab for the class, explicitly map the column to the property. In this case map column YOUR_COLUMN_NAME to property your_column_NAME
.
Published March 8, 2018 - 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.