Support Article
Append and Map To lists content are not shown in Data Transforms
SA-8795
Summary
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:
- Open any Data Transform.
- 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’.
Resolution
Run the following query on the database side, to resolve the issue:
LABEL ON PR4_FIELDVALUE(PYFIELDVALUE is 'pyFieldValue');
Before Change:
LABEL ON PR4_FIELDVALUE(PYFIELDVALUE IS ‘Field Value’);
Published June 3, 2015 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.