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 run failure when "Sampled segment option" enabled

SA-14695

Summary



An existing segment generating customer count correctly. To restrict customer count to 500, the "Sampled segment option" in "options and schedule" tab is enabled. The segment now generates count as 0 and the segment history displays and segment population error occurs.


Error Messages



PopulateSegmentTable: SQL Error ocurred while populating the segment PopulateSegmentTable: SQL error while populating segment: There was a problem getting a list: code: 936 SQLState: 42000 Message: ORA-00936: missing expression


Steps to Reproduce

  1. Create a Segment
  2. Enable Sampled Segment Option
  3. Run Segment


Root Cause



The segment execution logic references the “Data-Admin-DB-Name • SetDBSpecificInfo” data transform rule from PegaMKT-Engine:07-11-05. The rule for customization has been overridden and the customized rule was missing many of the sets from the out-of-the-box rule.


Resolution



Perform the following local-change:

Add all the missing Set values from the out-of-the-box SetDBSpecificInfo data transform rule into the overridden rule.
Suggest Edit

Published December 21, 2015 - 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