Is it one and done or can I come back and the same people that failed will try again (without leveling in-between)? Because I assume it is a dice roll in the background so sometimes it will work and sometimes it doesn't. I think it is dumb to have to reload until it works. I originally thought it was just based on a simple stat like intelligence or wisdom until reloading actually worked to get the result I wanted with the same character that failed before. There has to be some sort of RNG involved.
I would like to know if I can force a new check somehow if I fail originally? This is for like finding illusionary walls etc
Pre-patch you could leave the area and come back again for new checks in most places. Not sure now. I make sure there is a high-peception character in the party all the time. (automatic checks)
As for interaction checks (e.g. druid sanctum murals) they seem to be available once per party member or once per human part member (multiplayer). I haven't had any option to interact with them again.