Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

Support Article

PegaMkt-Engine Inboundsmsofferflow agent is not running

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.

Suggest Edit

Published July 17, 2017 - Updated December 2, 2021

Did you find this content helpful? Yes No

Have a question? Get answers now.

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

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us