Coforge DPA UK Ltd.
Last activity: 16 Feb 2023 7:12 EST
Pega Interaction History not working after dropping the extended column from Channel Dimension table
I have a requirement where I extended Interaction History's channel dimension table by adding new column.
Updated the OOTB data transform pyInteractionHistoryConfiguration to include the new added column. Everything has worked as expected i.e., The new column is being populated with the values without any issues.
Now as part of our organisation process, we dropped the column to test backout scipt & created it again. Now the issue is it is not working at all i.e., even though I'm passing value to the newly added column, it is empty in the channel dimension table.
I tried to clear the cache, restart application server, saved the database table instance etc. but nothing is helping us. I don't understand how the Dimension tables are working. I cleared all the data from channel table and tried, in Fact table the row is having the pzchannelID with old value but the same reference is missing in Channel dimension table.
Any suggestion or help would be appreciated please.
***Edited by Moderator Marije to change type from Pega Academy to Product, added Product details and Capability tags****