SQL Embedded Query fails but runs fine with sql

My embedded queries for SQL are failing suddenly (as they worked yesterday) with error message
When I open the embedded SQL in browser and run it , it works fine 
 

For your reference this is the query

This behaviour exists for other queries also , I am just randomly posting one

UPDATE [basecamp].[checklist_master] SET PausedUntil = NULL WHERE PausedUntil <= CAST(GETDATE() AS DATE)   AND PausedUntil IS NOT NULL   AND is_deleted = 0;
 

What is the action type and version number?

Action = SQL Script
Version =  6.4.6.7 

Same behaviour for 6.4.6.8

Works absolutely fine here