Hi,
I'm trying to save a workflow (WFA 2.1) and get an error message stating
Save Workflow Failure
java.lang.RuntimeException: An unexpected error has occurred while attempting to format SQL. It may be that the SQL provided is not well formed.
This is caused by SQL for a user input, after removing the SQL code I can save the workflow.
Is there a way to work around it? The SQL code is working fine when previewing the workflow.
Thanks,
Nico
And this is the SQL code:
( SELECT quota.target AS target
FROM storage.quota AS quota
WHERE NOT STRCMP('${QuotaType}','Project Folder') AND
SUBSTRING_INDEX(SUBSTRING_INDEX(quota.target,'/',-2),'/',1) IN
( SELECT vol.name AS target FROM storage.volume AS vol
JOIN storage.resource_group_member AS rgm ON rgm.volume_id = vol.id
JOIN storage.resource_group AS rg ON rg.id = rgm.group_id
WHERE rg.name = 'WFA_NAS_ProjectVolumes' )
)
UNION ALL
( SELECT DISTINCT SUBSTRING_INDEX(uquota.user_name,'\\',-1) AS target
FROM storage.user_quota AS uquota
WHERE NOT STRCMP('${QuotaType}','User Home Drive') AND
uquota.user_name LIKE CONCAT('${Domain}','\\\%')
)
ORDER BY target