Support Article

mkt_work programname column too small

SA-36253

Summary



Developer 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 Messages



Not 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 Cause



An 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.

Resolution



Here’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

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.