PegaMKTG Campaign Run continuously writing Offers in File and DB
User configured a simple Campaign which calls Simple Strategy that delivers 1 Offer always and calls a simple Offer flow that has a Write to File and Database. Campaign uses an audience of 799 customers. So users expected 799 customers X 1 Offer each to be written to FIle and to Database table respectively.
However users are seeing that Offer records are continuously being written to both File and Database, with no end. Campaign is already showing "Completed" status but the File & Database both keeps on growing.
Users also seeing increasing number of Outbound BROKEN QUEUES in System Management Application.
No related error in the log file
Steps to Reproduce
1. Run the Campaign writing offers to file output template
2. Segment size is 799 customer records
3. Check in (Marketing Portal -> Configuration -> Settings -> Application Settings -> Channel -> File), it is still in progress and has almost 202K records.
In the problem reported environment, the database user mapped in the “ExternalMKTData” rule not having sufficient privileges to delete the rows from staging table once the record has been written to file/database output file. Because of this issue, Pega Engine is not able to read the MKT_OUTBOUND_STAGING table and not able to delete records from there as part of the Campaign processing. Since the records were not getting deleted, the engine continues reading them and processing the output.
Introduced a Synonym from Pega default user to the Marketing schema user for successfully running the Campaign.
Published September 1, 2016 - Updated August 23, 2017