How is your experience with the OutSystems Community?
22
Views
7
Comments
Solved
Error Executing Query

Hi, i have been facing issues with both service studio and online platform outsystems and both of them showing the same error. Can someone please tell me the solution for it. Its been 2 days and showing the same error.



Screenshot 2026-05-27 114725.png
Screenshot 2026-05-27 113905.png
2024-01-31 05-29-41
Akshay Deshpande
Solution

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

UserImage.jpg
Dhanush Aravind Kannan

Hi Akshay,

I have pasted the screenshot of the Service center error message, if its possible please check it out and tell me the root cause of the error

Thanks and Regards,

Dhanush Aravind

Screenshot 2026-05-27 144531.png
UserImage.jpg
Dhanush Aravind Kannan

Hi Sudip,

The issue has been solved i have followed your advice and found the error thanks for helping.

Thanks and Regards,

Dhanush Aravind

2023-09-06 07-26-35
Sudip Pal

Hi @Dhanush Aravind Kannan 

for browser try clearing the cache and cookies and you can raise a support ticket to OS as well if the problem in browser persist.

If it is your personal env then try to reinstall the service studio.

Thanks,

Sudip 

UserImage.jpg
Dhanush Aravind Kannan

Dear Sudip,

I have cleared clache and cookies and still error is not solved and whenever i try to raise a ticket its asking for a "Infrastructure Activation Code" but i dont have it.

Thanks,

Dhanush Aravind

2023-09-06 07-26-35
Sudip Pal
UserImage.jpg
Dhanush Aravind Kannan

Hi Sudip,

The issue has been solved i have followed akshay's advice and found the error thanks for helping.

Thanks and Regards,
Dhanush Aravind




Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.