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.
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.
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:
LABEL ON PR4_FIELDVALUE(PYFIELDVALUE is 'pyFieldValue');
LABEL ON PR4_FIELDVALUE(PYFIELDVALUE IS ‘Field Value’);
0% found this useful