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

Segment is in the Running state and does not stop

SA-57028

Summary



When a Segment is run, the Segment is in the Running state and does not end. This occurs when using two Date range criteria in a Segment on the same property.


Error Messages



Not Applicable


Steps to Reproduce

  1. Create a segment.
  2. On the same segment, use two Date ranges in two criteria .
  3. Run the segment. The segment is running; however, it does not end.


Root Cause



A defect in Pegasystems’ code or rules.

The query generated takes days to execute. 
Without the final OR (another date range) condition, the query completes execution in two seconds. The final OR condition joins the same table and leads to a Cartesian join.

 

Resolution



Perform the following local-change:
  1. Create two sub-segments for each of the Date Criteria individually.
  2. Reference the sub-segments in the main Segment with an OR condition.
Alternatively, update to the Pega Marketing 7.4 for query optimization.
 
Suggest Edit

Published August 24, 2018 - 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