Support Article
Pega Communication Applications Instances are unable to import
Summary
While importing Pega Marketing For Communications (PMC) 7.13, user was unable to import the pre-requisite framework applications instances such as CFF and PMC.
The issue observed was due to the "pyDescription" column. The actual data for the column is 256 while the column size is 255 (Table: PR4_RULE Column: PYDESCRIPTION).Error Messages
Actual size is 256, maximum is 255 for column pydescription in PR4_RULE table.Steps to Reproduce
Try importing the "CFF_ApplicationBundle.jar" of CFF V717 and "PegaMarketingForCommunications713.jar" of PMC V713.
Application Instance Details:
- PEGAMARKETINGFORCOMMUNICATIONS 07.13.01
- PEGANBAMC_FW 07.11.01
- CFF 07.xx.xx
Root Cause
The issue is with the history of these rule instances are more than expected length (255). When one enters history details more than 255 characters (text area) in Application rule form in development instance (Pega Communication Framework Dev instance), it’s able to save data but the data in pyDescription column is only 255 and it will not throw any error, whereas in the BLOB, it’s still the actual data (in Rule xml).
Now, when one takes the product package from this development instance, it still holds actual data, but not the 255 characters data as Pega will generate the RAP from the BLOB of the tables, but not from the exposed columns.Resolution
Perform the following local-change:
Increase the pyDescription column length in PR4_RULE table to 1000.
Published February 9, 2016 - 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.