You either used the keyword DISTINCT more than once in a subselect, or it
you did not place it directly before the column select list.
Restriction: This topic applies only when the AppMaster Builder AddPack has been installed, and applies only to Windows platforms.
Resolution:
Check syntax. Do not use DISTINCT more than once in a subselect. In addition,
DISTINCT must precede the column select list.