Error creating SQL Processor (but works with admin user)

Error creating SQL Processor. Works with admin user. Gives weird Error message.
Error Message:

The sql execution mode is not set. please contact your administrator

This message can be shown in the legacy Lenses agent UI. Create a SQL processor via HQ’s UI under “Apps” instead.