Support Article
Data Type columns are not populated
SA-55470
Summary
When importing a data type using CSV, values do not display for the Key Column.
In the database, column does not display values. However, on opening the instance and viewing the XML property, the values are present. That is, the BLOB has the values, but the exposed column does not display the values.
Error Messages
Not Applicable
Steps to Reproduce
- Create a Data Type.
- Add Properties.
- Configure the data source.
- Export the CSV and import after adding entries.
Root Cause
An issue in the custom application code or rules.
Two properties exist with the same name. However, the name for one property is in Camel case while the other is in lower case.
For example:
Property 1: TestProp
Property 2: testprop
TestProp is present in @baseclass and testprop is present in the data class which is optimized. Pega does not recommend this type of duplicate properties. Thus, the properties are mapped incorrectly to the database columns. That is, TestProp is mapped to the database column instead of testprop.
Resolution
Perform either of the following local-changes:
- Add the external mapping in the data type class.
- Delete the property from @baseclass. This must be deleted from all the environments as the deletes are not exported.
Published September 11, 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.