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

Cannot create a sample based on association



User Query:

When creating a Sample on a base level - "Customer" and trying to use properties in the association (Contract) getting an error message. 

Does that mean if the "Customer" has Contracts, user cannot create a Sample (and hence an Analysis project) on data from the Contract?

Error Messages

ORA-00933: SQL command not properly ended

Steps to Reproduce

1. In Pega Marketing, navigate to configuration> Segmentation Support:
2. Create a new Sample:
     a. Anticipated size : 10%
     b. Sample Strategy: Random
     c. Sample Fields: Select only Title and Gender
3. Save and run.

Root Cause

This is a known issue in the current version of the Pega Marketing product.

Although, this error is reported upon pressing the Run button prior to execution, it does not prevent the Sample from being Run. 


This issue has been fixed in upcoming version of Pega Marketing 7.21.

User can still click Confirm in the Sample Run modal window. The Sample runs correctly and has correct results.

​After that, user must be able to reference this Sample in an Analysis Project and run that.

Published February 9, 2016 - 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