So if you break it down: all the faith he had(past tense) had(possessive) had(past tense) had(past tense) no effect on the outcome of his life
While grammatically correct would be better phrased as: all the faith he used to have, had no effect on the outcome of his life.
But I’m not a writer or...