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

Append and Map To lists content are not shown in Data Transforms



A system running with DB2 on Z/OS behaves incorrectly when modifying a Data Transform. For an unknown reason, changing the option on the Data Transform generates empty drop down list.

Error Messages

Not an exact error message unless you are trying to save the Data Transform, but the corresponding “Relation” drop-down is empty:

Steps to Reproduce

No internal replication. Following is the scenario:
  1. Open any Data Transform.
  2. Change the first option (“Append To” for example). Observe that the Relation drop-down is empty.

Root Cause

Debug the Activity “@baseclass.GetListOfFieldValues”, the function clears the result page because the key is “null”:

The DBTraces shows an invalid query has been called. On the query “pyFieldValue” is replaced by “Field Value’.


Run the following query on the database side, to resolve the issue:


Before Change:  



Published June 3, 2015 - Updated October 8, 2020

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