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

Properties set in the strategy are not written in the SQL table



For a strategy using real time event, the values given to properties in the strategy are not recorded in the mkt_event<P…> table. Properties being set in the strategy are IMEI and TAC. This strategy sends forward the info from one shape to the next. Nothing is written in the columns of the result table of the program.

Error Messages

Not Applicable.

Steps to Reproduce

1. Run a Marketing Event Program.

2. Send SOAP messages to trigger the program.
3. Inspect the Event tables for the said properties value.

Root Cause

The root cause of this problem is software use/operation error. There are two related issues here:

The Marketing event program are triggered using SOAP requests and the existing SOAP Request structure has been changed to add two more properties but the revised WSDL has not been republished for clients to send the additional fields.

A Decision Table is used in the Strategy that uses the above properties. When the properties are not set, the decision table condition returns true. This behavior arises because of the usage of @(Pega-RULES:String).contains(...) function.


Following Local-change resolves the issue:

1. Regenerate the WSDL and update all the SOAP clients to use the updated WSDL with additional properties.
2. Use additional check in the Decision Table condition. for example:
        (@length(<current-value>)>=1) && (...other conditions...)


Published January 31, 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