Enhanced query failure

[tejpusal]

I am trying to update the email template body of few emails where I can find a specific email id inside the body induced as hyperlink. I have developed a query just to check for 1 template and here it is

select name as ecmemailtemplate__primarykey, replace(templatecontent, '***', '###') as ecmemailtemplate__templatecontent from ecmemailtemplate where templatecontent like "%**%" and name= "##";

The above query is working fine in preview and i am seeing the results I want. When I try to run it , it is failing with message stating 

2024-07-08T12:55:00.295856299Z stdout F 2024-07-08 12:55:00,295 [quartzScheduler_Worker-7] ERROR utility.CustomQueryService  - Exception Inside transaction: named capturing group is missing trailing '}'

No matter how many times I change the query , I am getting same error and everytime the preview is successful. 

Can anyone help me understand the situation here ?

Thanks in Advance!

[Raghu]

@tejpusal  try below

SELECT
name AS ecmemailtemplate__primarykey,
REPLACE(templatecontent, '***', '###') AS ecmemailtemplate__templatecontent
FROM
ecmemailtemplate
WHERE
templatecontent LIKE '%**%'
AND name = '##';

[rushikeshvartak]

• I have also seen same issue only for templatecontent column 
• Please raise defect with saviynt support