An execute command that works only on chat

Trying to run the command

"execute as @a if block ~ ~ ~ minecraft:water run scoreboard players set @s objective 100"

in a repeating command block won't work. But it works on chat. Also tried to change the @s to @a, the same thing happened.

The objective is a dummy type.