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

Recurring schedule to finalize Outbound DB Template doesn't work



An outbound database template rule is scheduled to Finalize everyday. Data is written to the destination table during the first execution. However, the second execution is not initiated. This occurs because a broken queue item is generated after the first scheduled execution.

Error Messages

<pxErrorMessage>Table SOMETABLE does not exist in database ExternalMKTData</pxErrorMessage> is being found in the broken queue item xml of type System-Queue-ScheduledTask.

Steps to Reproduce

  1. Create an outbound database template rule.
  2. In the Finalize tab of the rule, configure a recurring schedule.
  3. Use the database template in an Offer flow or a Campaign.
  4. Run the campaign. Verify the first Finalization of the rule at the scheduled time and verify if data is loaded in the destination table. Check the broken queue item (System-Queue-ScheduledTask type). Verify if the rule is finalized and written to the second schedule. 

Root Cause

A defect in Pegasystems’ code or rules.

There is no StepStatusFail handling in the Obj-Open of the finalized class' database table rule or a check if the database table existed. That is, if the FIRST finalization is performed through the schedule, the StepStatusFail (as the 'old' finalized class does not exist) is triggered. Therefore, the queue item used for the next execution is resaved in a Broken-Process state due to an invalid Final activity status.


Apply HFix-47040.


Published January 4, 2019 - Updated December 2, 2021

Was this useful?

0% found this useful

Have a question? Get answers now.

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

Did you find this content helpful?

Want to help us improve this content?

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