Norwich City Council has been criticised after a "staggering" blunder left a man without a fire-safe front door for more than two years.