Support Article
Datatable migration did not update the values on the new column
SA-17481
Summary
Product file (RAP) was created on the source system which had a new column and entries. Same new column was manually created on the target system where RAP was imported using import wizard. But after import new column did not get updated and values for all the rows were null.
Error Messages
Not Applicable
Steps to Reproduce
- Add a new column to the existing table using Alter Table script in the database
- Migrate the data table jar file from Non-prod which has values for the new column
- Notice that the values in the new column on all the rows is still NULL
Root Cause
An issue in the custom application code or rules.
Resolution
Perform the following local-change: There are two ways to solve this issue:
- Delete the Pega marker file and restart the JVM, this will recompile the rule and will update the class mapping with the new column.
- Resave the class/dbtable rule before doing the import of the RAP file, this will update the class mapping with the new column.
Published January 31, 2016 - 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.