Hi Dhanush,

Error Executing Query is usually a DB/query mismatch issue. Quickly check these points first:

• Open Service Center → Monitoring → Errors and check the exact DB error message.
• Test all Aggregates/Advanced SQL individually.
• If using external DB, do Refresh Entities and republish.
• Check recently changed columns/datatypes (especially DateTime/File/Binary fields).
• Verify no NULL value is going into mandatory DB columns.
• Republish dependent modules once.

In most forum cases, the root cause is:

• Entity schema mismatch
• Wrong datatype conversion
• Advanced SQL output mismatch
• Renamed/removed DB column

Share the Service Center error log screenshot if possible — the popup itself is too generic to identify the exact issue.

Thanks and Regards,
Akshay Deshpande