If there is a dice roll, there are stakes. If there are no stakes, there is no dice roll. As such, a failure always has consequences, because otherwise there would be no roll in the first place.
For example, I wouldn’t make a player roll to pick a lock if they were capable and there is no risk...