mkt_work programname column too small
SummaryDeveloper observed that the length of field called programname in table pegadata.mkt_work is 32
But when they name a campaign in Pega Marketing, the system is allowing a campaign name with length greater that 32 characters. Then when they create a report with programname values, the values are being truncated (as the length of the field is 32).
Error MessagesNot Applicable
Steps to Reproduce Create a campaign and provide the name which is greater than 32 characters.Run a report and try to retrieve the same.
Root CauseAn issue in the custom application code or rules : The ProgramName property referenced is not the name entered by the user. ProgramName is set programmatically by manipulating the value specified by the user to make it usable by Pega Marketing internally.
ResolutionHere’s the explanation for the reported behavior:
switch the reports to use the pyLabel property instead of ProgramName property . This will give the user entered name for the Campaign.
Published April 10, 2017 - Updated April 21, 2017