The Poisson equation on manifolds with positive essential spectrum