Water coming in, don't know where from
the reason is the shape and location of this ledge:

Therefore, take all the ledge off, look for slits (which are taking water inside from all terrace), seal them and if need, give on edge some suitable profile you can see here:
https://www.riversidesheetmetal.net/flashing-metal/masonry/custom/