SA-38895

Summary

A campaign fails to complete. It has been configured to run for more than 30 days, but it fails after 11 days.

Error Messages

2017-05-18 06:00:08,112 [ PegaRULES-Batch-7] [ STANDARD] [ ] [ an_app:01.01.01] (l.access.ConnectionManagerImpl) ERROR - Not returning connection 7 for database "externalmktdata" to the pool as it previously encountered the following error
User ID: System
Last SQL: select count (*) as "pyCount" from schemaname.BatchOutPRXX where pxObjClass = 'Data-BatchOutPRXX'
java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1059)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:522)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:257)

Steps to Reproduce

Start a campaign.

Root Cause

A software use or operation error.

This is a configuration issue. The Pega Marketing PurgeAgent will drop the campaign table based on the PurgeOlderThanDays value.

The Pega Marketing system need to be configured with a PurgeOlderThanDays value covering the campaign period.

Resolution

Adjust the PurgeOlderThanDays value larger that the campaign execution period.